You plan to recover the SCOTT.EMPtable to a specific point in time by using RMAN:
RMAN> RECOVER TABLE SCOTT.EMP UNTILL SYSDATE-2 USING AUXILIARY LOCATION '+RECO'; Which five steps are performed by RMAN?

• A.exporting the SCOTT.EMPtable from the auxiliary database
• B.creating an auxiliary instance
• C.importing the SCOTT.EMPtable into the original database
• D.truncating the SCOTT.EMPtable in the original database
• E.flashing back the original database to the desired point in time
• F.restoring the tablespaces required for point-in-time recovery
• G.recovering the auxiliary database to the desired point in time
• H.dropping the SCOTT.EMPtable in the original database

Comment: *

Name: *

Email: *

Verification: *

You must track all transactions that modify certain tables in the SALES schema for at least three years.
Automatic undo management is enabled for the database with a retention of one day.
Which two must you do to track the transactions? (Choose two.)

• A.Enable supplemental logging for the database.
• B.Specify undo retention guarantee for the database.
• C.Create a Flashback Data Archive in the tablespace where the tables are stored.
• D.Create a Flashback Data Archive in any suitable tablespace.
• E.Enable Flashback Data Archiving for the tables that require tracking.

Comment: *

Name: *

Email: *

Verification: *

A redaction policy was added to the SAL column of the SCOTT.EMP table:

All users have their default set of system privileges.
For which three situations will data not be redacted?

• A.SYS sessions, regardless of the roles that are set in the session
• B.SYSTEM sessions, regardless of the roles that are set in the session
• C.SCOTT sessions, only if the MGR role is set in the session
• D.SCOTT sessions, only if the MGR role is granted to SCOTT
• E.SCOTT sessions, because he is the owner of the table
• F.SYSTEM session, only if the MGR role is set in the session

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)? (Choose three.)

• A.System privileges apply only to the PDB in which they are used.
• B.Local users cannot use local system privileges on the schema of a common user.
• C.The granter of system privileges must possess the set container privilege.
• D.Common users connected to a PDB can exercise privileges across other PDBs.
• E.System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.

Comment: *

Name: *

Email: *

Verification: *

Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager?

• A.Local file system I/O
• B.CPU
• C.Maximum Idle time
• D.Exadata I/O
• E.Maximum Undo per consumer group
• F.Parallel server limit

Comment: *

Name: *

Email: *

Verification: *