0

programming languages Online Quiz - 335

Description: programming languages Online Quiz - 335
Number of Questions: 20
Created by:
Tags: programming languages
Attempted 0/20 Correct 0 Score 0

Can :SYSTEM.CURRENT_BLOCK value be changed ?

  1. True

  2. False


Correct Option: B

What is the default level at which validation occurs in the Forms Runtime program?

  1. Item

  2. Form

  3. Block

  4. Record


Correct Option: A

You have created an alert with three buttons. What value will be returned if the user selects the second button?

  1. BUTTON2

  2. DIALOG_BUTTON2

  3. ALERT_BUTTON2

  4. It depends on the choice being offered by the button.


Correct Option: C

What is the purpose of the KEY-OTHERS trigger?

  1. Provides code to execute if a key's own trigger fails

  2. Provides code to execute if user presses a key that has no trigger attached

  3. Provides code to execute if user presses wrong key

  4. Provides code that accesses another key's trigger and executes the code it contains


Correct Option: B

Which built-in causes an LOV to display for a text item that has one defined?

  1. WHEN-NEW-ITEM-INSTANCE

  2. WHEN-NEW-LOV

  3. GO_ITEM

  4. SHOW_LOV


Correct Option: D

What is the primary difference between tab and stacked canvases?

  1. A stacked canvas can contain push buttons.

  2. A stacked canvas obscures what is beneath it.

  3. A tab canvas can contain multiple pages.

  4. A tab canvas looks much cooler.


Correct Option: C

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:

  1. Canvas level

  2. Window level

  3. Data block level

  4. Item level

  5. Form level


Correct Option: E

Which of these built-ins can you use in a PRE-UPDATE trigger?

  1. DOWN

  2. COMMIT_FORM

  3. No Answer is Correct.

  4. All Answers are Correct.

  5. GO_ITEM


Correct Option: C

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?

  1. :system.message_level := 0;

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

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

  4. :system.message_level := 5;


Correct Option: D

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?

  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.


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?

  1. Never

  2. When data is committed

  3. Before the form is validated

  4. After the form is validated


Correct Option: A

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

  1. WHEN-NEW-CANVAS-INSTANCE

  2. WHEN-NEW-FORM-INSTANCE

  3. WHEN-NEW-FORM

  4. WHEN-FORM-OPENED

  5. WHEN-NEW-CANVAS


Correct Option: B

AI Explanation

To answer this question, you need to understand the different triggers available in Oracle Forms.

Option A) WHEN-NEW-CANVAS-INSTANCE - This trigger fires when a new instance of a canvas is displayed. It is not the appropriate trigger to use for initializing values in a form when it is first opened.

Option B) WHEN-NEW-FORM-INSTANCE - This trigger fires when a new instance of a form is created and displayed. It is the correct trigger to use for initializing values in a form when it is first opened.

Option C) WHEN-NEW-FORM - This trigger fires when a new form is entered or a form is reset. It is not the appropriate trigger to use for initializing values in a form when it is first opened.

Option D) WHEN-FORM-OPENED - There is no trigger called WHEN-FORM-OPENED in Oracle Forms.

Option E) WHEN-NEW-CANVAS - This trigger fires when a new canvas is displayed. It is not the appropriate trigger to use for initializing values in a form when it is first opened.

The correct answer is Option B) WHEN-NEW-FORM-INSTANCE. This trigger should be used to initialize values in a form when it is first opened.

The default value the lpad function takes is

  1. a space

  2. an asterisk

  3. The default value is not optional

  4. None of the above


Correct Option: A
  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


Correct Option: B

What does OFA stands for ?

  1. Oracle Flexible Architecture

  2. Oracle Financials Applications

  3. Optimal Flexible Architecture

  4. None of the above


Correct Option: C

Which of the following is true for delete?

  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


Correct Option: A

How do you rename a table ?

  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.


Correct Option: A

/var directory in Unix contain configuration details of the System

  1. True

  2. False


Correct Option: B
- Hide questions