Which three are true about requirements for various flashback operations?

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

Comment: *

Name: *

Email: *

Verification: *

Which two are true about common objects? (Choose two.)

• A.They can be created only in CDB$ROOT.
• B.They can be only metadata-linked in an application container.
• C.They can exist in user-defined schemas only in application containers.
• D.They can exist in CDB$ROOTand an application root.
• E.They can be extended data-linked in CDB$ROOT.
• F.They can be created only in an application root.

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

Comment: *

Name: *

Email: *

Verification: *

HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1,must be created so that the HR_APP application's common objects are accessible to it. Which two methods can be used?

• A.Create an application seed, synchronize it with HR_ROOT, and then create the PDB1.application PDB.
• B.Create the PDB1 application PDB and synchronize it with HR_ROOT.
• C.Create the PDB1 application PDB and synchronize it with poB$SEED.
• D.Create the PDB1 application PDB and install HR_APP in it.
• E.Create an application seed, and install HR_APP in it.

Comment: *

Name: *

Email: *

Verification: *

Choose three. You issued this command: RMAN> BACKUP RECOVERY AREA FORCE; Which three are true?

• A.All files in any previous FRA that have been backed up already, are backed up.
• B.All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.
• C.All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up. C)All files in the current FRA that have been backed up already, are backed up.
• D.All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.
• E.All Oracle recovery files normally written to the FRA and which have not yet been backed, are backed up.
• F.All files in any previous FRA that have not yet been backed up, are backed up.

Comment: *

Name: *

Email: *

Verification: *