单选题Which of the following choices identifies a database component that will be used for multiplexing control files?（）A V$CONTROLFILE B V$DATABASE C init.ora D DBA FILES

题目
单选题
Which of the following choices identifies a database component that will be used for multiplexing control files?（）
A

V$CONTROLFILE 

B

V$DATABASE 

C

init.ora 

D

DBA FILES

相似考题

1.You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?（）A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.

2.Which of the following best describes a full backup? （）A、All datafiles of a database B、All datafiles, archive logs, and control files C、All datafiles and control files D、All the used blocks in a datafile

3.Which of the following choices identifies a database component that will be used for multiplexing control files?（）A、V$CONTROLFILE B、V$DATABASE C、init.ora D、DBA FILES

4. Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command：   RESTORE CONTROLFILE FROM AUTOBACKUP；   Which of the following statements is true？（） A、 The command restores only the missing control file.B、 The command restores all the control files.C、 The command fails because the database is running.D、 This is the correct way to address this problem.E、 This is not the correct way to address this problem.

更多“单选题Which of the following choices identifies a database component that will be used for multiplexing control files?（）A V$CONTROLFILE B V$DATABASE C init.ora D DBA FILES”相关问题

  • 第1题：

    Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（） 

    • A、 redo logs
    • B、 control file
    • C、 temporary files of temporary tablespace
    • D、 the latest backup of only the damaged data file
    • E、 the latest backup of all the data files In the USERS tablespace

    正确答案:A,B,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 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

  • 第4题：

    Which two statements are correct about database transportation? （）

    • A、The source and target platforms must be the same
    • B、Redo logs, control files and temp files are also transported
    • C、The transported database must have the same database identifier (DBID) as the source database and cannot be changed
    • D、The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
    • E、Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

    正确答案:D,E

  • 第5题：

    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

  • 第6题：

    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

  • 第7题：

    You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）

    • A、When the instance is started 
    • B、When the database is mounted 
    • C、When the database is opened 
    • D、When the database is closed

    正确答案:A

  • 第8题：

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

  • 第9题：

    多选题
    Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command：   RESTORE CONTROLFILE FROM AUTOBACKUP；   Which of the following statements is true？（）
    A

    The command restores only the missing control file.

    B

    The command restores all the control files.

    C

    The command fails because the database is running.

    D

    This is the correct way to address this problem.

    E

    This is not the correct way to address this problem.


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

  • 第10题：

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

  • 第11题：

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

  • 第12题：

    多选题
    In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）
    A

    the V$LOG view

    B

    the V$DBFILE view

    C

    the V$LOGFILE view

    D

    the V$INSTANCE_RECOVERY view

    E

    Oracle Enterprise Manager Database Control


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

  • 第13题：

    You executed the following command to start the database：  SQL> STARTUP  ORACLE instance started.  Total System Global Area 281018368 bytes  Fixed Size 789000 bytes  Variable Size 229635576 bytes  Database Buffers 50331648 bytes  Redo Buffers 262144 bytes ORA-00205： error in identifying controlfile， check alert log for more info  Which view would you query at this stage to investigate this missing control file？（）

    • A、V$INSTANCE
    • B、V$CONTROLFILE
    • C、DBA_CONTROL_FILES
    • D、V$DATABASE_PROPERTIES
    • E、V$CONTROLFILE_RECORD_SECTION

    正确答案:B

  • 第14题：

    In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）

    • A、the V$LOG view
    • B、the V$DBFILE view
    • C、the V$LOGFILE view
    • D、the V$INSTANCE_RECOVERY view
    • E、Oracle Enterprise Manager Database Control

    正确答案:D,E

  • 第15题：

    Which three statements are true about the stages of database startup？（）

    • A、Data files and redo log files can be renamed at the MOUNT stage.
    • B、Control files are read at the OPEN stage for the location of data files.
    • C、Control files are required to bring the database to the NOMOUNT stage.
    • D、Data files and redo log files are made available to users at the OPEN stage.
    • E、Data files and online redo log files are checked for consistency while opening the database

    正确答案:A,D,E

  • 第16题：

    If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）

    • A、V_CONTROLFILE_RECORD_SECTION 
    • B、V_CONTROLFILE 
    • C、V$PARAMETER 
    • D、init.ora file

    正确答案:A

  • 第17题：

    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

  • 第18题：

    Which of the following files cannot be backed up by RMAN? （）(Choose all that apply.）

    • A、Database datafiles
    • B、Control files
    • C、Online redo logs
    • D、Database pfiles
    • E、Archived redo logs

    正确答案:C,D

  • 第19题：

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


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

  • 第20题：

    单选题
    You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）
    A

    When the instance is started 

    B

    When the database is mounted 

    C

    When the database is opened 

    D

    When the database is closed


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

  • 第21题：

    单选题
    Which of the following best describes a full backup? （）
    A

    All datafiles of a database 

    B

    All datafiles, archive logs, and control files 

    C

    All datafiles and control files 

    D

    All the used blocks in a datafile


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

  • 第22题：

    单选题
    Examine the following scenario: -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（）
    A

    Restore the latest whole backup, perform complete recovery, and open the database normally

    B

    Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option

    C

    Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option

    D

    Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option


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

  • 第23题：

    单选题
    What command would you issue to enable automated backups of control files? （）
    A

    alter database controlfile autobacku on

    B

    alter system controlfile autobackup on 

    C

    configure controlfile autobackup on 

    D

    enable controlfile autobackup


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

相关内容