Question 1

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?

Options :

A : Quarterly Bundle Patch (QBP)

B : Prior Release Update Revision (PRUR)

C : Prior Release Update (PRU)

D : Release Update (RU)

Answer: D

Question 2

Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

Options :

A : Backup and recovery must be done using Recovery Manager(RMAN).

B : Select the snapshot of the backup.

C : Select the archived redo logs.

D : Select the backup from which restore needs to be done.

E : Specify the point in time (timestamp) to restore.

Answer: A,D

Question 3

You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web. What steps do you need to take?

Options :

A : Create a database user with connect, resource, and object privileges

B : Create a database user with the default privileges

C : Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer Web, and provide the user with the user-specific modified URL

D : Create an IDCS user, create a database user with connect, resource, and object privileges

Answer: C

Question 4

What is a best practice when planning and instituting access controls for your Autonomous Dedicated environment regarding subnets, compartments, and user groups?

Options :

A : Create a separate VCN that contains only public subnets

B : Only 1 of each is allowed to be allocated per environment.

C : Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.

D : Create at least 2 of each resource.

Answer: D

Question 5

What is the number of concurrent statements that can be handled by the medium database service name?

Options :

A : 1-25 X OCPU

B : OS

C : unlimited

D : 20 X OCPU

Answer: A