Oracle 1Z0-053 問題集

質問 1：
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. It drops all disk paths from the dga disk group.
C. It starts the ASM fast mirror resync.
D. All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose two.)
A. Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.
B. Health Monitor checks are always initiated manually when there is some critical error.
C. Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt or inconsistent.
D. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.
正解：C,D

質問 3：
What is the correct order of the following commands if you wanted to restore datafile 4, which was accidentally removed from the file system?
a: sql 'alter database datafile 4 online';
b: restore datafile 4;
c: recover datafile 4;
d: sql 'alter database datafile 4 offline';
e: startup
f:
shutdown
A. a, c, b, d
B. f, d, b, c, a, e
C. a, b, d, e
D. d, b, c, a
E. c, a, b, d, f
正解：D

質問 4：
You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups.
Which action should you take?
A. Configure multiple SBT channels.
B. Use compression when performing tape backups.
C. Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE.
D. Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE.
正解：C

質問 5：
At the request of a user, you issue the following command to restore a dropped table:
SQL> flashback table "BIN$F2JFfMq8Q5unbC0ceE9eJg==$0" to before drop;
Later, the user notifies you that the data in the table seems to be very old and out of date.
What might be the problem?
A. Because a proper range of SCNs was not specified, the wrong data was restored.
B. A proper range of timestamps was not specified, so the wrong data was restored.
C. Either option A or B could be correct. Not enough information was provided to determine which.
D. A previous Flashback Drop operation had been performed, resulting in multiple versions of the table being stored in the Recycle Bin.
E. None of the above.
正解：D

質問 6：
How is block-change tracking enabled?
A. With an spfile parameter change
B. With an init.ora parameter change
C. With alter system enable block change tracking
D. With alter database enable block change tracking
正解：D

質問 7：
View the Exhibit to examine the Automatic SQL Tuning result details. Which action would you
suggest for the selected SQL statement in the Exhibit?

A. Collect statistics for the related objects.
B. Run the Segment Advisor for recommendations.
C. Run the Access Advisor for the SQL statement.
D. Accept the recommended SQL profile.
正解：C