网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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.
参考答案
更多 “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.” 相关考题
考题
You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）A、 until Thursday morningB、 until that point in time when the database is openedC、 until that point in time when the recovery is performedD、 until last Sunday’s backupE、 until that point in time when the table is dropped and purgedF、 until Wednesday evening
考题
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.
考题
Which two statements are true regarding the database in ARCHIVELOG mode？（）A、You have to shut down the database to perform the backups.B、Archiving information is written to the data files and redo log files.C、You can perform complete database backups without closing the database.D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.
考题
Your database operates in ARCHIVELOG mode. User/x7fmanaged consistent backups are performed every Sunday night. On Tuesday， client A drops a table at 8：00 a.m. as follows： SQL DROP TABLE cust_ord PURGE; Table dropped. Client B executes a query at 9：00 a.m. on the same table as follows： SQL SELECT * FROM cust_ord; SELECT * FROM cust_ord * ERROR at line 1： ORA/x7f00942： table or view does not exist Client B needs the dropped table and reports the problem to you. With reference to this scenario， which action should you take？（）A、retrieve the table by using the flashback featureB、restore all the data files from last Sunday’s backup， and then perform a timebased recoveryC、restore all the data files from last Sunday’s backup， and then perform a log sequence recoveryD、restore all the data files from last Sunday’s backup， and then perform a cancelbased recoveryE、restore from last Sunday’s backup only data files that belong to the tablespace in which the table was stored， and then perform a complete recovery
考题
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
考题
Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace. On Monday， you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace. On Tuesday， you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15. When you try to open the database on Wednesday morning， you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table？（）A、 The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.B、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.C、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.D、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup， but the rows inserted on Tuesday need to be inserted again.
考题
You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）A、You can perform consistent backups only.B、You can perform a complete database backup without shutting down the database instance.C、You can back up data files only when all data files have the same SCN recorded in the control file.D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.
考题
Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived， and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery： RMAN RUN { 2 SET UNTIL SEQUENCE 230 THREAD 1; 3 ALTER DATABASE MOUNT; 4 RESTORE DATABASE; 5 RECOVER DATABASE; 6 ALTER DATABASE OPEN RESETLOGS; 7 }; With reference to this scenario， which statement is true？（）A、RMAN recovers up to log sequence 230， but not including 230.B、RMAN returns an error because the log sequence number mentioned in the command should be 229.C、RMAN returns an error because the log sequence number mentioned in the command may never be missing.D、RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.
考题
Examine the following scenario： -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted. The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure？（） A、 Restore the latest whole backup，perform complete recovery，and open the database normally B、 Restore the latest whole backup，perform incomplete recovery，and open the database with the RESETLOGS option.C、 Restore the latest backups control file，perform complete recovery，and open the database with the RESETLOGS option.D、 Restore the latest backup control file，perform incomplete recovery using backup control file，and open the database with the RESETLOG option.
考题
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel/x7fbased recovery？（）A、You find that one of the redo log members in each redo log group is lost.B、You find that a data file that belongs to the USERS tablespace is damaged.C、You find that a data file that belongs to the SYSTEM tablespace is damaged.D、You find that the current redo log group is damaged and is not available for recovery.E、You realized while performing a recovery that an archived redo log file needed for recovery is lost.
考题
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
考题
Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss. To which point can you restore your database？（） A、 13：00 on Tuesday.B、 15：00 on Tuesday.C、 Up until the last available archived redo log on Sunday.D、 To any point； all the redo should still be available in the online redo logs.E、 The database is not recoverable.
考题
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.
考题
You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）A、 incomplete recoveryB、 complete recoveryC、 recovery using the Flashback Database featureD、 recovery using the export/import utility
考题
Your database operates in ARCHIVELOG mode. User-managed consistent backups are performed every Sunday night. On Tuesday， client A drops a table at 8：00 a.m. as follows： SQL DROP TABLE cust_ord PURGE； Table dropped. Client B executes a query at 9：00 a.m. on the same table as follows： SQL SELECT * FROM cust_ord； SELECT * FROM cust_ord *ERROR at line 1：ORA-00942： table or view does not exist Client B needs the dropped table and reports the problem to you.With reference to this scenario， which action should you take？（）A、 retrieve the table by using the flashback featureB、 restore all the data files from last Sunday’s backup and then perform a time-based recoveryC、 restore all the data files from last Sunday’s backup and then perform a log sequence recoveryD、 restore all the data files from last Sunday’s backup and then perform a cancel-based recoveryE、 restore from last Sunday’s backup only data files that belong to the tablespace in which the table was stored and then perform a complete recovery
考题
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 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.
考题
You take backups of your hard drives every night. On Thursday morning you see that the hard disk has crashed. The backup log shows: * Friday normal backup completed * Saturday incremental backup completed * Sunday incremental backup completed * Monday incremental backup completed * Tuesday incremental backup incomplete * Wednesday incremental backup completed. What should you do to restore your data to the update state?（ ）A、Restore using the tapes from Friday， Saturday， Sunday， Monday and Wednesday.B、Restores using only Fridays tapeC、Restore using the tapes from Thursday， Friday， Saturday， Sunday and Tuesday.D、Restore using the tapes from Friday and Tuesday.E、Restore using the tapes from Tuesday and Thursday.
考题
单选题You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）A
incomplete recoveryB
complete recoveryC
recovery using the Flashback Database featureD
recovery using the export/import utility
考题
单选题You are operating your database in NOARCHIVELOG mode. Your most recent backup includes a copy of all of the data files and the control files taken when the current log sequence number was 45. You experience disk failure on the drive on which your SYSTEM tablespace data files are stored. At the time of the failure， the current log sequence number is 98. Which files should you restore to recover from the loss of the SYSTEM tablespace data files？（）A
Only the data files.B
All of the data files and the control files.C
Only the data files belonging to the SYSTEM tablespace.D
Only the data files belonging to the SYSTEM tablespace and the control files.
考题
单选题Examine the following scenario: -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（）A
Restore the latest whole backup, perform complete recovery, and open the database normallyB
Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS optionC
Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS optionD
Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option
考题
多选题Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery？ （）AYou find that one of the redo log members in each redo log group is lost.BYou find that a data file that belongs to the USERS tablespace is damaged.CYou find that a data file that belongs to the SYSTEM tablespace is damaged.DYou find that the current redo log group is damaged and is not available for recovery.EYou realized while performing a recovery that an archived redo log file needed for recovery is lost.
考题
单选题Your database operates in ARCHIVELOG mode and user/x7fmanaged 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 archivelog 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 timebased recoveryB
restore all the data files from last Sunday’s backup， and then perform a cancelbased recoveryC
restore all the data files from last Sunday’s backup， and then perform a changebased recoveryD
restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery
考题
单选题You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）A
until Thursday morningB
until that point in time when the database is openedC
until that point in time when the recovery is performedD
until last Sunday’s backupE
until that point in time when the table is dropped and purgedF
until Wednesday evening
考题
单选题You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user/x7fmanaged consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）A
until Thursday morningB
until last Sunday’s backupC
until Wednesday eveningD
until that point in time when the database is openedE
until that point in time when the recovery is performedF
until that point in time when the table is dropped and purged
考题
单选题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
热门标签
最新试卷