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 co

题目

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 file
  • B、Location of the control file
  • C、Contents of the control file in text format
  • D、SQL command to re-create the database
  • E、SQL command to re-create the control file
  • F、Contents of the control file in binary format
相似考题

1.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.

2.Where do you find information about a missing redo log file？（）A、trace fileB、audit trailC、control fileD、alert log fileE、event viewer

3. 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

4. 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 co”相关问题

  • 第1题：

    You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup， you need the database ID （DBID）. In which two sources would you find the DBID？ （）

    • A、 the alert log file
    • B、 the server parameter file
    • C、 the formatted name of a control file autobackup
    • D、 an RMAN session log file
    • E、 the trace file

    正确答案:C,D

  • 第2题：

    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 filename
    • B、Make a copy of the control file with the database shut down
    • C、Issue ALTER DATABASE BACKUP CONTROLFILE TO trace
    • D、Make a copy of the control file with the database still running 

    正确答案:B

  • 第3题：

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

    正确答案:D

  • 第4题：

    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：       RMAN>BACKUP 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 DBID
    • D、 Issue the RECOVER DATABASE command.

    正确答案:C

  • 第5题：

    You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP;  How does RMAN find the control file autobackup？（）

    • A、by using the trace file
    • B、by using the alert log file
    • C、by using the database ID
    • D、by using the server parameter file
    • E、by using the V$CONTROLFILE view
    • F、by using the autobackup format configuration setting

    正确答案:C,F

  • 第6题：

    You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？ （）

    • A、backup pieces
    • B、control file autobackups
    • C、copies of all the parameter files
    • D、trace file generated using BACKUP CONTROLFILE TO TRACE

    正确答案:A,B

  • 第7题：

    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

    正确答案:D

  • 第8题：

    单选题
    Which is not a valid way of backing up a control file？（）
    A

     Backing up the control file to trace

    B

     Copying the existing control file of the database to the backup location during a hot backup 

    C

     Copying the existing control file of the database to the backup location during a cold backup

    D

     Creating a backup control file

    E

     Using the create controlfile command


    正确答案： E
    解析： 暂无解析

  • 第9题：

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

    B

    CORE_DUMP_DEST

    C

    TRACE_DUMP_DEST

    D

    BACKUP_DUMP_DEST

    E

    BACKGROUND_DUMP_DEST


    正确答案： E
    解析： 暂无解析

  • 第10题：

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


    正确答案： A
    解析： 暂无解析

  • 第11题：

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


    正确答案： D
    解析： 暂无解析

  • 第12题：

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


    正确答案： E
    解析： 暂无解析

  • 第13题：

    You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？（）

    • A、 backup pieces
    • B、 copies of all the parameter files
    • C、 trace file generated using BACKUP CONTROLFILE TO TRACE
    • D、 control file autobackups

    正确答案:A,D

  • 第14题：

    You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup，you need the database ID （DBID）.  In which two sources would you find the DBID？ （）

    • A、the trace file
    • B、the alert log file
    • C、an RMAN session log file
    • D、the server parameter file
    • E、the formatted name of a control file autobackup

    正确答案:C,E

  • 第15题：

    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.

    正确答案:C

  • 第16题：

    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_DEST
    • B、CORE_DUMP_DEST
    • C、TRACE_DUMP_DEST
    • D、BACKUP_DUMP_DEST
    • E、BACKGROUND_DUMP_DEST

    正确答案:A

  • 第17题：

    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.

    正确答案:D

  • 第18题：

    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

    正确答案:A

  • 第19题：

    Which is not a valid way of backing up a control file？（）  

    • A、 Backing up the control file to trace
    • B、 Copying the existing control file of the database to the backup location during a hot backup 
    • C、 Copying the existing control file of the database to the backup location during a cold backup
    • D、 Creating a backup control file
    • E、 Using the create controlfile command

    正确答案:B

  • 第20题：

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


    正确答案： B
    解析： 暂无解析

  • 第21题：

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

    B

    Location of the control file

    C

    Contents of the control file in text format

    D

    SQL command to re-create the database

    E

    SQL command to re-create the control file

    F

    Contents of the control file in binary format


    正确答案： C
    解析： 暂无解析

  • 第22题：

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


    正确答案： C
    解析： 暂无解析

  • 第23题：

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


    正确答案： E,D
    解析： 暂无解析

相关内容