CMS专题

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

正确答案:D

第2题:

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

第3题:

The most commonly used locking level in implementing concurrency control is at which of the following levels?

A.database

B.table

C.record

D.field


正确答案:C

第4题:

Which files are required for a full recovery of the database in ARCHIVELOG mode?()

  • A、 Database datafiles
  • B、 Online redo logs
  • C、 Archived redo logs
  • D、 Backup control file
  • E、 Control file from a backup

正确答案:A,C,D

第5题:

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

第6题:

Which of the following is a differentiating feature of file permissions as compared to share permissions?()

  • A、File permissions are less granular than share permissions.
  • B、Full control can only be set using file permissions.
  • C、File permissions are more granular than share permissions.
  • D、Full control can only be set using share permissions.

正确答案:C

第7题:

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused, and whenever a new record is added to the reusable section of the control file. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME parameter?()

  • A、 Zero
  • B、 One or more
  • C、 NONE
  • D、 DEFAULT

正确答案:B

第8题:

Which interface is used to configure debug parameters for log files?()

  • A、Datastore Control Center  
  • B、Alarm and Trace Configuration  
  • C、Custom File Configuration  
  • D、Control Center 

正确答案:B

第9题:

Which six files are maintained in the Flash Recovery Area?()

  • A、 control file
  • B、 RMAN files
  • C、 password file
  • D、 parameter file
  • E、 flashback logs
  • F、 data file copies
  • G、 core dump files
  • H、 archived log files
  • I、 RMAN recovery scripts
  • J、 control file autobackpus

正确答案:A,B,E,F,H,J

第10题:

In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?()

  • A、Password file 
  • B、Initialization file 
  • C、Datafile 
  • D、Control file 
  • E、Nothing - SYSDBA privileges are not required for these actions

正确答案:E

更多相关问题