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

Your database is running in ARCH

题目

Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backupand specify the KEEP clause.Which components are backed up when this option is specified?（）

  • A、only the control file, the current SPFILE, and data files
  • B、only the current SPFILE and data files if autobackup is disabled
  • C、only the data files and the archived redo logs
  • D、the control file, current SPFILE file, data files, and archived redo logs
参考答案和解析
正确答案:D
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You database is running an ARCHIVELOG mode.The following parameter are set in your database instance:LOG_ARCHIVE_FORMAT = arch+%t_%r.arcLOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’DB_RECOVERY_FILE_DEST_SIZE = 50GDB_RECOVERY_FILE = ‘/u01/oradata’Which statement is true about the archived redo log files?（）

A. They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.

B. They are created only in the Fast Recovery Area.

C. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.

D. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.


参考答案：B

第2题：

Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.  Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）

  • A、the retention period to support flashback
  • B、the expected length of the longest-running query
  • C、the number of undo tablespaces in the database
  • D、the size of the Flash Recovery Area for the database instance

正确答案:A,B

第3题：

Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()

A. Oracle Net Manager

B. Listener Control utility

C. Database Configuration Assistant

D. Oracle Net Configuration Assistant


参考答案：B

第4题：

You want to set the following initialization parameters for your database instance：   LOG_ARCHIVE_DEST_1 = ’LOCATION=/disk1/arch’ LOG_ARCHIVE_DEST_2 = ’LOCATION=/disk2/arch’ LOG_ARCHIVE_DEST_3 = ’LOACTION=/disk3/arch’ LOG_ARCHIVE_DEST_4 = ’LOCATION=/disk4/arch MANDATORY’   Identify the statement that correctly describes this setting.（）  

  • A、 The MANDATORY location must be a flash recovery area.
  • B、 The optional destinations may not use the flash recovery area.
  • C、 This setting is not allowed because the first destination is not set as MANDATORY.
  • D、 The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

正确答案:D

第5题：

The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server：  LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc  LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’  DB_RECOVERY_FILE_DEST = ’/u01/oradata’  DB_RECOVERY_FILE_DEST_SIZE = 20G  Which statement is true regarding the archived redo log files（）

  • A、It will be created on the local file system.
  • B、It will be created only in the Flash Recovery Area.
  • C、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.
  • D、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.

正确答案:A

第6题：

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

第7题：

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）

  • A、archival
  • B、log writer
  • C、database writer
  • D、system monitor
  • E、process monitor
  • F、change tracking writer

正确答案:A,B,C

第8题：

Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL> SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?（）

A. User process

B. Server process

C. System Monitor (SMON)

D. Process Monitor (PMON)

E. Checkpoint process (CKPT)


参考答案：B

第9题：

In your database， you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this？ （）

  • A、%t_%s.dbf
  • B、arch_%t.arc
  • C、arch_%d.arc
  • D、arch_%t_%d.arc
  • E、arch_%d_%s_.dbf
  • F、arch_%t_%s_%r.arc

正确答案:F

第10题：

You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

  • A、 UNTIL SEQUENCE
  • B、 UNTIL SCN
  • C、 UNTIL CHANGE
  • D、 UNTIL CANCEL

正确答案:C,D

更多相关问题
相关内容