Oracle-Build Internet Applications I Set 1

You want to capture the username and password for the current user. Which built-insubprogram can you use?

You have created a LOV that displays the DEPT_ID and DEPT_NAME columns and returns a value only for the DEPT_ID column. Users want to select a department from the list of the DEPT_NAME columns only. How would you resolve this question?

When you create a radio group, you decide to leave the Mapping of Other Values property blank. Which statement is true?

Which built-in subprogram can be used to create global variables?

How would you convert an inherited property to a variant property?

Which built-in would you use to check whether a user selected a value from the PAY_Type_LOV?

Which built-in subprogram can you use to navigate to the instance of the current item in the previous record?

Which master detail property would you use to delete the master record, but prevent detail records from being deleted?

The items form contains the master detail relationship for inventory items and inventory stock available. Users may delete an inventory item if the QUANTITY_ON_HAND=0. Which commit trigger can you use to implement a cascade delete for the item?

You are creating the SAL_INFO data block on the EMP_QUERY form. The SALARY field should only be populated if the logged on. Since this query can return a large number of records. You have created a stored procedure, which uses a REF cursor on which to base the data block. How would you create the data block?