网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
In user-managed backup and recover procedures， how are data files backed up？ （）
A
Using SQL commands.
B
Using SQL*Plus commands.
C
Using operating system commands.
D
Using Recover Manager commands.
参考答案
参考解析
解析：
暂无解析
更多 “单选题In user-managed backup and recover procedures， how are data files backed up？ （）A Using SQL commands.B Using SQL*Plus commands.C Using operating system commands.D Using Recover Manager commands.” 相关考题
考题
Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?（）A. Redo logsB. Control fileC. The latest backup of only the damaged data fileD. The latest backup of all the data file in the USERS tablespaceE. Temporary files of temporary tablespaceF. Archive Logs since the latest backup to point of failure
考题
Which of the following allows an administrator to recover the MOST data?()
A. System imageB. Incremental backupC. System state restoreD. Differential backup
考题
The IBM System Storage TS7650 ProtecTIER Appliance and Gateway solution is designed toaddress which customer requirement?（）A、latency across a long distance network B、high-speed backup of large video files C、increase levels of data protection with enterprise class data integrity D、improve backup and recovery operations without changing existing backup processes,procedures or policies
考题
You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）A、 V$BACKUP_CORRUPTIONB、 V$COPY_CORRUPTIONC、 V$DATABASE_BLOCK_CORRUPTIOND、 RC_BACKUP_CORRUPTION
考题
Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（） A、 redo logsB、 control fileC、 temporary files of temporary tablespaceD、 the latest backup of only the damaged data fileE、 the latest backup of all the data files In the USERS tablespace
考题
In which scenario will you perform a cancel-based recovery？（）A、 when a tablespace is dropped and you have only RMAN-based backup of the databaseB、 when a table is dropped and stored in the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when a tablespace is dropped and you have only a user-managed full backup of the database
考题
The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file？（）A、The data file cannot be recovered.B、The date file can be restored from theSYSTEMauto backup.C、Take thetablespaceoffline，drop，kand re-create it.D、Recovery Manager （RMAN） is used to recover the data file.E、The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.
考题
For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？（）A、 RMAN image copies.B、 RMAN database backups.C、 RMAN tablespace backups.D、 User-managed backups placed in the flash recovery area.E、 User-managed backups that have been cataloged with RMAN.F、 User-managed data file backups for which the pull path name is specified.
考题
To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）A、The database will open, and the tablespace automatically comes out of the backup modeB、The database will be mounted, and recovery must be performed on the USERS tablespace.C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
考题
单选题In which scenario will you perform a cancel-based recovery？（）A
when a tablespace is dropped and you have only RMAN-based backup of the databaseB
when a table is dropped and stored in the Recycle BinC
when you are required to recover an existing table to its previous stateD
when a tablespace is dropped and you have only a user-managed full backup of the database
考题
单选题Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement： ALTER TABLESPACE data1 BEGIN BACKUP； While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）A
The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B
If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.C
If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.D
If you restart the database，the database will not be opened.
考题
单选题Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）A
The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.C
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.D
If you restart the database, the database will not be opened.
考题
单选题You lost the PRODSTD tablespace， which was read-only. The tablespace was read-only when the last backup was taken. How would you recover the tablespace？（）A
restore the tablespace from the backup， and then perform an incomplete recoveryB
restore the tablespace from the backup， and then apply all the redo informationC
restore all the data files in the database， and then perform an incomplete recoveryD
restore the tablespace from the backup
考题
单选题A customer needs the ability to recover their data if a total system failure occurs. Which two of the following are the most important considerations in determining the solution？（）A
Network utilizationB
Total amount of storage installedC
Amount of open files in the backupD
Amount of critical data in the backup or restore
考题
单选题To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）A
The database will open, and the tablespace automatically comes out of the backup mode.B
The database will be mounted, and recovery must be performed on the USERS tablespace.C
The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.D
The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
考题
单选题You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only 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 informationB
restore the full database to recover the data up to the point when you performed the backupC
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
考题
单选题Which of the following allows an administrator to recover the MOST data?（）A
System imageB
Incremental backupC
System state restoreD
Differential backup
考题
多选题Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（）Aredo logsBcontrol fileCtemporary files of temporary tablespaceDthe latest backup of only the damaged data fileEthe latest backup of all the data files In the USERS tablespace
考题
单选题You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）A
Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.B
Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.C
Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.D
Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.
考题
单选题In user-managed backup and recover procedures， how are data files backed up？ （）A
Using SQL commands.B
Using SQL*Plus commands.C
Using operating system commands.D
Using Recover Manager commands.
考题
单选题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 are maintaining your database in ARCHIVELOG mode. An important table， SCOTT.EMPLOYEE， is dropped and purged from the Recycle Bin on Monday at 2：00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9：00 P.M. on Sunday. How will you recover the dropped table， SCOTT.EMPLOYEE？（）A
by using the Flashback Table featureB
by using the Flashback Database featureC
by performing incomplete recovery using RMAN utilityD
by performing incomplete recovery using user-managed recovery
考题
多选题Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator （）(DBA)? (Choose Three)ARedo logsBControl fileCThe latest backup of only the damaged data fileDThe latest backup of all the data file in the USERS tablespaceETemporary files of temporary tablespaceFArchive Logs since the latest backup to point of failure
考题
单选题The data file belonging to the SYSTEM tablespace is corrupted and no backup of the file is available. How do you recover the data file？（）A
The data file cannot be recovered.B
The date file can be restored from the SYSTEM auto backup.C
Take thetablespaceoffline，drop，kand re-create it.D
Recovery Manager （RMAN） is used to recover the data file.E
The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.
考题
多选题Your database is running in ARCHIVELOG mode. One of the data files， USERDATA01.dbf， in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（）ARedo logsBControl fileCThe latest backup of only the damaged data fileDThe latest backup of all the data file in the USERS tablespaceETemporary files of temporary tablespaceFArchive Logs since the latest backup to point of failure
考题
单选题Which of the following allows an administrator to recover the MOST data？（）A
System imageB
Incremental backupC
System state restoreD
Differential backup
考题
单选题Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recover strategy available in Oracle9i？（）A
Rebuild the index using the online option. B
Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. C
Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. D
Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.
考题
多选题The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）ARestore the data file and perform incomplete recovery.BRestore the data file and perform point-in-time recover.CDrop the tablespace and lose all data in the tablespace.DRestore the database and lose all data since the last backup.
热门标签
最新试卷