Tag: programming languages

Questions Related to programming languages

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?
technology programming languages

  1. :system.message_level := 0;

  2. :system.suppress_working := 'TRUE';

  3. :system.suppress_working := 'FALSE';

  4. :system.message_level := 5;

Show answer
Correct Option: D

You want to add a delete-confirmation dialog to your application. You can do so by creating which type of object?

technology programming languages

  1. Alert

  2. Message

  3. Editor

  4. Message Box

Show answer
Correct Option: A

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?
technology programming languages

  1. Set the canvas's DML Array Size property to 50.

  2. Set the data block's DML Array Size property to 50.

  3. Set the window's DML Array Size property to 50.

  4. Array processing is limited to 25 records per batch.

Show answer
Correct Option: B

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?
technology programming languages

  1. Never

  2. When data is committed

  3. Before the form is validated

  4. After the form is validated

Show answer
Correct Option: A

You wish to have certain values in a form initialized when the form is first opened. What trigger will you use?
technology programming languages

  1. WHEN-NEW-CANVAS-INSTANCE

  2. WHEN-NEW-FORM-INSTANCE

  3. WHEN-NEW-FORM

  4. WHEN-FORM-OPENED

  5. WHEN-NEW-CANVAS

Show answer
Correct Option: B

The default value the lpad function takes is
technology programming languages

  1. a space

  2. an asterisk

  3. The default value is not optional

  4. None of the above

Show answer
Correct Option: A

Which of the following is true about add_months
technology programming languages

  1. we can pass a numerical value in first parameter

  2. we can pass a negative value in second parameter

  3. Both a & b

  4. None of the above

Show answer
Correct Option: B

What does OFA stands for ?
technology programming languages

  1. Oracle Flexible Architecture

  2. Oracle Financials Applications

  3. Optimal Flexible Architecture

  4. None of the above

Show answer
Correct Option: C

Which of the following is true for delete?
technology programming languages

  1. Delete statement can be given without writing where clause.

  2. We can delete two tables simultaneously

  3. Both a & b

  4. None of the above

Show answer
Correct Option: A

How do you rename a table ?

technology programming languages

  1. alter table table_name rename to new_table_name;

  2. RENAME table_name new_table_name;

  3. Dropping the table and creating once again

  4. None of the above.

Show answer
Correct Option: A