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

题目内容 (请给出正确答案)
单选题
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 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 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 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.

考题 If you lost your entire database,including the database spfile,control files,online redo logs,and database datafiles,what kind of recovery would be required with RMAN?()  A、 Complete database recovery.B、 Incomplete database recovery.C、 Approximate database recovery.D、 Archived database recovery.E、 The database could not be recovered with RMAN.

考题 While planning to manage more than one database in your system, you perform the following activities:  1. Organize different categories of files into independent subdirectories.  2. Use consistent naming convention for database files.  3. Separate administrative information pertaining to each database.  Which option corresponds to the type of activities performed by you?()A、Oracle Managed FilesB、Oracle Grid ArchitectureC、Optimal Flexible ArchitectureD、Oracle database architecture

考题 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.

考题 In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()A、Oracle Migration AssistantB、Recovery Manager (RMAN)C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance

考题 You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()A、 online redo log filesB、 alert log filesC、 control fileD、 datafiles associated with the SYSTEM tablespace

考题 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 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 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 using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option? ()A、This operation resets the SCN for the database.B、This operation creates a new incarnation of the database.C、This operation moves all the redo log files to a different location.D、This operation deletes the old redo log files and creates new redo log files.E、This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

考题 You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?()A、 You do not need to restore all the data files.B、 You do not need to open the database with the RESETLOGS operationC、 You do not need to perform a full backup after the RESETLOGS operation.D、 You do not need to recover all the data files to the same system change number (SCN).

考题 单选题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 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 working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology, you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation, you make the following changes in your initialization parameter file:LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d:/product/10.1.0/flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database?()A  The archived redo logs are stored in an operating system-dependent location.B  The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.C  The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.D  The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.

考题 单选题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 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 operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery.  Which two tasks would you be required to perform in the recovery process? ()Aopen the database with the RESETLOGS optionBopen the database with the RESTRICTED optionCrecover all the data files to the same system change number (SCN)Drecover to the required SCN only that data file in which the error occurred

考题 单选题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

考题 单选题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 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 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 Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option? ()AThis operation resets the SCN for the database.BThis operation creates a new incarnation of the database.CThis operation moves all the redo log files to a different location.DThis operation deletes the old redo log files and creates new redo log files.EThis operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

考题 多选题Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process?()Aopen the database with the RESTRICTED optionBopen the database with the RESETLOGS optionCrecover to the required SCN only that data file in which the error occurredDrecover all the data files to the same system change number (SCN)

考题 单选题If you lost your entire database,including the database spfile,control files,online redo logs,and database datafiles,what kind of recovery would be required with RMAN?()A  Complete database recovery.B  Incomplete database recovery.C  Approximate database recovery.D  Archived database recovery.E  The database could not be recovered with RMAN.

考题 单选题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.

考题 单选题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