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

• Question 101:

  Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?

  A. Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remain in their current compartments.

  B. Moving an Autonomous Database instance does not include its automatic backups.

  C. You do not need to have sufficient access permissions on the compartment that the resource is being moved to.

  D. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.

  Correct Answer: A

  https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/databaseoverview.htm#moveRes

• Question 102:

  What is the roleof a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?

  A. Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.

  B. Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.

  C. Fleet Administrators are responsible for patching and backups of all container databases.

  D. Fleet Administrators create, monitor and manage Autonomous Databases.

  Correct Answer: B

  https://docs.oracle.com/en/cloud/paas/autonomous- database/adbah/index.html#articletitle https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/index.html

• Question 103:

  Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

  A. TPPERFORMANT

  B. MEDIUM

  C. HIGH

  D. LOW

  E. TPURGENT

  Correct Answer: A

  https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID- 80E464A7-8ED445BB-A7D6-E201DD4107B7

• Question 104:

  Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

  A. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.

  B. The source files can reside inOracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.

  C. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

  D. The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.

  E. The target table will be created in Autonomous Database if it does not already exist.

  Correct Answer: BC

  https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/file-uriformats.html#GUID-5D3E1614-ADF2-4DB5-B2B2-D5613F10E4FA

  https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms- cloud.html#GUID9428EA51-5DDD-43C2-B1F5-CD348C156122

• Question 105:

  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 106:

  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 107:

  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 108:

  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

• Question 109:

  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 110:

  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