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

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

相似考题

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

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

3.You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？（）A、 backup piecesB、 copies of all the parameter filesC、 trace file generated using BACKUP CONTROLFILE TO TRACED、 control file autobackups

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

参考答案和解析
正确答案： B
解析： 暂无解析
更多“单选题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 ”相关问题

  • 第1题：

    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.

    正确答案:D

  • 第2题：

    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

  • 第3题：

    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

    • A、 when you change the name of a datafile
    • B、 when you drop a table from the database
    • C、 when you take an export of the database
    • D、 when you back up the database using OS utilities
    • E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
    • F、 when you issue a BACKUP command from inside the RMAN run block

    正确答案:A,E,F

  • 第4题：

    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

  • 第5题：

    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

  • 第6题：

    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

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

    单选题
    You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files：  $ rman target /  What would be the effect of this command？（）
    A

    RMAN would use the current operating system location to place the backup.

    B

    RMAN would use the control file of the target database to maintain the backup.

    C

    RMAN would use the recovery catalog of the target database to maintain the backup.

    D

    RMAN would use the control file of the target database to maintain the backup metadata. 

    E

    RMAN would use the recovery catalog of the target database to maintain the backup metadata.


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

  • 第9题：

    多选题
    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
    A

    when you change the name of a datafile

    B

    when you drop a table from the database

    C

    when you take an export of the database

    D

    when you back up the database using OS utilities

    E

    when you issue an ALTER SYSTEM SWITCH LOGFILE statement

    F

    when you issue a BACKUP command from inside the RMAN run block


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

  • 第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题：

    单选题
    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
    解析： 暂无解析

  • 第12题：

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

    B

    c， f， g

    C

    a， d， f， g

    D

    a， f， g

    E

    a， e， g


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

  • 第13题：

    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

  • 第14题：

    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 files
    • B、 alert log files
    • C、 control file
    • D、 datafiles associated with the SYSTEM tablespace

    正确答案:C

  • 第15题：

    You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files：  $ rman target /  What would be the effect of this command？（）

    • A、RMAN would use the current operating system location to place the backup.
    • B、RMAN would use the control file of the target database to maintain the backup.
    • C、RMAN would use the recovery catalog of the target database to maintain the backup.
    • D、RMAN would use the control file of the target database to maintain the backup metadata. 
    • E、RMAN would use the recovery catalog of the target database to maintain the backup metadata.

    正确答案:D

  • 第16题：

    Which command will result in a trace file being created with the create controlfile command contained in it？（）  

    • A、 alter database backup controlfile
    • B、 alter database backup controlfile to trace
    • C、 alter database controlfile backup
    • D、 alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’
    • E、 alter database begin controlfile backup

    正确答案:B

  • 第17题：

    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

  • 第18题：

    单选题
    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
    解析： 暂无解析

  • 第19题：

    单选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： % rman target / What would be the effect of this command？（）
    A

     RMAN would use the current operating system location to place the backup.

    B

     RMAN would use the control file of the target database to maintain the backup.

    C

     RMAN would use the recovery catalog of the target database to maintain the backup.

    D

     RMAN would use the control file of the target database to maintain the backup metadata.

    E

     RMAN would use the recovery catalog of the target database to maintain the backup metadata.


    正确答案： 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题：

    单选题
    Which command will result in a trace file being created with the create controlfile command contained in it？（）
    A

     alter database backup controlfile

    B

     alter database backup controlfile to trace

    C

     alter database controlfile backup

    D

     alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’

    E

     alter database begin controlfile backup


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

  • 第23题：

    单选题
    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
    解析： 暂无解析

  • 第24题：

    单选题
    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
    解析： 暂无解析

相关内容