网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement:       SQL>ALTER DATABASE OPEN RESETLOGS;   Which of the following options is true about using the RESETLOGS option?()

  • A、 The log sequence is reset to 0.
  • B、 All the online redo logs are deleted.
  • C、 All the archived redo logs from a previous incarnation become useless.
  • D、 The full database backup taken from a previous incarnation can be used in future.
  • E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

参考答案

更多 “ You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement:       SQLALTER DATABASE OPEN RESETLOGS;   Which of the following options is true about using the RESETLOGS option?()A、 The log sequence is reset to 0.B、 All the online redo logs are deleted.C、 All the archived redo logs from a previous incarnation become useless.D、 The full database backup taken from a previous incarnation can be used in future.E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.” 相关考题
考题 Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.Which three steps should you perform to recover the control file and make the database fully operational?()A. Mount the container database (CDB) and restore the control file from the control file auto backup.B. Recover and open the CDB in NORMAL mode.C. Mount the CDB and then recover and open the database, with the RESETLOGS option.D. Open all the pluggable databases.E. Recover each pluggable database.F. Start the database instance in the nomount stage and restore the control file from control file auto backup.

考题 You have discovered that one of three control files has been lost. What steps would you follow to recover that control file?()   a. Shut down the database.  b. Restore a control-file copy from backup media.  c. Use the create control file command to create a new control file.  d. Copy the backup control file into place.  e. Create a new copy of the control file from one of the surviving control files.  f. Recover the database using the recover database using backup control file command.  g. Start up the database. A、a, b, f, gB、c, f, gC、a, d, f, gD、a, f, gE、a, e, g

考题 Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario?()A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.

考题 You performed an incomplete recovery on your Oracle Database 10g database using the following command:   SQL RECOVER DATABASE  2 UNTIL TIME ’2004-08-05:12:10:03’ 3 USING BACKUP CONTROLFILE;  In which situation would the above recovery be required?()A、 A user table was lost at the specified time.B、 A redo log file was lost at the specified time.C、 The backup control file is on a faster disk than the current one.D、 The current control file has a different path compared with the intended time of recovery.E、 The current control file does not match the physical structure of the database at the intended time of recovery.

考题 You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider?()A、 take data files from the read-only tablespace offline before performing a recoveryB、 recovery using backup control file is not possible, so restore all the files from the last full database backup, and then open the databaseC、 drop the read-only tablespace and re-create the tablespace after recoveryD、 perform a recovery; status of the tablespace in control file will be changed automatically

考题 You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()A、Start the instance and open the database, instance recovery automatically recoverscontrol filesB、Create a file based on the contents of the trace file and save it to the control file locations and start the databaseC、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.)D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

考题 You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?()A、Mount the databaseB、Open the database in NORMAL modeC、Open the database in RESTRICTED modeD、Open the database with the RESETLOGS option

考题 You work as a database administrator for Supportcenter.cn. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task?()A、Shut down the instance, copy the control file to the third location and open the database.B、Abort the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.C、Copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile, restart the instance and open the database.D、Shut down the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.E、Shut down the instance, startup in the mount state, copy the control file to the third location, modify the CONTROL_FILES parameter ininit.oraand open the database.

考题 In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command: RMAN RESTORE CONTROLFILE;  Which two operations do you need to perform after restoring the control file from backup?()A、shut down and restart the instanceB、add new tempfiles to the temporary tablespaces after recoveryC、perform a media recovery and open the database with the RESETLOGS optionD、perform a media recovery and bring the database to NOARCHIVELOG mode

考题 You have a read/x7fonly tablespace on read/x7fonly media. You want to perform a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the status of the read/x7fonly tablespace was read/write when the control file was backed up. What should you consider?()A、drop the read­only tablespace and re­create the tablespace after recoveryB、take data files from the read­only tablespace offline before performing a recoveryC、perform a recovery; status of the tablespace in control file will be changed automaticallyD、recovery using backup control file is not possible, so restore all the files from the last full database backup, and then open the database

考题 You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command?()A、DatafilesB、 Current control fileC、 Server parameter file (spfile)D、 Password file

考题 You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6:00 P.M. on Monday, you issue the following command:       RMANBACKUP DATABASE;  At 8:00 A.M. on Tuesday, you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP; command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP; command?()A、 Start the database in the MOUNT stage.B、 Back up the control file to trace.C、 Set the DBIDD、 Issue the RECOVER DATABASE command.

考题 You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()A、Database Datafiles B、Database Control Files C、Online redo logsD、Archived redo logs E、The database SPFILE F、None of the above, all these files are backed up. 

