Oracle Oracle Certifications 1Z0-931-21 Questions & Answers

• Question 101:

  Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

  A. Backup and recovery must bedone using Recovery Manager(RMAN).

  B. Select the snapshot of the backup.

  C. Select the archived redo logs.

  D. Select the backup from which restore needs to be done.

  E. Specify the point in time (timestamp) to restore.

  Correct Answer: DE

  In theRestore prompt, select Specify Timestamp or Select Backup to restore to a point in time or to restore from a specified backup.

  https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/backkuprecover.html#GUID-78C28C41-AA87-4AD7-BEB6-693235C73F3C

  

• Question 102:

  A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment.

  What should theydo to remove this bottleneck?

  A. Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.

  B. Remove any non-JSON data from the database.

  C. Increase the number of OCPUs allocated to the database.

  D. Ask Support to migrate their setup to a node without noisy neighbors.

  Correct Answer: D

• Question 103:

  Which statement is NOT correct when setting up compartment quotas?

  A. There are three types of quota policy statements which are set, unset and zero.

  B. Compartment quotas use policies that allow allocation of resources with ahigh level of flexibility.

  C. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.

  D. Compartment quotas are set by Oracle.

  Correct Answer: D

  https://docs.oracle.com/enus/iaas/Content/General/Concepts/resourcequotas.htm

  

• Question 104:

  What are three methods to load data into the Autonomous Database?

  A. Oracle GoldenGate

  B. Transportable Tablespace

  C. RMAN Restore

  D. Oracle Data Pump

  E. SQL*Loader

  Correct Answer: ADE

  https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb- faqs.html#ATPD

  https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-dataintro.html#GUID-5D2F70D8-4FA1-482C-BFB0-43441FB897F3

• Question 105:

  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. SQLDEV_ADMIN.GRANT_SCHEMA

  B. ORDS_ADMIN.ENABLE_SCHEMA

  C. ORDS_ADMIN.GRANT_SCHEMA

  D. ORDS_PRIV.ENABLE_SCHEMA

  Correct Answer: B

  As an alternative, the ADMIN can provide Web Access for a user, RESTenable a user, with SQL

  commands. As the ADMIN user run the following code:

  BEGIN

  ORDS_ADMIN.ENABLE_SCHEMA(

  );

  COMMIT;

  END;

  /

  https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/sql-developer- web.html#GUID4B404CE3-C832-4089-B37A-ADE1036C7EEA

• Question 106:

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

  A. DOC

  B. AVRO

  C. JSON

  D. DDL

  E. Dcsv

  F. Parquet

  Correct Answer: BCEF

• Question 107:

  Which option should you use to create a graph with Graph Studio?

  A. A graph license key

  B. NoSQL configuration

  C. Graph created by a special tool downloaded from oracle.com

  D. Graph analytics algorithms

  E. Tables in an Autonomous Database instance

  Correct Answer: E

• Question 108:

  Which two options are available to restore an Oracle Autonomous Database?

  A. Select the backup from which restore needs to be done.

  B. Specify the point in time (timestamp) to restore.

  C. Select the snapshot of the backup.

  D. Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up.

  E. Specify the archived custom image.

  Correct Answer: AB

• Question 109:

  The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?

  A. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,

  B. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure

  C. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database

  D. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure

  Correct Answer: C

  Explanation: https://docs.oracle.com/en/cloud/paas/autonomous- database/atpfg/components.html#GUID268B36E1-87D8-4649-A370-226E2AE3FC5C

• Question 110:

  Which statement is FALSE about setting up compartment quotas?

  A. Quotas set on a parent compartment override quotas set on childcompartments.

  B. Compartment quotas cannot be set on the root compartment.

  C. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.

  D. You cannot manage quotas in a compartment, unless you belong to a group that has the correct permissions.

  Correct Answer: B