网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility. What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）
- A、 The block change tracking feature must be enabled.
- B、 OMF must be configured on your database.
- C、 The database must be in ARCHIVELOG mode.
- D、 A USERID must be supplied.
参考答案
更多 “ The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility. What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（） A、 The block change tracking feature must be enabled.B、 OMF must be configured on your database.C、 The database must be in ARCHIVELOG mode.D、 A USERID must be supplied.” 相关考题
考题
Which of the following is not an advantage of block media recovery （BMR）？（）A、 Reduced MTTR.B、 Datafiles remain offline while corrupt blocks are repaired.C、 Datafiles remain online while corrupt blocks are repaired.D、 A and C
考题
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
考题
When exporting metadata for the transportable tablespaces， what is the correct next step after confirming endian format？（）A、 Export the tablespaces using data pump.B、 Determine if the transportable set is self-contained.C、 Convert the datafiles using RMAN.D、 Copy the datafiles from source to destination.
考题
What information does the report schema command not provide？（） A、 Size of the datafilesB、 Size of the tempfilesC、 Date of last backup for datafiles and tempfilesD、 Filenames for each datafileE、 Checkpoint SCN associated with the last RMAN backup
考题
You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）A、 The target database must be in the MOUNT mode to ensure restoration of the datafiles.B、 You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.C、 The control file must be recreated.D、 The database must be opened with the RESETLOGS option.
考题
Which of the following are included in a transportable tablespace set？（） A、 The datafiles that make up a self-contained group of tablespaces required for copyB、 The system tablespaceC、 An export of the tablespace metadataD、 The spfileE、 All of the above
考题
Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（） A、 Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.B、 Just back up the database datafiles without shutting down the database.C、 You will have to wait until you can shut down the database to perform the backup.D、 Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backup
考题
Which view provides information on the backup status of the datafiles in the database？（） A、 V$BACKUPB、 V$BACKUP_STATUSC、 V$BACKUP_DATAFILED、 V$DATAFILE_BACKUPE、 V$TABLESPCE_BACKUP
考题
In what state are the datafiles of a tablespace after a TSPITR has been successfully completed？（） A、 The datafiles have an ONLINE status.B、 The datafiles have an OFFLINE status.C、 The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.D、 The datafiles have an OFFLINE status and are in hot backup mode for an online backup.E、 The datafiles are in STANDBY mode.
考题
When issuing the duplicate database command， you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter？（） A、 To indicate the location of the auxiliary-instance online redo logs.B、 To indicate the location of the target database datafiles.C、 To indicate the location of the auxiliary-instance control file and online redo logs.D、 To indicate the location of the auxiliary-instance database datafiles.E、 This is not a valid parameter when duplicating a database.
考题
You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery. Which datafiles will you recover？（）A、 all the datafiles in the databaseB、 the datafiles associated with the SYSTEM tablespaceC、 the datafiles associated with the DATA1 tablespaceD、 all the datafiles in the database except those associated with the DATA1 tablespace
考题
Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）A、 Archive log generation is suspended until the tablespaces are taken out of hot backup mode. B、 Datafiles are not written to during hot backups.C、 Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.D、 The datafile headers are not updated during the backup.E、 The way data is written to the online redo logs is unchanged during the backup.
考题
单选题Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement： SQL DROP TABLE SCOTT.EMP PURGE； After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）A
the datafiles associated with the SYSTEM tablespaceB
the datafiles associated to the DATA1 tablespaceC
the datafiles associated to the SYSTEM and DATA1 tablespacesD
all the datafiles in the database
考题
单选题Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）A
Archive log generation is suspended until the tablespaces are taken out of hot backup mode. B
Datafiles are not written to during hot backups.C
Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.D
The datafile headers are not updated during the backup.E
The way data is written to the online redo logs is unchanged during the backup.
考题
单选题In what state are the datafiles of a tablespace after a TSPITR has been successfully completed？（）A
The datafiles have an ONLINE status.B
The datafiles have an OFFLINE status.C
The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.D
The datafiles have an OFFLINE status and are in hot backup mode for an online backup.E
The datafiles are in STANDBY mode.
考题
单选题What is the result of this command？（） RMAN Report need backup days 3；A
Lists all datafiles created in the last three days that are not backed up.B
Lists all datafiles not recoverable based on the current retention criteria.C
Lists all datafiles not backed up in the last three days. The datafile is not recoverable. D
Lists all datafiles that need to be backed up due to unrecoverable operations.E
Lists all datafiles not backed up in the last three days. It does not imply that the datafile is not recoverable.
考题
单选题When exporting metadata for the transportable tablespaces， what is the correct next step after confirming endian format？（）A
Export the tablespaces using data pump.B
Determine if the transportable set is self-contained.C
Convert the datafiles using RMAN.D
Copy the datafiles from source to destination.
考题
单选题Your database is configured in NOARCHIVELOG mode. Due to a media failure， you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time？（）A
Restore all the datafiles from the backup.B
Restore only the lost datafile from the backup.C
Restore all the datafiles for the lost tablespace from the backup.D
Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.
考题
单选题Which view provides information on the backup status of the datafiles in the database?（）A
V$BACKUPB
V$BACKUP_STATUS C
V$BACKUP_DATAFILE D
V$DATAFILE_BACKUP E
V$TABLESPCE_BACKUP
考题
单选题Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database： a. Restore the three database datafiles that were lost. b. Issue the Startup Mount command to mount the database. c. Issue the alter database open command. d. Issue the alter database open resetlogs command. e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command. g. Take the datafiles offline. Which is the correct order of these steps in this case？（）A
a， b， e， cB
b， e， dC
a， b， d， cD
b， g， c， fE
a， b， d， f
考题
单选题Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours? （）A
restore datafiles until time '09/28/2008:21:03:11'B
restore database files until time '09/28/2008:18:00:00'C
restore database until time '09/28/2008:18:00:00'D
recover database until time '09/28/2008:18:00:00'E
recover database until timestamp '09/28/2008:18:00:00'
考题
单选题Which of the following best describes a full backup? （）A
All datafiles of a database B
All datafiles, archive logs, and control files C
All datafiles and control files D
All the used blocks in a datafile
考题
单选题Which of the following is not an advantage of block media recovery （BMR）？（）A
Reduced MTTR.B
Datafiles remain offline while corrupt blocks are repaired.C
Datafiles remain online while corrupt blocks are repaired.D
A and C
考题
单选题Examine the statement： DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES； What is the result of the statement？（）A
AB
BC
CD
D
考题
单选题You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery. Which datafiles will you recover？（）A
all the datafiles in the databaseB
the datafiles associated with the SYSTEM tablespaceC
the datafiles associated with the DATA1 tablespaceD
all the datafiles in the database except those associated with the DATA1 tablespace
考题
单选题You have lost datafiles 1 and 3 from your database，and the database has crashed. In what order should you perform the following steps to recover your database？（） 1. Take the datafiles that were lost offline. 2. startup mount the database 3. Issue the alter database open command. 4. Restore the datafiles that were lost 5. Recover the datafiles with the recover datafile command. 6. Bring the datafiles back online. 7. Recover the database with the recover database command.A
2，1，3，4，5，6B
2，4，5，3C
4，7，3D
2，4，7，3E
2，7，3
热门标签
最新试卷
