单选题Which statement about windows and blocks is true?（）A Transaction management is block-oriented rather than window-oriented. B Forms automatically navigates to an item located in an activated window. C A window may contain multiple blocks, but each block

第1题：

Which statement about windows and blocks is true?（）

• A、Transaction management is block-oriented rather than window-oriented. 
• B、Forms automatically navigates to an item located in an activated window. 
• C、A window may contain multiple blocks, but each block can only span one window. 
• D、A window can contain multiple canvases, and an item can be located on multiple canvases. 

第2题：

Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）

• A、The backup will consist of used data blocks only.
• B、The database must be shut down to accomplish the backup.
• C、The backup can be accomplished without shutting down the database.
• D、The backup will contain all database files that have never been backed up.

第3题：

The DB_BLOCK_CHECKING initialization 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、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

第4题：

Which two statements are true about Block Media Recovery （BMR）？（）

• A、 BMR increases the Mean Time To Recover （MTTR）.
• B、 BMR can only be implemented using Recovery Manager （RMAN）.
• C、 The blocks that need to be recovered are accessible during BMR.
• D、 BMR cannot be performed using cumulative incremental backups.
• E、 The datafile must be restored if most of the blocks in the datafile are corrupt.

第5题：

Which two statements are true regarding a tablespace（）

• A、It can span multiple databases.
• B、It can consist of multiple data files.
• C、It can contain blocks of different sizes.
• D、It can contain segments of different sizes.
• E、It can contain a part of a nonpartitioned segment.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which  statements are true regarding a tablespace（）

• A、It can span multiple databases.
• B、It can consist of multiple data files.
• C、It can contain blocks of different sizes.
• D、It can contain segments of different sizes.
• E、It can contain a part of a nonpartitioned segment

第14题：

Which statement is true regarding the VALIDATE DATABASE command?（）

• A、It checks the database for intrablock corruptions only.
• B、It checks for block corruption in the valid backups of the database.
• C、It checks the database for both intrablock and interblock corruptions.
• D、It checks for only those corrupted blocks that are associated with data files.

第15题：

You executed the following command to create a tablespace called SALES_DATA： SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace（）

• A、The database automatically determines the extent-sizing policy for the tablespace.
• B、The segments are automatically shrunk when the contents are removed from them.
• C、The allocation of extents within the tablespace is managed through the dictionary tables.
• D、The space utilization description of the data blocks in segments is recorded in bitmap blocks.
• E、The space utilization description of the data blocks in segments is managed through free lists.

第16题：

You executed the following command to create a tablespace called SALES_DATA：  > CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO；  Which two statements are true about the SALES_DATA tablespace （）

• A、The database automatically determines the extent-sizing policy for the tablespace.
• B、The segments are automatically shrunk when the contents are removed from them.
• C、The allocation of extents within the tablespace is managed through the dictionary tables.
• D、The space utilization description of the data blocks in segments is recorded inbitmapblocks.
• E、The space utilization description of the data blocks in segments is managed through free lists.MANUAL

第17题：

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.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：