单选题You need to display a very large single-record data block. Since it will be so large, a convenient means of navigation is needed between items. Which type of canvas would you use to display the data block? （）A Tab canvas. B Pop up canvas. C Spread tabl

第1题：

The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the found code entered. The values needed to generate this summary data are stored in multiple tables. Which data source type can you assign to the data block for this form without having the DBA create a database object?（）

• A、database table 
• B、transactional trigger 
• C、stored procedure 
• D、FROM clause query 
• E、client-side procedure

第2题：

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？（）

• A、 V$BACKUP_CORRUPTION
• B、 V$COPY_CORRUPTION
• C、 V$DATABASE_BLOCK_CORRUPTION
• D、 RC_BACKUP_CORRUPTION

第3题：

第4题：

You need to change the text of a pop-up menu that appears when a user right clicks the mouse in the EMP_DATA data block. Where could you find the node for the pop-up menu in the Object Navigator?（）

• A、Built-in Packages 
• B、Menus 
• C、PL/SQL Libraries 
• D、Object Libraries 
• E、Form Module

第5题：

You need to allow the user to toggle between automatic query and no automatic query using a pop-up menu. Which built-in would you use in the menu item command to obtain the relationship name? （）

• A、GET_RELATION_PROPERTY 
• B、SET_RELATION_PROPERTY 
• C、GET_BLOCK_PROPERTY 
• D、GET_FORM_PROPERTY

第6题：

You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database.  Which is the most effective method to access this data in your database（）

• A、Use the database link.
• B、Use the SQL*Loader utility.
• C、Use the Oracle Data Pump utility.
• D、Create an external table and leave the data in the flat file

第7题：

You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）

• A、Upgrade the hardware/memory to accommodate the data.
• B、Load the data into your database by using the PARALLEL clause.
• C、Give analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLES.
• D、Use an external table so you can have the metadata available in your database， but leave the data in the operating system files.

第8题：

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.

第9题：

You need to display a very large single-record data block. Since it will be so large, a convenient means of navigation is needed between items. Which type of canvas would you use to display the data block? （）

• A、Tab canvas. 
• B、Pop up canvas. 
• C、Spread table canvas. 
• D、Vertical toolbar canvas.

第10题：

You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）

• A、— quick
• B、— skip-buffer
• C、— single-transaction
• D、— tab