Examine these queries and their output: After a system crash, an instance restart and an attempted opening of the PDBs result in: Which two are true? (Choose two.)

• A.Data file 24 must be recovered while PDB2 is closed.
• B.Data file 24 cannot be recovered while the CDB is opened.
• C.Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.
• D.Data file 24 must be recovered while the CDB is opened.
• E.Data file 24 can be recovered while PDB2 is opened.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about monitoring waits for sessions and services? (Choose three.)

• A.V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.
• B.V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.
• C.V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.
• D.V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
• E.V$SESSION_WAIT _CLASS displays waits broken down by wait class only for waiting sessions.
• F.V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.

Comment: *

Name: *

Email: *

Verification: *

You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)

• A.All Oracle recovery files in the current FRA that have not been backed up already, are backed up.
• B.All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
• C.All Oracle recovery files in the current fast recovery area (FRA) are backed up.
• D.These backups can be written to disk or SBT.
• E.All non-Oracle files in the current FRA that have not been backed up already, are backed up.

Comment: *

Name: *

Email: *

Verification: *

Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

• A.cloning a remote pluggable database in silent mode
• B.cloning a remote container database in silent mode
• C.relocating a remote container database in silent mode
• D.relocating a remote container database in interactive mode
• E.cloning a remote container database in interactive mode
• F.relocating a remote pluggable database in interactive mode
• G.relocating a remote pluggable database in silent mode

Comment: *

Name: *

Email: *

Verification: *

You plan to create a database by using the Database Configuration Assistant (DBCA), with t he following specifications: Applications will connect to the database via a middle tier. The number of concurrent user connections will be high. The database will have mixed workload, with t he execution of complex BI queries scheduled at night. Which DBCA option must you choose to create the database?

• A.a default database configuration
• B.a Data Warehouse database template, with t he dedicated server mode option and AMM enabled
• C.a General Purpose database template, with t he shared server mode option and Automatic Memory Management (AMM) enabled
• D.a General Purpose database template with default memory allocation

Comment: *

Name: *

Email: *

Verification: *