AYou can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.
BYou can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.
CYou cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
DYou cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
You are managing an Oracle Database 11g database with this backup strategy: - Every Sunday night, level 0 backup is performed. - On Monday night and subsequent days, level 1 incremental backup is performed. The backups are not cumulative incremental. Which statement about Monday’s backup is true()
单选题查看答案
You are managing an Oracle Database 11g database with the following backup strategy: 1.On Sunday, an incremental level 0 tape backup is performed. 2.Monday through Saturday, acumulativeincremental level 1 tape backup is performed. Which two statements are true regarding the backups performed()
多选题查看答案
You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?()
单选题查看答案
You are working as a DBA in a company. The datafiles in the database are as follows: On Monday, you tried to start up the database but failed because all the control files were missing. You recreated the control file using the script you have created by issuing the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command. What is the prerequisite for recreating the control file?()
单选题查看答案
You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday, you issued the following commands: CONFIGURE DEFAULT DEVICE TYPE TO sbt; CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE RETENTION POLICY TO REDUNDANCY 3; From Monday to Saturday, you performed the following actions: Day Action Monday BACKUP DATABASE Tuesday BACKUP DATABASE Wednesday BACKUP DATABASE Thursday BACKUP DATABASE Friday BACKUP DATABASE Saturday BACKUP DATABASE How many times will the backup of the USERS tablespace be performed?()
单选题查看答案
Which two operations can be performed on an external table()
多选题查看答案
Given: Which two, placed on line 13, will produce the output gobstopper?()
多选题查看答案
You issue the following command: RMAN>CONFIGURE BACKUP OPTIMIZATION ON; What is the result of this command on your backups?()
单选题查看答案
Given: Under which three circumstances will the code on line 37 be executed?()
多选题查看答案