网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option. What will NOT be the impact of using the RESETLOGS option？（）
A
The log sequence for the database will restart from 1.
B
The log sequence number will be written to the control file.
C
The log sequence number will be written to the datafile headers.
D
The log sequence number will be written to the initialization parameter file.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option. What will NOT be the impact of using the RESETLOGS option？（）A The log sequence for the database will restart from 1.B The log sequence number will be written to the control file.C The log sequence number will be written to the datafile headers.D The log sequence number will be written to the initialization parameter file.” 相关考题
考题
You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.
考题
You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option. What will NOT be the impact of using the RESETLOGS option？（）A、 The log sequence for the database will restart from 1.B、 The log sequence number will be written to the control file.C、 The log sequence number will be written to the datafile headers.D、 The log sequence number will be written to the initialization parameter file.
考题
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
考题
Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）A、recovery cannot be performed because a backup was not performed after the last incomplete recoveryB、restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on ThursdayC、restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on TuesdayD、restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday
考题
Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）A、Perform Export before TSPITR and Import after TSPITRB、Move objects to another schema that has the same tablespace assignedC、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
考题
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.
考题
You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）A、 UNTIL CANCELB、 UNTIL SCNC、 UNTIL SEQUENCED、 UNTIL TIME
考题
You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace. Which two clauses can you use with the RECOVER command？（）A、 UNTIL SEQUENCEB、 UNTIL SCNC、 UNTIL CHANGED、 UNTIL CANCEL
考题
You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）A、 by using the Flashback Database featureB、 by using RMAN incomplete recoveryC、 by performing a user-managed incomplete recoveryD、 by dropping and re-creating the index tablespace
考题
You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）A、 user managed complete recoveryB、 user managed incomplete recoveryC、 RMAN-based complete recoveryD、 RMAN-based incomplete recovery
考题
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 are performing an incomplete recovery because certain important tables were deleted and purged from the Recycle Bin. In which mode will you perform the recovery？（）A、 MOUNT modeB、 RESTRICTED modeC、 OPEN modeD、 NOMOUNT mode
考题
You have performed an incomplete recovery because some important user’s schema is dropped and purged from the Recycle Bin. The current logs are sequenced 1005 and 1006. After performing the recovery， you issued the following statement： SQLALTER DATABASE OPEN RESETLOGS； What will be the resultant log sequence numbers？（）A、 0 and 1B、 1 and 2C、 1005 and 1006D、 1006 and 1007
考题
单选题You have performed an incomplete recovery because some important user’s schema is dropped and purged from the Recycle Bin. The current logs are sequenced 1005 and 1006. After performing the recovery， you issued the following statement： SQLALTER DATABASE OPEN RESETLOGS； What will be the resultant log sequence numbers？（）A
0 and 1B
1 and 2C
1005 and 1006D
1006 and 1007
考题
单选题You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）A
Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.B
Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C
Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D
Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.
考题
单选题You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option. What will NOT be the impact of using the RESETLOGS option？（）A
The log sequence for the database will restart from 1.B
The log sequence number will be written to the control file.C
The log sequence number will be written to the datafile headers.D
The log sequence number will be written to the initialization parameter file.
考题
单选题You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）A
user managed complete recoveryB
user managed incomplete recoveryC
RMAN-based complete recoveryD
RMAN-based incomplete recovery
考题
单选题You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）A
UNTIL CANCELB
UNTIL SCNC
UNTIL SEQUENCED
UNTIL TIME
考题
单选题Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available.What would you do in this scenario？（）A
recovery cannot be performed because a backup was not performed after the last incomplete recoveryB
restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on TuesdayC
restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on SundayD
restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
考题
单选题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.
考题
单选题You are performing an incomplete recovery because certain important tables were deleted and purged from the Recycle Bin. In which mode will you perform the recovery？（）A
MOUNT modeB
RESTRICTED modeC
OPEN modeD
NOMOUNT mode
考题
单选题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
考题
单选题Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method.You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）A
Perform Export before TSPITR and Import after TSPITRB
Move objects to another schema that has the same tablespace assignedC
Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D
Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
考题
单选题You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（） RMANRUN { SET UNTIL SEQUENCE THREAD ； RESTORE DATABASE； RECOVER DATABASE； }A
NOMOUNTB
MOUNTC
OPEND
RESTRICTED
考题
单选题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
考题
单选题You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）A
by using the Flashback Database featureB
by using RMAN incomplete recoveryC
by performing a user-managed incomplete recoveryD
by dropping and re-creating the index tablespace
考题
单选题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
考题
单选题Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）A
recovery cannot be performed because a backup was not performed after the last incomplete recoveryB
restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on ThursdayC
restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on TuesdayD
restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday
热门标签
最新试卷
