Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.
Which two RMAN commands may be; used to back up only the PDB1 pluggable database?

• A.BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container
• B.BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container
• C.BACKUP DATABASE while connected to the PDB1 container
• D.BACKUP DATABASE while connected to the boot container
• E.BACKUP PLUGGABLE database PDB1 while connected to PDB2

Comment: *

Name: *

Email: *

Verification: *

Examine the parameters for a database instance:

Your database has three undo tablespaces and the default undo tablespace is not autoextensible.
Resumable space allocation is not enabled for any sessions in the database instance.
What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?

• A.Transactions write their undo in the SYSTEM undo segment.
• B.Transactions fail.
• C.Transactions wait until space becomes available in UNDOTBS1.
• D.Transactions write their undo in a temporary tablespace.

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about unified auditing?

• A.The unified audit trail, by default, resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace.
• B.Only the CREATE, ALTER, and DROP statements are audited for all users, including SYS.
• C.Unified auditing is enabled only if the AUDIT_TRAIL parameter is set to NONE.
• D.The unified audit trail contains audit records only from unified audit policies and AUDIT settings.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the SALES table, which is stored in a locally managed tablespace with Automatic Segment Space Management (ASSM) enabled.

You want to perform online segment shrink to reclaim fragmented free space below the high water mark.
What should you ensure before the start of the operation?

• A.No queries are running on this table.
• B.Row movement is enabled.
• C.No pending transaction exists on the table.
• D.Referential integrity constraints for the table are disabled.
• E.Extra disk space equivalent to the size of the segment is available in the tablespace.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about resumable space allocation? (Choose two.)

• A.A database-level LOGONtrigger can be used to automatically configure resumable statement settings for individual sessions.
• B.SELECTstatements that run out of temporary space for sort areas are candidates for resumable execution.
• C.A resumable statement can be suspended and resumed only once during a session.
• D.Resumable space allocation does not apply when a database instance uses asynchronous commit.
• E.Resumable space allocation does not apply when users exceed their assigned space quota in a tablespace.
• F.Free space in a segment is automatically reclaimed when a resumable statement is suspended because of an out-of-space condition.

Comment: *

Name: *

Email: *

Verification: *