考题
多选题You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes?()ASQL scriptsBRecovery Manager (RMAN) scriptCData PumpDSQL*LoaderEFlashback database
考题
多选题You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace: RMAN BACKUP TABLESPACE DETTBS; Under which conditions would this command execute successfully? ()AThe database is in NOMOUNT state.BThe database is in NOARCHIVELOG mode and the tablespace is online.CThe database is in NOARCHIVELOG mode and the tablespace is offline.DThe database is in ARCHIVELOG mode and the tablespace is offline.EThe database is in ARCHIVELOG mode and the tablespace is online.
考题
单选题You lost the PRODSTD tablespace, which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace?()A
restore the tablespace from the backup; there is no need to apply the redo information B
restore the full database to recover the data up to the point when you performed the backup C
restore the tablespace from the backup, and then perform a recovery using the backup control fileD
restore the tablespace from the backup, and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
考题
单选题You executed the following query in your database: SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()A
The time when the last flashback operation in your database was performed.B
The time when the first flashback operation in your database was performed.C
A list of flashback operations performed in your database using SCN and time.D
The approximate time and the lowest system change number (SCN) to which you can flash back your database.
考题
多选题Identify four uses of the Oracle Scheduler.()Aenables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentBenables Oracle database to do patches according to a DBA-defined scheduleCenables you to schedule the execution of jobs based on timeDenables you to execute jobs in a clustered environmentEenables you to periodically execute operating systemscript files located on the same server as the databaseFenables you to create a job that makes use of saved programs and schedulesGenables you to automate the management of the jobs that are created using the DBMS_JOB package
考题
单选题You executed the following command in Recovery Manager (RMAN): RMAN RESTORE CONTROLFILE; Which operation must you perform before this command is executed?()A
back up the control file to traceB
bring database to the MOUNT stateC
open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target databaseD
set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
考题
单选题You administer an Oracle Database 10g and a third-party database. You use Recovery Manager (RMAN) to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command?()A
target databaseB
auxiliary databaseC
third-party databaseD
recovery catalog database
考题
单选题During tablespace creation, which filename format is NOT used for creating datafiles associated with a tablespace?()A
incomplete namesB
incomplete names with templatesC
alias with template namesD
numeric names