The DB_BLOCK_CHECKINGinitialization parameter is set to TRUE

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

参考答案和解析
正确答案: C
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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

第2题:

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

第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 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

第5题:

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

第6题:

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

第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 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

第9题:

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

第10题:

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

更多相关问题