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?()
第1题:
What information does the report schema command not provide?()
第2题:
Which of the following are included in a transportable tablespace set?()
第3题:
Which view provides information on the backup status of the datafiles in the database?()
第4题:
When issuing the duplicate database command, you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter?()
第5题:
Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode?()
第6题:
Archive log generation is suspended until the tablespaces are taken out of hot backup mode.
Datafiles are not written to during hot backups.
Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.
The datafile headers are not updated during the backup.
The way data is written to the online redo logs is unchanged during the backup.
第7题:
Lists all datafiles created in the last three days that are not backed up.
Lists all datafiles not recoverable based on the current retention criteria.
Lists all datafiles not backed up in the last three days. The datafile is not recoverable.
Lists all datafiles that need to be backed up due to unrecoverable operations.
Lists all datafiles not backed up in the last three days. It does not imply that the datafile is not recoverable.
第8题:
Export the tablespaces using data pump.
Determine if the transportable set is self-contained.
Convert the datafiles using RMAN.
Copy the datafiles from source to destination.
第9题:
V$BACKUP
V$BACKUP_STATUS
V$BACKUP_DATAFILE
V$DATAFILE_BACKUP
V$TABLESPCE_BACKUP
第10题:
restore datafiles until time '09/28/2008:21:03:11'
restore database files until time '09/28/2008:18:00:00'
restore database until time '09/28/2008:18:00:00'
recover database until time '09/28/2008:18:00:00'
recover database until timestamp '09/28/2008:18:00:00'
第11题:
Reduced MTTR.
Datafiles remain offline while corrupt blocks are repaired.
Datafiles remain online while corrupt blocks are repaired.
A and C
第12题:
all the datafiles in the database
the datafiles associated with the SYSTEM tablespace
the datafiles associated with the DATA1 tablespace
all the datafiles in the database except those associated with the DATA1 tablespace
第13题:
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?()
第14题:
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?()
第15题:
In what state are the datafiles of a tablespace after a TSPITR has been successfully completed?()
第16题:
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?()
第17题:
the datafiles associated with the SYSTEM tablespace
the datafiles associated to the DATA1 tablespace
the datafiles associated to the SYSTEM and DATA1 tablespaces
all the datafiles in the database
第18题:
The datafiles have an ONLINE status.
The datafiles have an OFFLINE status.
The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.
The datafiles have an OFFLINE status and are in hot backup mode for an online backup.
The datafiles are in STANDBY mode.
第19题:
V$INSTANCE
V$DATABASE
V$TABLESPACE
V$DATAFILES
第20题:
Restore all the datafiles from the backup.
Restore only the lost datafile from the backup.
Restore all the datafiles for the lost tablespace from the backup.
Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.
第21题:
a, b, e, c
b, e, d
a, b, d, c
b, g, c, f
a, b, d, f
第22题:
All datafiles of a database
All datafiles, archive logs, and control files
All datafiles and control files
All the used blocks in a datafile
第23题:
A
B
C
D
第24题:
2,1,3,4,5,6
2,4,5,3
4,7,3
2,4,7,3
2,7,3