Oracle 1Z0-053 問題集

質問 1：
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.
Which two statements are true regarding the outcome of this action? (Choose two)
A. All the related indexes and views are automatically dropped
B. The flashback drop feature can recover only the table structure
C. The flashback drop feature can recover both the table structure and its data
D. Only the related indexes are dropped whereas views are invalidated
正解：C,D

質問 2：
Which of the following is a benefit of ASM fast disk resync?
A. Failed disks are taken offline immediately but are not dropped.
B. Disk data is never lost.
C. The failed disk is automatically reformatted and then resynchronized to speed up the recovery process.
D. By default, the failed disk is not dropped from the disk group ever, protecting you from loss of that disk.
E. Hot spare disks are automatically configured and added to the disk group.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace. To accomplish the task, you issued the following command:
SQL> ALTER TABLESPACE hr_data BEGIN BACKUP;
Which two statements are true in this scenario? (Choose two.)
A. The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.
B. The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.
C. No transaction on the tablespace is allowed but you can perform queries.
D. The tablespace will automatically come out of backup mode when the file copy is complete.
正解：A,B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?
A. Determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
B. Flashback the database to before the transaction was committed
C. Point-in-time recovery
D. Execute the ROLLBACK command with transaction number
正解：A

質問 5：
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?
A. SQL statements that are part of the available SQL Tuning Set (STS) only
B. SQL statements that are part of the AWR baseline only
C. SQL statements based on the AWR top SQL identification
D. SQL statements that are available in the cursor cache and executed by a user other than SYS
正解：C

質問 6：
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?
A. Restore and recover the tablespace.
B. Restore and recover the parameter file.
C. Restore and recover the datafile.
D. Restore and recover the database.
E. Restore and recover the control file.
正解：C

質問 7：
Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database?

A. Option E
B. Option A
C. Option C
D. Option D
E. Option B
正解：A