单选题The EMP_DEPT block in your EMPLOYEE form is based on a view in an Oracle8 database. The items in this block have the Update Allowed property set to Yes. Which database feature makes it possible to permanently modify the underlying view?（）A REF cursor. 

第1题：

You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?（）

• A、Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. 
• B、Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
• C、Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. 
• D、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. 
• E、Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.

第2题：

You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）

• A、BFILE 
• B、REF column 
• C、Object table 
• D、Column object 
• E、INSTEAD-OF trigger

第3题：

he data blocks in your form module are based on object tables. How would you create a master-detail relationship between two of these blocks?（）

• A、Use the Data Block Wizard and base the relation on a REF pointer. 
• B、In the Object Navigator, select the Relation node under the master block and click the Create icon. Build the relation manually and coordinate the blocks using triggers.
• C、Use the Data Block Wizard, and base the relation on the primary key-foreign key relationship in the database. 
• D、This task is not possible because master-detail relations can be implemented only for blocks based on relational tables. 

第4题：

You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature.  What information will be written in the change tracking file？（）

• A、 the system change number
• B、 the locations of the redo log files
• C、 the locations of the datafiles
• D、 the physical location of all the database changes

第5题：

You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）

• A、 Create a backup of the database and recover all corrupted blocks found in the backup.
• B、 Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.
• C、 Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.
• D、 Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.
• E、 Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature？（）

• A、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING；
• B、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；
• C、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE ；
• D、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ；

第14题：

You create a data block based on a relational table containing a REF column. You select the REF column for your form module. What is true about the items based on the REF column attributes?（）

• A、The Query Only property is set to Yes. 
• B、The Conceal Data property is set to Yes. 
• C、The Insert Allowed property is set to Yes. 
• D、The Update Allowed property is set to Yes.

第15题：

The EMP_DEPT block in your EMPLOYEE form is based on a view in an Oracle8 database. The items in this block have the Update Allowed property set to Yes. Which database feature makes it possible to permanently modify the underlying view?（）

• A、REF cursor. 
• B、Instead Of trigger. 
• C、Stored procedure that returns object values. 
• D、The underlying view cannot be modified because DML on a view is not supported.

第16题：

You execute the following RMAN commands in the order shown below：  BACKUP VALIDATE DATABASE;  BLOCKRECOVER CORRUPTION LIST;  What will these commands do？（）

• A、create a backup of the database and recover all corrupted blocks found in the backup
• B、run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database
• C、run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view
• D、run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view
• E、run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired

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