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
What does OFA stands for ?
Oracle Flexible Architecture
Oracle Financials Applications
Optimal Flexible Architecture
Which of the following is true for delete?
Delete statement can be given without writing where clause.
We can delete two tables simultaneously
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.