考题 You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database?()A、Start the instance and open the database, instance recovery automatically recovers control files B、Create a file based on the contents of the trace file and save it to the control file locations and start the database C、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

考题 You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery?()  A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command

考题 You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement:    SQLALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400;    What is the outcome of this statement? ()A、 The statement will not execute successfully.B、 The statement will execute successfully, and the backups metadata will be maintained in the control file for 400 daysC、 The statement will execute successfully, and the backups metadata will be maintained in the recovery catalog for 400 days.D、 Backups will be deleted from the media after 400 days.

考题 单选题You work as a database administrator for Supportcenter.cn. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task?()A Shut down the instance, copy the control file to the third location and open the database.B Abort the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.C Copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile, restart the instance and open the database.D Shut down the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.E Shut down the instance, startup in the mount state, copy the control file to the third location, modify the CONTROL_FILES parameter ininit.oraand open the database.

考题 单选题You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement:    SQLALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400;    What is the outcome of this statement? ()A  The statement will not execute successfully.B  The statement will execute successfully, and the backups metadata will be maintained in the control file for 400 daysC  The statement will execute successfully, and the backups metadata will be maintained in the recovery catalog for 400 days.D  Backups will be deleted from the media after 400 days.

考题 多选题Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs. Which three steps should you perform to recover the control file and make the database fully operational?()AMount the container database (CDB) and restore the control file from the control file auto backup.BRecover and open the CDB in NORMAL mode.CMount the CDB and then recover and open the database, with the RESETLOGS option.DOpen all the pluggable databases.ERecover each pluggable database.FStart the database instance in the nomount stage and restore the control file from control file auto backup.

考题 单选题You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement:       SQLALTER DATABASE OPEN RESETLOGS;   Which of the following options is true about using the RESETLOGS option?()A  The log sequence is reset to 0.B  All the online redo logs are deleted.C  All the archived redo logs from a previous incarnation become useless.D  The full database backup taken from a previous incarnation can be used in future.E  Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

考题 单选题You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command?()A DatafilesB  Current control fileC  Server parameter file (spfile)D  Password file

考题 单选题You performed an incomplete recovery on your Oracle Database 10g database using the following command:  SQL RECOVER DATABASE  2 UNTIL TIME ’2004/x7f08/x7f05:12:10:03’  3 USING BACKUP CONTROLFILE;  In which situation would the above recovery be required?()A A user table was lost at the specified time.B A redo log file was lost at the specified time.C The backup control file is on a faster disk than the current one.D The current control file has a different path compared with the intended time of recovery.E The current control file does not match the physical structure of the database at the intended time of recovery.

考题 多选题Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()AThe instance aborts.BThe database cannot be recovered.CThe database can be recovered by restoring the control files from the backup.DThe database remains opened and you have to shut it down with the ABORT option.EThe database can be restored till the point of the last closed whole database backup.

考题 单选题Assume your situation can be described as follows: x A full backup taken using RMAN is available on disk.  x The current control files were NOT damaged and do not need to be restored.  x All data files are damaged or lost.  x The database is in NOARCHIVELOG mode.  Which RMAN command would be most appropriate to use in line 3 of the following RMAN command set to restore and fully recover your database?() 1. RMAN STARTUP MOUNT  2. RMAN RESTORE DATABASE;  3. RMAN ()  4. RMAN ALTER DATABASE OPEN;A RECOVER DATABASE;B SWITCH DATAFILE ALL;C RESTORE CONTROL FILE;D RECOVER DATABASE USING BACKUP CONTROL FILE;

考题 单选题You performed an incomplete recovery on your Oracle Database 10g database using the following command:   SQL RECOVER DATABASE  2 UNTIL TIME ’2004-08-05:12:10:03’ 3 USING BACKUP CONTROLFILE;  In which situation would the above recovery be required?()A  A user table was lost at the specified time.B  A redo log file was lost at the specified time.C  The backup control file is on a faster disk than the current one.D  The current control file has a different path compared with the intended time of recovery.E  The current control file does not match the physical structure of the database at the intended time of recovery.

考题 单选题You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()A  Database DatafilesB  Database Control FilesC  Online redo logsD  Archived redo logsE  The database SPFILEF  None of the above,all these files are backed up

考题 单选题You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery?()A  You will need to open the database with the resetlogs command.B  All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C  You will use the resetlogs version of the create controlfile command.D  You will use the noresetlogs version of the create controlfile command.E  You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command