Oracle 1Z0-931-25 Online Practice Questions and Exam Preparation

Oracle 1Z0-931-25 Online Questions & Answers

• Question 81:

  Which two are correct actions to take in order to download the Autonomous Database Credentials? (Choose two.)

  A. Click the compute section of the menu, then choose instance configurations, then download wallet
  B. Find the service console for your Autonomous Database, then pick administration, then download the credential wallet
  C. Click on the Object Storage and find your Autonomous bucket and download the wallet credentials
  D. Click on the Autonomous Database in the menu, click a database name, then choose DB Connection button, then download the wallet
  B. Find the service console for your Autonomous Database, then pick administration, then download the credential wallet
  D. Click on the Autonomous Database in the menu, click a database name, then choose DB Connection button, then download the wallet

• Question 82:

  When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?

  A. Under Core Infrastructure then Compute then Autonomous Exadata
  B. Under Database then Autonomous Transaction Processing then Autonomous Exadata
  C. Under Solutions and Platforms then Platform Services then Autonomous Exadata
  D. Under Core Infrastructure then Autonomous Exadata
  C. Under Solutions and Platforms then Platform Services then Autonomous Exadata

• Question 83:

  Which native data type is used to store spatial information?

  A. SDO_GEOMETRY
  B. SDO_LOCATION
  C. SDO_RELATE
  D. GEO_JSON
  A. SDO_GEOMETRY

• Question 84:

  Which four file formats are supported when loading data from Cloud Storage?

  A. DDL
  B. AVRO
  C. Parquet
  D. DOC
  E. JSON
  F. CSV
  B. AVRO
  C. Parquet
  E. JSON
  F. CSV

• Question 85:

  What predefined user is created when provisioning an Autonomous Database (ADB) instance to which you connect to create other users and grant roles?

  A. SYS
  B. ADMIN
  C. DWDEV
  D. SCOTT
  B. ADMIN

• Question 86:

  To whom, and in which order, are dedicated Exadata Infrastructure resources provisioned?

  A. Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB - > Database Administrator -> Autonomous DB
  B. Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB
  C. Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure
  D. Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB
  A. Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB - > Database Administrator -> Autonomous DB

• Question 87:

  For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?

  A. ORDS_ADMIN.GRANT_SCHEMA
  B. ORDS_ADMIN.ENABLE_SCHEMA
  C. ORDS_PRIV.ENABLE_SCHEMA
  D. SQLDEV_ADMIN.GRANT_SCHEMA
  B. ORDS_ADMIN.ENABLE_SCHEMA

• Question 88:

  What is a best practice when planning and instituting access controls for your Autonomous Dedicated environment regarding subnets, compartments, and user groups?

  A. Only 1 subnet and 1 compartment are allowed, multiple groups highly advised.
  B. Only 1 of each is allowed to be allocated per environment.
  C. Create a separate VCN that contains only public subnets.
  D. Create at least 2 of each resource.
  D. Create at least 2 of each resource.

• Question 89:

  Which management operation is correct about Autonomous Databases on Shared Exadata Infrastructure?

  A. You can skip a scheduled maintenance run. For Autonomous Database on Shared Exadata Infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed
  B. You can perform a "rolling restart" on all the Autonomous Databases. During a rolling restart, each node on the Autonomous Database is restarted separately while the remaining nodes continue to be available
  C. You cannot configure the scheduling for your Autonomous Databases on Shared Exadata Infrastructure
  D. You can choose to use Release Update or Release Update Revision updates for your Autonomous Databases on Shared Infrastructure
  C. You cannot configure the scheduling for your Autonomous Databases on Shared Exadata Infrastructure

• Question 90:

  Where are the customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?

  A. In a separate key vault external to the Exadata infrastructure
  B. Inside the Autonomous Database wallet
  C. On the Exadata infrastructure where the Autonomous Database Dedicated is hosted
  D. Inside the backup of the container database
  A. In a separate key vault external to the Exadata infrastructure