11gocmu 試験問題を無料オンラインアクセス

You are managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours:
ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H;
Which statement is true in this scenario?

• A.All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
• B.All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
• C.It starts the ASM fast mirror resync.
• D.It drops all disk paths from the dga disk group.

What is the result of this command? RMAN> Report need backup days 3;

• A.Lists all datafiles not backed up in the last three days. It does not imply that the datafile is not recoverable.
• B.Lists all datafiles not backed up in the last three days. The datafile is not recoverable.
• C.Lists all datafiles created in the last three days that are not backed up.
• D.Lists all datafiles not recoverable based on the current retention criteria.
• E.Lists all datafiles that need to be backed up due to unrecoverable operations.

What privileges must be granted to allow an account to create the recovery catalog? (Choose all that apply.)

• A.RECOVERY_CATALOG_OWNER
• B.RESOURCE
• C.DBA
• D.SELECT ANY DICTIONARY
• E.CONNECT

Note the following statements that use flashback technology:
1.FLASHBACK TABLE <table> TO SCN <scn>;
2.SELECT * FROM <table> AS OF SCN 123456;
3.FLASHBACK TABLE <table> TO BEFORE DROP;
4.FLASHBACK DATABASE TO TIMESTAMP <timestamp>;
5.SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;
Which of these statements will be dependent on the availability of relevant undo data in the undo segment?

• A.1, 2, 3, 4, and 5
• B.1, 3, and 4
• C.1, 2, and 5
• D.2, 3, 4, and 5

What is the impact of the following backup if it exceeds the duration allowance? (Choose all that apply.)Backup as compressed backupset duration 2:00 partial minimize load database ;

• A.If this backup fails, an error will be raised and any other commands will not be executed.
• B.If this backup fails, subsequent backups will prioritize datafiles not backed up.
• C.The entire backup will fail. It will not be usable for recovery.
• D.If this backup fails, no error will be raised and any other commands will be executed.
• E.The entire backup will fail, but any datafile successfully backed up will be usable for recovery.