The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the 

题目
单选题
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?()
A

 The tape I/O performed is asynchronous

B

 The tape buffer is allocated from the System Global Area (SGA)

C

 The tape buffer is allocated from the Program Global Area (PGA)

D

 Oracle I/O uses an interrupt mechanism to determine when each I/O completes

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You set the following parameters in the parameter file and restarted the database:Which two statements are true regarding these parameters after the database instance is restarted?()

A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB

B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually

C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero

D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively


参考答案:A, D

第2题:

You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?()

  • A、 The EVENT parameter was not set
  • B、 The SQL_TRACE parameter is set to FALSE
  • C、 The Enterprise Manager Grid Control is not used
  • D、 The STATISTICS_LEVEL parameter is set to BASIC
  • E、 The TIMED_STATISTICS parameter is set to FALSE

正确答案:D

第3题:

You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()

A. Set MEMORY_TARGET to zero

B. Set the STATISTICS_LEVEL parameter to BASIC

C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL

D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value


参考答案:D

第4题:

You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()

  • A、Set the UNDO_RETENTION parameter to AUTO.
  • B、Create an initial undo segment in undotablespace.
  • C、Set the UNDO_RETENTION parameter to 900 or more
  • D、Set the initialization parameter UNDO_MANAGEMENT to AUTO
  • E、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

正确答案:D,E

第5题:

The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?()

  • A、The tape I/O performed is asynchronous
  • B、The tape buffer is allocated from the System Global Area (SGA)
  • C、The tape buffer is allocated from the Program Global Area (PGA)
  • D、Oracle I/O uses an interrupt mechanism to determine when each I/O completes

正确答案:C

第6题:

已知wage.getItem().size()的值是1。要想使执行session.update(wage)时自动执行session.update(wage.getItems().get(0)),必须配置()

  • A、<set name=”items” inverse=”true” cascade=”none”>…</set>
  • B、<set name=”items” inverse=”false” cascade=”none”>…</set>
  • C、<set name=”items” inverse=”true” cascade=”all”>…</set>
  • D、<set name=”items” inverse=”false”  cascade=”save-update”>…</set>

正确答案:D

第7题:

You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%, respectively. From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?()

  • A、The EVENT parameter was not set.
  • B、The SQL_TRACE parameter is set to FALSE
  • C、The Enterprise Manager Grid Control is not used.
  • D、The STATISTICS_LEVEL parameter is set to BASIC
  • E、The TIMED_STATISTICS parameter is set to FALSE

正确答案:D

第8题:

You have the following requirements in relation to the detection of block corruption for your database instance:1. Check for logical self-consistency of data blocks when modified in memory.2. Checksums are calculated before and after the block change.3. Checks are performed for the lost writes to the physical standby database.Which method would help you perform the above checks automatically? ()

A. Set the DB_SECUREFILE parameter to PERMITTED

B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY

C. Set the DB_LOCK_CHECKSUM parameter to TYPICAL

D. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL


参考答案:B

第9题:

You work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason, and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views, you find that the buffer cache hit ratio is 81% but no alerts are being generated.  What could be the reason for this problem?()

  • A、The advisory memory has been turned off.
  • B、The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
  • C、The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
  • D、The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
  • E、The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

正确答案:C

第10题:

You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups.Which action should you take?()

  • A、Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE
  • B、Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE
  • C、Use compression when performing tape backups
  • D、Configure multiple SBT channels

正确答案:B

更多相关问题