网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
In which scenario will you issue the following command？（） SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING BACKUP CONTROLFILE；
A
when all the control files are missing and only a binary backup of the current control file exists
B
when a multiplexed copy of the current control file is missing
C
when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists
D
when the SPFILE is missing
参考答案
参考解析
解析：
暂无解析
更多 “单选题In which scenario will you issue the following command？（） SQL RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING BACKUP CONTROLFILE；A when all the control files are missing and only a binary backup of the current control file existsB when a multiplexed copy of the current control file is missingC when all the control files are missing and only a script containing the CREATE CONTROLFILE statement existsD when the SPFILE is missing” 相关考题
考题
What methods are available to recover lost control files？（） A、 Backup control file.B、 Emergency control file.C、 The create controlfile command.D、 The restore controlfile SQL*Plus command.E、 No backup is required. The database will re-create the control file when it is discovered to be lost.
考题
You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）A、A text copy of the control file.B、A binary copy of the control file.C、A file containing a SQL statement which will re-create the database.D、A file containing a SQL statement which will re-create the control file.
考题
You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）A、Image of the control fileB、Location of the control fileC、Contents of the control file in text formatD、SQL command to re-create the databaseE、SQL command to re-create the control fileF、Contents of the control file in binary format
考题
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.
考题
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile
考题
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.
考题
ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?（）A、Issue ALTER DATABASE BACKUP CONTROLFILE TO filenameB、Make a copy of the control file with the database shut downC、Issue ALTER DATABASE BACKUP CONTROLFILE TO traceD、Make a copy of the control file with the database still running
考题
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 issued the following statement： SQL ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What will be the result of issuing the statement？（） A、 The control file will be multiplexed.B、 The control file will be recreated.C、The script containing the CREATE CONTROLFILE statement will be created.D、 The binary backup of the control file will be created.
考题
You issued the following RMAN command： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； What is NOT an impact of using the above command？（）A、 When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.B、 When a structural change is made to the database， then a backup of the current control file is performed.C、 When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.D、 When a structural change is made to the database， then a backup of the alert log file will be performed.
考题
In which situation will you run the script containing the following statement？（） CREATE CONTROLFILE REUSE DATABASE SALES NORESETLOGS ARCHIVELOG MAXLOGFILES 20 MAXLOGMEMBERS 3 MAXDATAFILES 30 MAXINSTANCES 10 MAXLOGHISTORY 1200 LOGFILE GROUP 1 （ ’/disk1/prod/orders/db/log1a.dbf’， ’/disk2/prod/orders/db/log1b.dbf’ ）SIZE 100K GROUP 2 （ ’/disk1/prod/orders/db/log2a.dbf’， ’/disk2/prod/orders/db/log2b.dbf’ ） SIZE 100K， DATAFILE ’/disk1/prod/orders/db/database1.dbf’， ’/disk2/prod/orders/db/file1.dbf ’； A、 when all the control files are missing and only a binary backup of the current control file existsB、 when a multiplexed copy of the current control file is missingC、 when all the control files are missing and only an ASCII representation of the binary control file existsD、 when the SPFILE is missing
考题
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 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.
考题
In which scenario will you issue the following command？（） SQL RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING BACKUP CONTROLFILE；A、 when all the control files are missing and only a binary backup of the current control file existsB、 when a multiplexed copy of the current control file is missingC、when all the control files are missing and only a script containing the CREATE CONTROLFILE statement existsD、 when the SPFILE is missing
考题
You performed a backup of the flash recovery area by using the following command for the first time： RMAN BACKUP RECOVERY AREA; Which files in the flash recovery area are backed up？（）A、flashback logsB、current control fileC、control file autobackupsD、incremental backup sets
考题
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 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.
考题
单选题In which situation will you run the script containing the following statement？（） CREATE CONTROLFILE REUSE DATABASE SALES NORESETLOGS ARCHIVELOG MAXLOGFILES 20 MAXLOGMEMBERS 3 MAXDATAFILES 30 MAXINSTANCES 10 MAXLOGHISTORY 1200 LOGFILE GROUP 1 （ ’/disk1/prod/orders/db/log1a.dbf’， ’/disk2/prod/orders/db/log1b.dbf’ ）SIZE 100K GROUP 2 （ ’/disk1/prod/orders/db/log2a.dbf’， ’/disk2/prod/orders/db/log2b.dbf’ ） SIZE 100K， DATAFILE ’/disk1/prod/orders/db/database1.dbf’， ’/disk2/prod/orders/db/file1.dbf ’；A
when all the control files are missing and only a binary backup of the current control file existsB
when a multiplexed copy of the current control file is missingC
when all the control files are missing and only an ASCII representation of the binary control file existsD
when the SPFILE is missing
考题
单选题You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）A
A text copy of the control file.B
A binary copy of the control file.C
A file containing a SQL statement which will re-create the database.D
A file containing a SQL statement which will re-create the control file.
考题
单选题You issued the following statement： SQL ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What will be the result of issuing the statement？（）A
The control file will be multiplexed.B
The control file will be recreated.C
The script containing the CREATE CONTROLFILE statement will be created.D
The binary backup of the control file will be created.
考题
单选题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 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.
考题
多选题What methods are available to recover lost control files？（）ABackup control file.BEmergency control file.CThe create controlfile command.DThe restore controlfile SQL*Plus command.ENo backup is required. The database will re-create the control file when it is discovered to be lost.
考题
单选题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.
考题
单选题You issued the following RMAN command： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； What is NOT an impact of using the above command？（）A
When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.B
When a structural change is made to the database， then a backup of the current control file is performed.C
When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.D
When a structural change is made to the database， then a backup of the alert log file will be performed.
考题
单选题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 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
热门标签
最新试卷