单选题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？（）AThe tape I/O performed is asynchronousBThe tape buffer is allocated from the System Global Area 

题目
单选题
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 want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()A. Set MEMORY_TARGET to zeroB. Set the STATISTICS_LEVEL parameter to BASICC. Set the WORKAREA_SIZE_POLICY parameter to MANUALD. Set the PGA_AGGREGATE_TARGET parameter to nonzero value

2.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 MBB. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manuallyC. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zeroD. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively

3.已知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＞

4.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 PERMITTEDB. Set the DB_ULTRA_SAFE parameter to DATA_ONLYC. Set the DB_LOCK_CHECKSUM parameter to TYPICALD. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL

更多“The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the ”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

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


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

  • 第6题：

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


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

  • 第7题：

    单选题
    You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process.  Which action will enable you to disable the trace files generated by the ARCn background process？（）
    A

     Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.

    B

     Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.

    C

     Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.

    D

     Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.


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

  • 第8题：

    单选题
    You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE; Which is true about the result of this command?（）
    A

    The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.

    B

    The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.

    C

    The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.

    D

    Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.


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

  • 第9题：

    单选题
    You have included the following parameter settings in your SPFILE://    SGA_MAX_SIZE=8G   SGA_TARGET=6G   DB_CACHE_SIZE=2G   SHARED_POOL_SIZE=1G   LOG_BUFFER=64M   DB_KEEP_CACHE_SIZE=960M   Which statement is true if you modify the SGA_TARGET initialization parameter？（）
    A

    The SGA_TARGET initialization parameter cannot be set to a value greater than 8G

    B

     The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2G

    C

     The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2G

    D

     The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value greater than 960M 

    E

     The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value less than 960M


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

  • 第10题：

    单选题
    You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file：   INSTANCE_TYPE = ASM  ASM_POWER_LIMIT = 11  LARGE_POOL_SIZE = 4M   ASM_DISKGROUPS = DG1， DG2  DB_UNIQUE_NAME = +ASM   You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）
    A

     only the INSTANCE_TYPE initialization parameter is set to an invalid value

    B

     only the ASM_POWER_LIMIT initialization parameter is set to an invalid value

    C

     only the LARGE_POOL_SIZE initialization parameter is set to an invalid value

    D

     both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values


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

  • 第11题：

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


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

  • 第12题：

    单选题
    You have created a password file using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=3   Which of the following is true about this password file？（）
    A

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.

    B

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.

    C

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then the SYSDBA and SYSOPER privileges can be granted to other users as long as space in the password file is

    D

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then the SYSDBAand SYSOPER privileges can be granted to other users as long as space in the password file is available.


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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file：   INSTANCE_TYPE = ASM  ASM_POWER_LIMIT = 11  LARGE_POOL_SIZE = 4M   ASM_DISKGROUPS = DG1， DG2  DB_UNIQUE_NAME = +ASM   You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）

    • A、 only the INSTANCE_TYPE initialization parameter is set to an invalid value
    • B、 only the ASM_POWER_LIMIT initialization parameter is set to an invalid value
    • C、 only the LARGE_POOL_SIZE initialization parameter is set to an invalid value
    • D、 both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values

    正确答案:D

  • 第17题：

    单选题
    In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level.  You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated.  How do you achieve this objective？（）
    A

    by setting the SQL_TRACE parameter to FALSE in the parameter file

    B

    by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session

    C

    by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session

    D

    by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session


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

  • 第18题：

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


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

  • 第19题：

    单选题
    In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB  DB_CACHE_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  STATISTICS_LEVEL = BASIC  PGA_AGGREGATE_TARGET = 0  You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）
    A

    The STATISTICS_LEVEL initialization parameter is set to BASIC

    B

    The PGA_AGGREGATE_TARGET initialization parameter is set to zero.

    C

    The SGA_MAX_SIZE initialization parameter is set to less than 20 GB

    D

    The DB_CACHE_SIZE initialization parameter is set to less than 5 GB

    E

    The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.


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

  • 第20题：

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

  • 第21题：

    单选题
    You work as a database administrator for Supportcenter.cn. 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
    解析： 暂无解析

  • 第22题：

    单选题
    You have the following requirements in relation to the detection of block corruption for your database instance：   Check for logical self-consistency of data blocks when modified in memory.  Checksums are calculated before and after the block change.  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


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

  • 第23题：

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

  • 第24题：

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


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

相关内容