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

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

查看答案

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

查看答案

考题 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 executed the following command to back up your control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； Which initialization parameter is used to specify the location of the trace file？（）A、USER_DUMP_DESTB、CORE_DUMP_DESTC、TRACE_DUMP_DESTD、BACKUP_DUMP_DESTE、BACKGROUND_DUMP_DEST

查看答案

考题 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 of the following scenarios is a tablespace recovery required？（）A、 when recovering a lost read-only tablespace from a read-only tablespace backupB、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in ARCHIVELOG modeC、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in NOARCHIVELOG mode and the changes in the online redo log files have been overwrittenD、 when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only

查看答案

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

查看答案

考题单选题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 backed up the control file to trace. Which statement is true about the trace file generated？（）A The trace file is in binary format.B The trace file has a SQL script to re-create the control file.C The trace file is a backup set created during the backup of the control file. D The trace file contains the instructions to manually re-create the control file.E The trace file is an image copy of the control file created during the backup of the control file.

查看答案

考题单选题You executed the following command to back up your control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； Which initialization parameter is used to specify the location of the trace file？（）A USER_DUMP_DESTB CORE_DUMP_DESTC TRACE_DUMP_DESTD BACKUP_DUMP_DESTE BACKGROUND_DUMP_DEST

查看答案

考题单选题You issue this SQL statement： ALTER DATABASE RENAME FILE ’/ORADATA/u02/user_data01.dbf’ TO ’/ORADATA/u04/user_data01.dbf’； What does this SQL statement do？（）A It updates the control file with the new location of the data file. B It updates only the data dictionary with the new location of the data file. C It changes the location of the user_data01.dbf file in the operating system. D It changes the location of the user_data01.dbf file in the operating system and updates the control file with the new location of the data file.

查看答案

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

查看答案

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

查看答案

考题单选题In which of the following scenarios is a tablespace recovery required？（）A when recovering a lost read-only tablespace from a read-only tablespace backupB when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in ARCHIVELOG modeC when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in NOARCHIVELOG mode and the changes in the online redo log files have been overwrittenD when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only

查看答案

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

查看答案

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

查看答案

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

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