搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）

A、 The Oracle database will not perform block checking for any of the data blocks.

B、 The Oracle database will perform block checking for the default permanent tablespace only. 

C、 The Oracle database will perform block checking for the data blocks in all user tablespaces.

D、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.

E、 The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.

查看正确答案
更多“The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）”相关的问题
第1题
[单选题] The database has the data block size set to 8 KB. You need to import a tablespace with a 4 KB block size into the database. Which additional memory parameter（s） should be configured to perform a transportable tablespace import？（）

A、 DB_4K_CACHE_SIZE only  B、 DB_8K_CACHE_SIZE only  C、 DB_BLOCK_SIZE and DB_4K_CACHE_SIZE  D、 DB_BLOCK_SIZE and DB_8K_CACHE_SIZE  E、 SGA_TARGET and DB_4K_CACHE_SIZE  F、 DB_CACHE_SIZE only  

点击查看答案
第2题
[单选题] You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file：  DB_BLOCK_CHECKING = TRUE；  What will be the result of setting this parameter？（）

A、 Only data blocks of the SYSTEM tablespace will be checked.  B、 Only data blocks of the SYSAUX tablespace will be checked.  C、 A checksum will occur only on the checkpoint.  D、 A checksum will occur every time a block is modified.  

点击查看答案
第3题
[单选题] The DB_BLOCK_CHECKING initialization parameter is set to OFF. 数据库块检测初始化参数被设定为关  Which block checking would be performed?（）

A、The Oracle database will perform block checking for the index blocks only   B、The Oracle database will not perform block checking for any of the data blocks   C、The Oracle database will perform block checking for the default permanent tablespace only   D、The Oracle database will perform block checking for the data blocks in all user tablespaces   E、The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only Oracle  

点击查看答案
第4题
[] The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（）  

A、A. The Oracle database will perform block checking for the index blocks only  B、B. The Oracle database will not perform block checking for any of the data blocks  C、C. The Oracle database will perform block checking for the default permanent tablespace only  D、D. The Oracle database will perform block checking for the data blocks in all user tablespaces  E、E. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only  

点击查看答案
第5题
[单选题] You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）

A、by using the ANALYZE utility  B、by using the DBVERIFY utility  C、by using the DB_BLOCK_CHECKING parameter  D、by using the DBMS_REPAIR package  

点击查看答案
第6题
[单选题] You have executed this command to change the size of the database buffer cache： SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered. To verify the change in size， you executed this command：SQL> SHOW PARAMETER DB_CACHE_SIZENAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 Why is the value set to 4194304 and not to 2516582（）

A、Because 4194304 is the granule size  B、Because 4194304 is the standard block size  C、Because 4194304 is the largest nonstandard block size defined in the database  D、Because 4194304 is the total size of data already available in the database buffer cache  

点击查看答案
第7题
[单选题] You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）

A、 One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.  B、 One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.  C、 One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.  D、 One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.  

点击查看答案
第8题
[单选题] Your database block size is 4 KB. In this database， you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace？（）

A、 The parameter DB_CACHE_SIZE must be a multiple of 8.  B、 The value of the parameter SGA_MAX_SIZE must be increased.  C、 The tablespace must be created with a uniform extent size of 8 KB  D、 The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.  

点击查看答案
第9题
[单选题] In the COURSE_ENROLLMENT form module, you define a master-detail relation between the COURSES_OFFERED data block and the STUDENT data block, respectively. To implement block coordination, which statement must be true?（）

A、 The Enforce Primary Key property on the STUDENT block is set to Yes.   B、 The Alias property on the COURSES_OFFERED block is set to Student.   C、 The Copy Value from item property on the foreign key item in the STUDENT blocks is set to the primary key item of the COURSES_OFFERED block.   D、 The Synchronize with item property on the foreign key item in the STUDENT block is set to the primary key item of the COURSES_OFFERED block.  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服