Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)

• A.The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
• B.The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
• C.RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
• D.The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.
• E.RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
• F.The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
• G.The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
• H.RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

Comment: *

Name: *

Email: *

Verification: *

The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode.
Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)

• A.Backups can be taken only if the database is in ARCHIVELOG mode.
• B.Only consistent backups can be created.
• C.The database must be registered in an RMAN catalog.
• D.Backups can be done incrementally.
• E.Backups must be contained in backup sets.
• F.Backups must be done incrementally.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about the FLASHBACK DATABASE feature? (Choose three.)

• A.Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.
• B.It always generates REDO and UNDO.
• C.FLASHBACK LOGS are archived after a log switch.
• D.A database can be flashed back using SQL*PLUS.
• E.It requires that the target database be in ARCHIVELOG mode.
• F.FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.

Comment: *

Name: *

Email: *

Verification: *

Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)

• A.using Database Replay
• B.using SQL Developer
• C.using Oracle Data Pump
• D.using operating system file copy utilities
• E.using Database Upgrade Assistant
• F.using the CREATE TABLE AS SELECT SQL statement

Comment: *

Name: *

Email: *

Verification: *

Examine this output:

Which two are true?

• A.Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
• B.PDB3 can use all available parallel execution processes at times.
• C.PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
• D.PDB1 is always limited to 40% of the available system resources regardless of demand.
• E.Any PDB not specified in the plan will be unable to execute statements in parallel.
• F.PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.

Comment: *

Name: *

Email: *

Verification: *