Winter Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

1z0-083 Questions Bank

Page: 5 / 21
Total 286 questions

Oracle Database Administration II Questions and Answers

Question 17

Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)

Options:

A.

It is used to change failure priority only for HIGH or LOW priorities.

B.

It is used to execute the advised repair script.

C.

It is used to change failure priority only for the CRITICAL priority.

D.

It is used to explicitly close the open failures.

E.

It is used to inform the database about the repair after the repair script executes.

Question 18

Choose the best answer. How do you configure a CDB for local undo mode?

Options:

A.

Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance.

B.

Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.

C.

Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.

D.

Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON. create an UNDO tablespace in each PDB, and then restart the CDB instance.

E.

Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.

Question 19

Choose three. Which three are true about SGA memory management in a multitenant database?

Options:

A.

SGA_MIN_SIZE cannot be set for a PDB.

B.

Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that PDB.

C.

Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that PDB.

D.

The SHARED_POOL_SIZE setting for a PDB can be up to 80% of the SHARED_POOL_SIZE setting of the root container.

E.

Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for that PDB.

F.

The SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET value of the root container.

Question 20

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?

Options:

A.

It will create a multitenant container database (CDB) with only the root opened.

B.

ItwillcreateaCDBwithrootopenedandseedreadonly.

C.

It will create a CDB with root and seed opened and one PDB mounted.

D.

It will create a CDB that must be plugged into an existing CDB.

E.

ItwillcreateaCDBwithrootopenedandseedmounted.

Page: 5 / 21
Total 286 questions