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?
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?
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?
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?
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?
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?
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?
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?
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?