Which two are true about Oracle Optimizer Statistics, their use, and their collection?

• A.The Statistics Advisor generates actions for all recommendations.
• B.Statistics collected using DBMS_ATATS always yield the best optimizer result.
• C.The number of table rows is considered when evaluating the cost of accessing a table using an index.
• D.Index balanced B*Tree height is considered when evaluating the cost of using an index,
• E.The Statistics Advisor can help recommend the best way to gather statistics.

Comment: *

Name: *

Email: *

Verification: *

Which four are true about RMAN backup sets?

• A.Blocks from multiple data files can be contained in one backup piece.
• B.A backup set can contain only one backup piece.
• C.A backup set must be written to media.
• D.A backup set must be written to disk.
• E.A backup piece can belong to only one backup set.
• F.A data file can be split into multiple sections stored in different backup sets.
• G.A data file can be split into multiple sections stored in different backup pieces in the same backup set.
• H.Blocks from multiple data files can be contained in one backup set.

Comment: *

Name: *

Email: *

Verification: *

Choose the best answer. You want to transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have the same endian Examine this list of steps:. 1. Make the UNIVERSITY tablespace read-only on the source 2. Export the UNIVERSITY tablespace metadata using EXPDP. 3. Create a cross-platform backup set from the UNIVERSITY source system, using an RMAN command that includes the DATAPUMP clause. 4. Copy the cross-platform backup sets to the destination system. 5. Copy the Data Pump dump set from the source to the destination system. 6. Restore the cross-platform backup set on the destination system using an RMAN command that includes the DATAPUMP clause. 7. Import the UNIVERSITY tablespace metadata using IMPDP. 8. Make the UNIVERSITY tablespace read/write on the destination system. Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY tablespace?

• A.1,2,3,4,5,6,7,8
• B.2,3,4,5,6,7
• C.3,4,6
• D.1,3,4,6,8

Comment: *

Name: *

Email: *

Verification: *

choose two Which two statements are true about encrypted backups performed by using RMAN?

• A.Encrypted backups can only be written to disk.
• B.Transparent encryption of backups uses an encryption wallet.
• C.A database uses the same encryption key for every encrypted backup.
• D.A password encryption of backups uses the password while creating and restoring backups.
• E.Image copy backups can be created by using password encryption.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *