单选题You are creating a sales data template and need to add a picture to the margin. What is the best way to add this margin?（）A Choose the margin code in the object navigator and select file-import-image. B Choose the margin node in the object navigator an

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

The CALC function is used several times within the sales report. To simplify maintenance you want to store the function in one place and call it from within your PL/SQL trigger code. Which node would you use in object navigator to create a report level programme unit to store the function?（）

• A、Programme units. 
• B、PL/SQL libraries. 
• C、Database object. 
• D、Built in packages.

第3题：

第4题：

You are creating a sales data template and need to add a picture to the margin. What is the best way to add this margin?（）

• A、Choose the margin code in the object navigator and select file->import->image. 
• B、Choose the margin node in the object navigator and use the tool bar button. 
• C、Click the margin button in the layout model and select file->import->image. 
• D、Click the margin button in the layout model and use the tool bar button.

第5题：

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. 

第6题：

What is added to the MS sensitivity level to obtain the required signal strength, SSreq?（）

• A、Rayleigh fading margin.
• B、Rayleigh fading margin, interference margin, and body loss.
• C、Rayleigh fading margin and interference margin.
• D、Rayleigh fading margin and body loss.
• E、Interference margin and body loss.

第7题：

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 fund code entered. The value needed to generate this summary data are stored in multiple tables. How would you define the data source for this data block without having the DBA create a database object? （）

• A、Choose Tools -> Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. 
• B、Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
• C、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Source Arguments properties to enter the SELECT statement. 
• 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 'Table', and enter the SELECT statement in the Query Data Source Name property. 
• E、Choose Tools -> Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. 
• F、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 to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property.

第8题：

第9题：

A sales analyst reviews the first draft on your Sales application, and requests that the application graphically represent revenue generated for each sales representative, in addition to the textual data currently displayed for the ORDER block. How would you incorporate this graphic in your form? （）

• A、Invoke the Chart Wizard and create a chart based on the ORDER block. 
• B、Create a chart using Graphics Builder and then select File Import Chart in Form Builder, positioning the new chart with the text items in the ORDER block. 
• C、Invoke the Data Block Wizard in reentrant mode, select the Charts tab, and specify the chart type and column sources for the X and Y axes. 
• D、Select the Chart node in the Object Navigator, Click the Create icon, and specify the details of the chart in the chart's Property Palette.

第10题：

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