Question 1

Which DBMS_WORKLOAD_REPOSITORY subprogram procedure can be used to modify the default eight day retention period for Autonomous Database performance data?

Options :

A : MODIFY_BACELINE_WINDOW_SIZE

B : UPDATE_OBJECT_INFO

C : CREATE_BASELINE_TEMPLATE

D : MODIFY_SNAPSHOT_SETTINGS

Answer: D

Question 2

Which two of the following statements are correct?

Options :

A : ODI Web Edition is available only on Oracle Linux.

B : ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace.

C : The Data Transforms Card provides access to Oracle Data Integrator (ODI) Web Edition.

D : All of the capabilities of ODI Classic are available with ODI Web Edition,

Answer: A,B

Question 3

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

Options :

A : If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container 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 the Exadata grid infrastructure code and operating systems updates), and include database patching.

Answer: D

Question 4

For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?

Options :

A : ORDS_ADMIN.GRANT_SCHEMA

B : ORDS_ADMIN.ENABLE_SCHEMA

C : ORDS_PRIV.ENABLE_SCHEMA

D : SQLDEV_ADMIN.GRANT_SCHEMA

Answer: B

Question 5

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

Options :

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.

Answer: A,B