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

• Question 71:

  Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?

  A. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule thecontainer database maintenance for the following quarter.

  B. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is

  mandatory.

  C. You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter.

  D. Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of theExadata grid infrastructure code and operating systems updates), and include database patching.

  Correct Answer: D

  Exadata infrastructure maintenance takes place at least once each quarter and is mandatory.

  If a scheduled container database maintenance run cannottake place (because of changes made to infrastructure maintenance scheduling or other reasons) , Oracle will automatically reschedule the container database maintenance for the following quarter.

  You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter. Exadata infrastructure maintenance patches the Exadata infrastructure (including patching of the Exadata grid infrastructure code and operating systems updates), and DO NOT include database patching.

• Question 72:

  While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure(OCI) console, which patch type is offered to be applied during maintenance?

  A. Release Update (RU)

  B. Prior Release Update Revision (PRUR)

  C. Prior Release Update (PRU)

  D. Quarterly Bundle Patch (QBP)

  Correct Answer: A

  On the Edit Automatic Maintenance card, select Release Update (RU) or Release Update Revision (RUR) from the Maintenance type list.

  Note:

  Currently, the Release Update Revision (RUR) maintenance type is not a selectable option. When release

  update revisions become available for Autonomous Database,this option will become selectable.

  Reference: https://docs.oracle.com/en-us/iaas/autonomous-database/doc/change- maintenance-typeacd1.html

• Question 73:

  Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?

  A. Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure

  B. Oracle Machine Learning ZeppelinNotebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator

  C. Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database

  D. Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure

  Correct Answer: C

• Question 74:

  Which three event types are supported for Autonomous Database?

  A. Terminate End

  B. Maintenance Begin

  C. Change Compartment Begin

  D. Change Autoscaling Configuration Compartment

  E. Update IORM Begin

  Correct Answer: ABC

  https://docs.oracle.com/en-us/iaas/Content/Events/Reference/eventsproducers.htm

  

  Graphical user interface, application Description automatically generated with medium confidence

  

• Question 75:

  Which option is not available to pick ( no.of days ) when configuring the backup retention for Oracle Container Database.

  A. 120

  B. 60

  C. 15

  D. 7

  Correct Answer: A

  Backup Retention If you choose to enable automatic backups, you can choose one of the following preset retention periods: 7 days, 15 days, 30 days, 45 days, or 60 days. The system automatically deletes your incremental backups at the end of your chosen retention period.

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

• Question 76:

  You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX.

  What statement describes the step to provide the developer a newworkspace in APEX?

  A. Create an IDCS user with the APEX role.

  B. Access the APEX Administration Services and create the workspace for the developer.

  C. Create a new developer account.

  D. Create a database user with the APEX role.

  Correct Answer: B

  https://docs.oracle.com/en/database/oracle/application- express/19.1/htmig/creating-workspace-andadding-Oracle-AE-users.html#GUID- 1040F145-452A-49D4-BCF6-A80851AFFA74 Create a New Instance Administrator Login to the INTERNAL workspace as the ADMIN user, or another existing admin user. Click the "Create User" link on the right-hand menu. For anew admin user enter mandatory items and the following. Workspace : INTERNAL Default Schema : APEX_180200 {or whatever the highest version is} User is an administrator: Yes Account Availability : Unlocked Password and Confirmation Password. Require Changeof Password on First Use : Yes Click the "Create User" button.

  https://oracle-base.com/articles/misc/apex-tips-basic-apex-management

• Question 77:

  An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a database user id with other users when accessing ADB.

  Other than changing the shared user password, what can the admin do to protect the instance?

  A. Trust the user who left to not access the database.

  B. Shutdown and restart the instance.

  C. Rotate the instance wallet and share the new wallet with the remaining users.

  D. Delete the user.

  Correct Answer: C

  

• Question 78:

  Which can be Scaled Independently of the number of CPUs In an Autonomous Database?

  A. Parallelism

  B. Storage

  C. Concurency

  D. Memory

  E. Sessions

  Correct Answer: B

  https://docs.oracle.com/en/cloud/paas/autonomous- database/adbsa/autonomous-keyfeatures.html#GUID-7D0627D9-1B40-40B1-865A- 84FF65A65846 Key Features Fully elastic scaling: Scale compute and storage independently to fit your database workload with no downtime:

  

• Question 79:

  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

  Correct Answer: C

  https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms- cloud-admin.html#GUID42B9DDB0-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 80:

  Which statement is true when connecting OCI Marketplace image to shared autonomous database?

  A. Compute Image and Shared ADB must be in same VCN and Subnet

  B. ADB must be configured with NSG

  C. ADB must be configured with Private endpoints

  D. Cannot connect OCI Market image to shared ADB

  Correct Answer: A