单选题The DB_BLOCK_CHECKINGinitialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）AThe Oracle database will check all data blocks by going through the 

题目
单选题
The DB_BLOCK_CHECKINGinitialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）
A

 The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.

B

 The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.

C

 The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.

D

 The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.

E

 The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent.

相似考题

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.Which statement about Automatic Memory Management with Oracle 11g is true?()A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.B. Oracle can reallocate memory between the SGA and PGA automatically as needed.C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.

3.Automatic data conversion will occur if which of the following happens?()A. The client and server have different NLS_LANGUAGE settings.B. The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.C. The client and server are in different time zones.D. The client requests automatic data conversion.E. The AUTO_CONVERT initialization parameter is set to TRUE.

4.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

更多“The DB_BLOCK_CHECKINGinitialization parameter is set to TRUE”相关问题

  • 第1题：

    Automatic data conversion will occur if which of the following happens？（）

    • A、 The client and server have different NLS_LANGUAGE settings
    • B、 The client and server character sets are not the same，and the database character set is not a strict superset of the client character set
    • C、 The client and server are in different time zones
    • D、 The client requests automatic data conversion
    • E、 The AUTO_CONVERT initialization parameter is set to TRUE

    正确答案:B

  • 第2题：

    Given： String value = getServletContext（）.getInitParameter（"foo"）； in an HttpServlet and a web applicationdeployment descriptor that contains： foo frodo Which two are true？（）

    • A、The foo initialization parameter CANNOT be set programmatically.
    • B、Compilation fails because getInitParameter returns type Object.
    • C、The foo initialization parameter is NOT a servlet initialization parameter.
    • D、Compilation fails because ServletContext does NOT have a getInitParameter method.
    • E、The foo parameter must be defined within the  element of the deployment descriptor.

    正确答案:A,C

  • 第3题：

    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

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

    Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST？（）   The default value is the value of the environment variable $ORACLE_HOME； if $ORACLE_HOME isn’t set  

    • A、 then the default is set to $ORACLE_BASE  The default value is the value of the environment variable $ORACLE_BASE； if $ORACLE_BASE isn’t set，
    • B、 then it is set to $ORACLE_HOME
    • C、 DIAGNOSTIC_DEST is always equal to $ORACLE_HOME
    • D、 DIAGNOSTIC_DEST is always equal to $ORACLE_BASE

    正确答案:B

  • 第6题：

    单选题
    You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）
    A

    to enable operating system authentication for a remote client

    B

    to restrict the scope of administration to identical operating systems

    C

    to allow the start up and shut down of the database from a remote client

    D

    to enable the administration of the operating system from a remote client

    E

    to disable the administration of the operating system from a remote client


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

  • 第7题：

    单选题
    Automatic data conversion will occur if which of the following happens？（）
    A

     The client and server have different NLS_LANGUAGE settings

    B

     The client and server character sets are not the same，and the database character set is not a strict superset of the client character set

    C

     The client and server are in different time zones

    D

     The client requests automatic data conversion

    E

     The AUTO_CONVERT initialization parameter is set to TRUE


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

  • 第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 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
    解析： 暂无解析

  • 第10题：

    多选题
    Which two statements are true regarding undo tablespaces（）
    A

    The database can have more than one undo tablespace.

    B

    The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.

    C

    Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.

    D

    An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.


    正确答案： C,B
    解析： A答案：可以有一个或多个undo表空间，A答案正确。 
    sys@TEST0924> select TABLESPACE_NAME，CONTENTS from dba_tablespaces； TABLESPACE_NAME CONTENTS ------------------------------ --------- SYSTEM PERMANENT SYSAUX PERMANENT UNDOTBS1 UNDO TEMP TEMPORARY USERS PERMANENT UNDOTBS2 UNDO 
    EXAMPLE PERMANENT LXTBS PERMANENT FLA_TBS1 PERMANENT FLA_TBS2 PERMANENT 10 rows selected. 
    B答案：UNDO_TABLESPACE只能用于自动undo段模式，B答案错误

  • 第11题：

    多选题
    You set the following parameters in the parameter file and restarted the database：MEMORY_MAX_TARGET=0MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90MSGA_TARGET=270M Which two statements are true about these parameters after the database instance is restarted（）
    A

    The MEMORY_MAX_TARGET parameter is automatically set to 500 mb.

    B

    The pga_AGGREGATE_TARGET and sga_TARGET parameters are automatically set to zero.

    C

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

    D

    The lower bounds of pga_AGGREGATE_TARGET and sga_TARGET parameters are set to 90 nb and270 mb， respectively


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

  • 第12题：

    多选题
    Given： String value = getServletContext（）.getInitParameter（"foo"）； in an HttpServlet and a web applicationdeployment descriptor that contains： foo frodo Which two are true？（）
    A

    The foo initialization parameter CANNOT be set programmatically.

    B

    Compilation fails because getInitParameter returns type Object.

    C

    The foo initialization parameter is NOT a servlet initialization parameter.

    D

    Compilation fails because ServletContext does NOT have a getInitParameter method.

    E

    The foo parameter must be defined within the  element of the deployment descriptor.


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

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

    Which two statements are true regarding undo tablespaces（）

    • A、The database can have more than one undo tablespace.
    • B、The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.
    • C、Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.
    • D、An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.

    正确答案:A,C

  • 第15题：

    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

  • 第16题：

    You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）

    • A、to enable operating system authentication for a remote client
    • B、to restrict the scope of administration to identical operating systems
    • C、to allow the start up and shut down of the database from a remote client
    • D、to enable the administration of the operating system from a remote client
    • E、to disable the administration of the operating system from a remote client

    正确答案:A

  • 第17题：

    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

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

    单选题
    From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）
    A

     set the CPU time per call in the users profile

    B

     set the CPU time per session in the users profiles

    C

     set the TIMED_STATISTICS parameter to TRUE in the parameter file

    D

     set the CPU levels for the users’ group using Resource Manager


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

  • 第21题：

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

  • 第22题：

    单选题
    Which statement about Automatic Memory Management with Oracle 11g is true？（）
    A

     You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or  PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.

    B

     Oracle can reallocate memory between the SGA and PGA automatically as needed.

    C

     To use Automatic Memory Management， you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.

    D

     You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.


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

  • 第23题：

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

  • 第24题：

    单选题
    Automatic data conversion will occur if which of the following happens?（）
    A

    The client and server have different NLS_LANGUAGE settings.

    B

    The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.

    C

    The client and server are in different time zones.

    D

    The client requests automatic data conversion.

    E

    The AUTO_CONVERT initialization parameter is set to TRUE.


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

相关内容