1.
The accounting manager wants you to create a form that when queried will display a calculated total of year to date actual expenditure for the fund code entered. The values needed to generate this summary data are store in multiple tables. How would you define the data source for this data block without having the DBA create a database object?
2.
You need to know the name of the master block driving the current block co-ordination for use in an On-Clear- Details trigger. Which system variable can you use to obtain this information?
3.
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 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?
4.
You need to return a table of record displaying the account numbers of all the uses customers but null for the account number of other customers. Which data source would you use to create the data block?
5.
You created a global record group in the order entry application. This record group should pass values to reports allowing a user to print a customer receipt. Which built-in could you use to pass the record group to another Oracle product?
6.
The next button on the Sales form will be used to invoke the ORD_ENTRY form. When the ord_entry form is invoked the data on both forms needs to be synchronized. Which built-in should you use to invoke the form in a modal window?
7.
The DBA has indicated that lock contention is occurring in the payroll application. To reduce contention you create a timer that will display an alert prompting the user to commit a rollback data after they have held a lock for a specified period of time. Which built-in could you use in a When-Timer-Expired trigger to implement this functionality?
8.
You need to change the text of popup menu that appears when a user right clicks the mouse in the EMP_DATA block. Where could you find the node for the popup menu in the object navigator?
9.
What is the first step you would take to attack a custom menu module to a form module?
10.
You are modifying the order entry application and want to disable all function keys that have not been explicitly defined. Which trigger can you define to accomplish this?