Choose the best answer. Which operating system group is NOT needed to perform an Oracle Database installation?

• A.OSOPER
• B.OSKMDBA
• C.OSDBA
• D.OSASM
• E.OSRACDBA

Comment: *

Name: *

Email: *

Verification: *

A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT.
Which three are true? (Choose three.)

• A.Data file 24 can be recovered only while connected to PDB2.
• B.Data file 24 can be restored and recovered while connected to CDB$ROOT.
• C.Data file 24 can be recovered while connected to CDB$ROOT.
• D.Data file 24 can be recovered while connected to PDB2.
• E.Data file 24 can be restored only while connected to PDB2.
• F.Data file 24 can be restored only while connected to CDB$ROOT.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about Oracle pluggable databases (PDBs)?

• A.A PDB created from PDB$SEED must be set to READ ONLY after loading data.
• B.A non-CDB can be converted into a PDB.
• C.A PDB unplugged from a container database (CDB) can be plugged into a different CDB without altering any of its schemas.
• D.A PDB can be plugged into a CDB only if both are of the same Oracle Database release.
• E.An unplugged PDB can be plugged into multiple CDBs simultaneously by sharing data files.
• F.A PDB in a remote CDB can be accessed transparently thereby aggregating results from local and remote PDBs.
• G.A PDB created from PDB$SEED must be set to READ WRITE after loading data.

Comment: *

Name: *

Email: *

Verification: *

Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

• A.database instance memory management and sizes
• B.SQL statements
• C.general operating system health
• D.log writer performance
• E.database writer performance

Comment: *

Name: *

Email: *

Verification: *

How do you configure a CDB for local undo mode?

• A.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.
• 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, drop the undo tablespace. Execute alter database local undo on in each PDB, and then restart the CDB instance.
• E.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

Comment: *

Name: *

Email: *

Verification: *