网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
下列哪一个命令可以用来执行不完全恢复？（）
A
RESTORE DATABASE UNTIL
B
RECOVER DATABASE UNTIL
C
RECOVER DATA UNTIL
D
RESTORE DATA UNTIL
参考答案
参考解析
解析：
暂无解析
更多 “单选题下列哪一个命令可以用来执行不完全恢复？（）A RESTORE DATABASE UNTILB RECOVER DATABASE UNTILC RECOVER DATA UNTILD RESTORE DATA UNTIL” 相关考题
考题
下列哪一个命令可以用来执行不完全恢复?()
A.RESTORE DATABASE UNTILB.RECOVER DATABASE UNTILC.RECOVER DATA UNTILD.RESTORE DATA UNTIL
考题
Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?（）A、2, 4, 3B、1, 4, 3, 2C、2, 5, 4, 3, 6D、5, 2, 4, 3, 6E、1, 5, 4, 3, 6, 2
考题
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'
考题
Consider the recovery steps in each of the cases given below： Case 1： Shut down the database and perform a backup. Restore all the data files. Mount the database. Recover the database. Without applying all the redo log files， open the database using the RESETLOGS option. Back up the database. Case 2： Shut down the database and perform a backup. Restore only the data files of the tablespace where user error damaged the data. Mount the database. Recover the database. Open the database with the RESETLOGS option. Back up the database. Case 3： Shut down the database Restore the data files Open the database Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery？（）A、only case 1B、only case 2C、only case 3D、case 1 and 2E、case 2 and 3F、case 1 and 3G、all cases： case 1， case 2 and case 3
考题
下列哪一个命令可以用来执行不完全恢复？（）A、RESTORE DATABASE UNTILB、RECOVER DATABASE UNTILC、RECOVER DATA UNTILD、RESTORE DATA UNTIL
考题
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）A、Restore and recover the datafile. B、Restore and recover the tablespace. C、Restore and recover the database. D、Restore and recover the control file. E、Restore and recover the parameter file.
考题
Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning，media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this situation？（）A、recover using Oracle Flashback Database technologyB、restore the data files from backup and perform a complete recoveryC、restore only the corrupted data file and perform tablespace recoveryD、restore the data files from backup and perform cancel-based recoveryE、restore the entire database from the most recent backup and start the instance and open the database
考题
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）A、Restore all the data files and open the databaseB、Create the data file and performtablespacerecoveryC、No need to restore any file， just recover the databaseD、Restore only the system data file and recover the databaseE、Restore only lost date file and performtablespacerecovery
考题
The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）A、Restore the data file and perform incomplete recovery.B、Restore the data file and perform point-in-time recover.C、Drop the tablespace and lose all data in the tablespace.D、Restore the database and lose all data since the last backup.
考题
Which three statements are true about Flashback Database?（）A、Flashback logs are written sequentially, and are archived.B、Flashback Database uses a restored control file to recover a database.C、The Oracle database automatically creates, deletes, and resides flashback logs in the Fast RecoveryArea.D、Flashback Database can recover a database to the state that it was in before a reset logs operation.E、Flashback Database can recover a data file that was dropped during the span of time of the flashback.F、Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
考题
Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（） A、 shutdown restore datafile 4； recover datafile 4； alter database open；B、 Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；C、 Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；D、 Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；E、 Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；
考题
When performing an incomplete recover of the whole database， which data files must you restore？ （）A、Only the damaged or lost data files.B、All of the data files of the database.C、Only the data files belonging to the SYSTEM tablespace.D、The data files belonging to the SYSTEM tablespace and the damaged or lost data files.
考题
You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）A、 Restore the lost data file from the backup， and then flash back the database.B、 Restore the data file pertaining to index tablespace， and then recover the tablespace.C、 Restore all the data files， and then perform an incomplete recovery to get the tablespace back.D、 Restore all the data files， and then perform an incomplete recovery using the backup control file.E、 Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.
考题
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.
考题
Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database， each with three members， making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible？（）A、Restore the data file for the SYSTEM tablespace then open the database. B、Restore all redo logs form last night's backup, then restart the database. C、Perform a complete restore of all files from last night's backup. Data entered into the database today must be reentered. D、Mount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online.
考题
Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）A、Shut down the database, restore the two data files and then start up the database. B、Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. C、Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. D、Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.
考题
单选题Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）A
Shut down the database, restore the two data files and then start up the database. B
Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. C
Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. D
Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.
考题
单选题You want to perform in incomplete recovery of your database. You plan to use these commands to recover your database： SET UNTIL TIME = ’2000-12-09：11：44：00’； RESTORE DATABASE； RECOVER DATABASE； How should the commands be executed？ （）A
Only the SET command must be within a RUN block.B
All commands should be executed at the RMAN prompt.C
All three commands must be within a single RUN block.D
Only the RESTORE and RECOVER commands must be within a single RUN block.
考题
单选题Consider the recovery steps in each of the cases given below： Case 1： Shut down the database and perform a backup. Restore all the data files. Mount the database. Recover the database. Without applying all the redo log files， open the database using the RESETLOGS option. Back up the database. Case 2： Shut down the database and perform a backup. Restore only the data files of the tablespace where user error damaged the data. Mount the database. Recover the database. Open the database with the RESETLOGS option. Back up the database. Case 3： Shut down the database Restore the data files Open the database Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery？（）A
only case 1B
only case 2C
only case 3D
case 1 and 2E
case 2 and 3F
case 1 and 3G
all cases： case 1， case 2 and case 3
考题
单选题You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）A
Restore all the data files and open the databaseB
Create the data file and perform tablespace recoveryC
No need to restore any file， just recover the databaseD
Restore only the system data file and recover the databaseE
Restore only lost date file and performtablespacerecovery
考题
单选题Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?（）A
2，4，3B
1，4，3，2C
2，5，4，3，6D
5，2，4，3，6E
1，5，4，3，6，2
考题
单选题Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（）A
shutdown restore datafile 4； recover datafile 4； alter database open；B
Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；C
Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；D
Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；E
Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；
考题
单选题下列哪一个命令可以用来执行不完全恢复？（）A
RESTORE DATABASE UNTILB
RECOVER DATABASE UNTILC
RECOVER DATA UNTILD
RESTORE DATA UNTIL
考题
单选题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.
考题
单选题You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）A
Restore and recover the datafile.B
Restore and recover the tablespace.C
Restore and recover the database.D
Restore and recover the control file.E
Restore and recover the parameter file.
考题
单选题When performing an incomplete recover of the whole database， which data files must you restore？ （）A
Only the damaged or lost data files.B
All of the data files of the database.C
Only the data files belonging to the SYSTEM tablespace.D
The data files belonging to the SYSTEM tablespace and the damaged or lost data files.
考题
单选题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
考题
单选题Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?（）A
2，4，3B
1，4，3，2C
2，5，4，3，6D
5，2，4，3，6E
1，5，4，3，6，2
热门标签
最新试卷
