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

• Question 41:

  Which statement is true about the use of Access Control Lists (ACLS) with an Autonomous Database on Shared Infrastructure?

  A. When you restore a database, the existing ACLs are not overwritten by the restore.

  B. An ACL can only be set during the creation of an Autonomous Database on Shared Infrastructure.

  C. ACLs can only be used with private endpoints.

  D. An ACL can be set up for an IP address or a virtual cloud network (VCN) but not both at the same time.

  Correct Answer: A

• Question 42:

  What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?

  A. Users have OS access to the database machine.

  B. Users can customize the maintenance schedule.

  C. It offers greater control and isolation starting at theExadata cloud infrastructure level.

  D. Users have SYS privileges in the database.

  E. Users can customize the OS stack and add additional packages

  Correct Answer: BC

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

  

• Question 43:

  How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?

  A. It cannot be done.

  B. Using Database Configuration Assistant (DBCA) on the database server.

  C. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

  D. Connecting to the Cloud Infrastructure Command console via SSH wallet.

  Correct Answer: C

  The CLI is a small footprint tool that you can use on its own or with the Console to complete Oracle Cloud Infrastructure tasks. The CLI provides the same core functionality as the Console, plus additional commands.

  https://blogs.oracle.com/datawarehousing/managing-autonomous-data-warehouse-using- oci-curl

  Examples of using Autonomous Database managing by REST API

  https://oracle.github.io/learning-library/workshops/autonomous-transaction- processing/ LabGuide900ConfigureOCI-CLI.md

• Question 44:

  You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should youdo?

  A. Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database

  B. Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END"

  C. Create a notification alert using DBMS_SNMP package

  D. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric

  Correct Answer: B

  

• Question 45:

  While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?

  A. 60 days

  B. 7 days

  C. 15 days D. 120 days

  Correct Answer: D

• Question 46:

  During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?

  A. the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator

  B. the Client Credentials wallet which is used to connect to the Autonomous Database

  C. the 'High Availability Container Database' in which the Autonomous instance should run

  D. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment

  E. the Listener endpoint where the Autonomous Database should register on

  Correct Answer: C

  https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adb_dedicated_creating.htm

• Question 47:

  

  Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?

  A. Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.

  B. You can use the dbms_auto_index package to report on the automatic task and to set your preferences.

  C. It is enabled by default.

  D. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.

  E. The indexing feature is implemented as anautomatic task that runs at a fixed interval.

  Correct Answer: C

  https://docs.oracle.com/en/cloud/paas/autonomous- database/adbsa/autonomous-auto-index.html#GUIDD51A4F85-3AE5-4B7D-9B27- 32CEDE8DBD79

  Auto Indexing is disabled by default in Autonomous Database

• Question 48:

  Which statement is true when you provision an Autonomous Database using the cloning method?

  A. After an Autonomous database is created using a clone, the network access option can be changed.

  B. A clone database source can be a running database instance.

  C. A clone database source can be from a point-in-time backup that is less than 2 hours old.

  D. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.

  Correct Answer: B

• Question 49:

  Which statement is correct about managing and monitoring of Autonomous Database?

  A. You can use Service console to move Autonomous DB between compartments.

  B. You can use Service console to create manual backups of Autonomous database.

  C. You can use Service console to enable or disable auto scaling of Autonomous DB.

  D. You can use Service console to manage runaway SQL statements on Autonomous DB.

  Correct Answer: D

  https://docs.oracle.com/en/cloud/paas/autonomous- database/adbsa/manage-sql-statements.html#GUID4861BA7F-F9FA-4909-8DC0- 4F46AFF80706

• Question 50:

  Which native data type is used to store spatial information?

  A. SDO_RELATE

  B. SDO_GEOMETRY

  C. SDO_LOCATION

  D. GEO_JSON

  Correct Answer: B