违法和不良信息举报 联系客服
免费注册 登录

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

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

第2题：

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

第3题：

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.


参考答案：B

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

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

第6题：

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

正确答案:C

第7题：

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

第8题：

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

第9题：

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

第10题：

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

更多相关问题
相关内容