Oracle Forms Development
Test your knowledge of Oracle Forms development, including triggers, built-ins, canvas types, alerts, validation, and system properties.
Questions
Can :SYSTEM.CURRENT_BLOCK value be changed ?
- True
- False
What is the default level at which validation occurs in the Forms Runtime program?
- Item
- Form
- Block
- Record
You have created an alert with three buttons. What value will be returned if the user selects the second button?
- BUTTON2
- DIALOG_BUTTON2
- ALERT_BUTTON2
- It depends on the choice being offered by the button.
What is the purpose of the KEY-OTHERS trigger?
- Provides code to execute if a key's own trigger fails
- Provides code to execute if user presses a key that has no trigger attached
- Provides code to execute if user presses wrong key
- Provides code that accesses another key's trigger and executes the code it contains
Which built-in causes an LOV to display for a text item that has one defined?
- WHEN-NEW-ITEM-INSTANCE
- WHEN-NEW-LOV
- GO_ITEM
- SHOW_LOV
Which canvas type is most dissimilar to the others?
- Content
- Stacked
- Tab
- Toolbar
What is the primary difference between tab and stacked canvases?
- A stacked canvas can contain push buttons.
- A stacked canvas obscures what is beneath it.
- A tab canvas can contain multiple pages.
- A tab canvas looks much cooler.
You would like to create a trigger that fires each time a window is closed by the user. You will most likely place the trigger at which of the following levels:
- Canvas level
- Window level
- Data block level
- Item level
- Form level
Which of these built-ins can you use in a PRE-UPDATE trigger?
- DOWN
- COMMIT_FORM
- No Answer is Correct.
- All Answers are Correct.
- GO_ITEM
You would like to keep the user from seeing the Forms Runtime program's "nn records applied and saved" messages. What would you put in the form's WHEN-NEW-FORM-INSTANCE trigger?
- :system.message_level := 0;
- :system.suppress_working := 'TRUE';
- :system.suppress_working := 'FALSE';
- :system.message_level := 5;
You want to add a delete-confirmation dialog to your application. You can do so by creating which type of object?
- Alert
- Message
- Editor
- Message Box
You would like to modify your form so it uses array processing to send DML statements to the server in batches of 50. How would you do this?
- Set the canvas's DML Array Size property to 50.
- Set the data block's DML Array Size property to 50.
- Set the window's DML Array Size property to 50.
- Array processing is limited to 25 records per batch.
Your form module's Validation Unit property is set to Form. The module includes a data block that has a PRE-TEXT-ITEM trigger. At what point will the trigger fire?
- Never
- When data is committed
- Before the form is validated
- After the form is validated
You wish to have certain values in a form initialized when the form is first opened. What trigger will you use?
- WHEN-NEW-CANVAS-INSTANCE
- WHEN-NEW-FORM-INSTANCE
- WHEN-NEW-FORM
- WHEN-FORM-OPENED
- WHEN-NEW-CANVAS
The default value the lpad function takes is
- a space
- an asterisk
- The default value is not optional
- None of the above
Which of the following is true about add_months
- we can pass a numerical value in first parameter
- we can pass a negative value in second parameter
- Both a & b
- None of the above
What does OFA stands for ?
- Oracle Flexible Architecture
- Oracle Financials Applications
- Optimal Flexible Architecture
- None of the above
Which of the following is true for delete?
- Delete statement can be given without writing where clause.
- We can delete two tables simultaneously
- Both a & b
- None of the above
How do you rename a table ?
- alter table table_name rename to new_table_name;
- RENAME table_name new_table_name;
- Dropping the table and creating once again
- None of the above.