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

Oracle 1Z0-931-22 Online Questions & Answers

• Question 1:

  What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?

  A. alter database set application_continuity=true
  B. alter session set application_continuity=true
  C. exec dbms_cloucl_admin. enable_app_cont ( ' ' ) ;
  D. alter system set application_continuity=true
  C. exec dbms_cloucl_admin. enable_app_cont ( ' ' ) ;

  ---

  https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms- cloud-admin.html#GUID-42B9DDB0-12A7-4EE3-9860-30EFA41061E9

  If it was asking for Autonomous Database Dedicated Infrastructure, then answer would be execute DBMS_APP_CONT_ADMIN.ENABLE_AC('databaseid_tpurgent.adb.oraclecloud.com', 'LEVEL1', 600);

• Question 2:

  While creating a business model what advanced options you can enable or disable? (Choose three)

  A. Business Object Security Feature
  B. Analytic View Transparency View
  C. Autonomous Aggregate Cache
  D. Display private tables
  E. Analytic View Base Table Query Transformation
  B. Analytic View Transparency View
  C. Autonomous Aggregate Cache
  E. Analytic View Base Table Query Transformation

  ---

  

• Question 3:

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

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

  ---

  https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbddoverview.htm

• Question 4:

  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.
  C. It is enabled by default.

  ---

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

  Auto Indexing is disabled by default in Autonomous Database

• Question 5:

  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.
  D. You can use Service console to manage runaway SQL statements on Autonomous DB.

  ---

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

• Question 6:

  What is the default port number for accessing a newly created Autonomous Database?

  A. 1524
  B. 1522
  C. 1521
  D. 1523
  E. 1526
  B. 1522

  ---

  https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf

• Question 7:

  Which three are Oracle-recommended best practices for Autonomous Database alarms?

  A. Suppress alarms during investigations.
  B. Create multiple alarm metrics.
  C. Create a single alarm for each metric.
  D. Select the correct alarm interval for your metric.
  E. Routinelytune your alarms.
  F. Use a single interval for all alarms.
  A. Suppress alarms during investigations.
  D. Select the correct alarm interval for your metric.
  E. Routinelytune your alarms.

• Question 8:

  In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?

  A. Oracle Machine Learning notebook
  B. Compartment quotas
  C. Resource Manager settings
  D. SQL Developer Web Console
  B. Compartment quotas

  ---

  https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adboverview.htm

  

• Question 9:

  Which two methods canyou use to create database users and grant roles in Autonomous Database services? O the Oracle Cloud Infrastructure A. service console

  A. SQL Developer
  B. the DBMS_CLOUD_ADMIN package
  C. SQL *Plus
  B. the DBMS_CLOUD_ADMIN package

• Question 10:

  Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.)

  A. RMAN Cross-Platform backup and restore
  B. Golden Gate on-premise installation
  C. PDB unplug / plug operation
  D. Datapump export / import
  E. Dataguard Physical Standby
  F. Golden Gate Cloud service
  B. Golden Gate on-premise installation
  D. Datapump export / import
  F. Golden Gate Cloud service

  ---

  https://k21academy.com/1z0-931/migrate-database-to-oracle-autonomous-database-cloud- optionsdata-pump-sql-loader-dbms_cloud-goldengate/