Which statement about windows and blocks is true?()
第1题:
Which two statements are true about terms in a routing policy?()
第2题:
Which statements are true regarding a tablespace()
第3题:
Which statement is true regarding the VALIDATE DATABASE command?()
第4题:
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?()
第5题:
Which two statements are true about Block Media Recovery (BMR)?()
第6题:
Which two statements are true regarding a tablespace()
第7题:
Transaction management is block-oriented rather than window-oriented.
Forms automatically navigates to an item located in an activated window.
A window may contain multiple blocks, but each block can only span one window.
A window can contain multiple canvases, and an item can be located on multiple canvases.
第8题:
The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.
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.
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.
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.
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.
第9题:
A routing policy cannot have more than one term.
If a term does not contain a from statement, all routes match.
If a term does not contain a from statement, the Junos OS will not commit.
A then statement is not mandatory in a term.
第10题:
The backup will consist of used data blocks only.
The database must be shut down to accomplish the backup.
The backup can be accomplished without shutting down the database.
The backup will contain all database files that have never been backed up.
第11题:
The Enforce Primary Key property on the STUDENT block is set to Yes.
The Alias property on the COURSES_OFFERED block is set to Student.
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.
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.
第12题:
The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.
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.
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.
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.
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
第13题:
You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup?()
第14题:
Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode()
第15题:
Which three scenarios describe appropriate uses for key triggers?()
第16题:
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()
第17题:
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 ()
第18题:
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?()
第19题:
BMR increases the Mean Time To Recover (MTTR).
BMR can only be implemented using Recovery Manager (RMAN).
The blocks that need to be recovered are accessible during BMR.
BMR cannot be performed using cumulative incremental backups.
The datafile must be restored if most of the blocks in the datafile are corrupt.
第20题:
It can span multiple databases.
It can consist of multiple data files.
It can contain blocks of different sizes.
It can contain segments of different sizes.
It can contain a part of a nonpartitioned segment
第21题:
The database automatically determines the extent-sizing policy for the tablespace.
The segments are automatically shrunk when the contents are removed from them.
The allocation of extents within the tablespace is managed through the dictionary tables.
The space utilization description of the data blocks in segments is recorded in bitmap blocks.
The space utilization description of the data blocks in segments is managed through free lists.
第22题:
It can span multiple databases.
It can consist of multiple data files.
It can contain blocks of different sizes.
It can contain segments of different sizes.
It can contain a part of a nonpartitioned segment.
第23题:
Alter data in a database table.
Add custom item validation code.
Disable the Next Block key and menu item.
Display a custom form in place of a List of Values.
Change the navigational order of the blocks in a form.
Perform a complex calculation each time the F10 key is pressed.