Oracle-Build Internet Applications II Set 1

You created a custom menu for the Order Entry application. Which step do you perform before attaching the menu module to the form module?

You want to create a pie-style chart using the Chart Wizard. What must be you do to determine the fields available for use in this chart?

You need to return a table of records that displays the account numbers of all user's customers, but displays NULL for the account number of other customers. Which type of data source would you use to create the data block?

The system analysts have requested heavy use of object features. The database design makes use of PL/ SQL8 object types, methods, and LOB types. How do you work with these features on the client?

You CUSTOMERS module has a When-Button-Pressed trigger with this code: OPEN FORM('stock', no_activate); The STOCK module contains a When-New-Form-Instance trigger. Which statement is true when you press the button in the CUSTOMERS module?

You are building two forms. Each form has a button and a non-base table field. When the button is pressed, a complicated calculation is executed. The calculation is the same for both forms. The calculation code does not query or change the data in the database. When the calculation completes, it returns a single value to the non- base table field. To optimize performance and maintainability, which PL/SQL structure should be used?

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?

You want to implement a master-detail relation between data blocks based on object tables. How would you do this?

You established access to menu modules using roles. You have allowed the sales role to access the menu module, but prevented access to the Update menu item. Which item property would you alter to gray out the menu option for the role?

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?