Which three are true about requirements for various flashback operations?

• A.flashback version query requires that the recyclebin parameter be set to on.
• B.flashback drop requires that the recyclebin parameter be set to on.
• C.flashback transaction query requires undo to retrieve all versions of a row that existed between two points in time.
• D.flashback data archive requires undo to store all versions of all rows of a table being tracked.
• E.flashback version query requires undo to retrieve all versions of a row that existed between two points in time.
• F.flashback drop requires undo to retrieve all versions of a row that existed between two points in time.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Automatic Workload Repository (AWR) snapshots?

• A.They can be retained forever.
• B.They are always created manually.
• C.They are generated if STATISTICS LEVEL is set to TYPICAL.
• D.They are generated if STATISTICS LEVEL is set to ALL.
• E.They are always created automatically.
• F.They are generated if STATISTICS LEVEL is set to BASIC.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three activities are possible for PDBs?

• A.converting an application PDB to an application seed G) converting an application PDB to a regular PDB
• B.converting an application seed to an application PDB
• C.converting a regular PDB to an application PDB
• D.copying an application container into another application container in the same CDB
• E.copying an application container into another application container in a different CDB
• F.converting an application PDB to an application root

Comment: *

Name: *

Email: *

Verification: *

choose one .Examine the RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which statement is true about the DUPLICATE command?

• A.It succeeds and creates multisection backup sets that are used for active database duplication.
• B.It succeeds only if the target database is in MOUNT state.
• C.It fails because no parallel channels are allocated for the auxiliary database.
• D.It fails because there is no connection to a recovery catalog.

Comment: *

Name: *

Email: *

Verification: *

A container database called CDB1 is OMF-enabled. PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1: CREATE PLUGGABLE DATABASE pdb1 USING '/u01/app/oracle/oradata/pdb1.xml' SOURCE_FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/', '/u02/app/oracle/oradata/'); Which two are true? (Choose two.)

• A./u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
• B.DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
• C.PDB1 must be dropped from CDB1.
• D.PDB_FILE_NAME_CONVERT must be set before executing the command.
• E.PDB1 data files already exist in the correct location.

Comment: *

Name: *

Email: *

Verification: *