Hello friends if you are looking for Oracle PL SQL Multiple Choice Questions| Oracle PL SQL Objective Type Questions| Oracle PL SQL Accenture Test With Answers| Oracle PL SQL MCQ with Answers
Q1. How many datablocks are available in Oracle Forms?
Ans – 1
Q2. Which of the following options can be choosed to save the form data?
A. Clear_form(DO_COMMIT);
B. Clear Form(Ask_Commit)
C. All
D. Commit_form;
Ans: c
Q3. Ramesh has created a form in which data block is created using wizard. Which of the following builtin and trigger combination should be used to load the data into the form, when the form loads?
A. WHEN NEW_FORM_INSTANCE, QUERY_EXECUTE
B. EXECUTE_QUERY, WHEN-NEW-FORM-INSTANCE
C. LOAD DATA, WHEN-NEW-FORM-INSTANCE
D. none of the above
Ans: a
Q4. The requirement is to ensure that the fields are loaded with data when the form opens up. Which trigger can be used for this requirement?
A. WHEN-VALIDATE-FORM
B. POST-FORM
C. PRE-LOGON
D. PRE-FORM
Ans: d
Q5. Which one of these options can be used to raise an error in a form module?
A. raise_application_error
B.raise exception name;
C.raise form_trigger_failure
D.pragma exception init
Ans: c
Q6. While inserting a radio button in form _____ no of radio buttons can be assigned to a radio group
A. Four
B. None of the Above
C. Unlimited
D Ten
Ans: c
Q7. Which of the following operation(s) can be done with the “When-Button-Pressed” Trigger?
A. Form and Block Navigation
B. Invoking calculations
C. All of the above
D. Saving the form data
Ans: c
Q8. Which of the following function is used to create a record group?
A. CREATE_QUERY_FROM_GROUP()
B. CREATE_GROUP_FROM_QUERY()
C. CREATE_GROUP_QUERY()
D. CREATE_QUERY()
Ans: b
Q9. In oracle forms, Which of the following trigger is used to trap the radio button events when the selection is changed?
A. WHEN-RADIO-CHANGED
B. WHEN-RADIO-BUTTON-CHANGED
C. WHEN-BUTTON-CHANGED
D. WHEN-RADIO-MOVED
Ans: a
Q10. In Master Detail block, which of the following value has to be set to ‘DELETE RECORD BEHAVIOR’ so that Master record cannot be deleted if associated Detail records exist in the database
A. Non-Isolated
B. All
C. Isolated
D. Cascading
Ans: b
Q11. In a Master-Detail form, when the user queries for the records in the master block and starts moving through them, which of the most lowing options can occur in the detail block?
A. The detail records can get displayed immediately after the master record is displayed
B. The detail records can be displayed only when the cursor is positioned on the detail t
C. The detail records can be displayed after the user queries for them in the detail block
D. All of the above
Ans: d
Q12. Which of the following is considered as an advantage of Property Class in Oracle forms?
A. If one or more properties of the data entry field require change, a property class enables the other data entry fields on the form to map to this change.
B. To help maintain consistency in the form, Oracle Forms Builder Property class rovides a solution of
C. If each property is individually set, then it will be tedious to maintain the standards in the form. A property class helps to avoid this.
D. All
Ans: d
Q13. Which of the following form objects can be included in.Object library?
A. Alerts
B. Canvases
C. Al
D. Blocks
Ans: b
Q14. An alert can have a maximum 5 buttons. State TRUE or FALSE.
Ans – False
Q15. What one of the following form builder module will have pll extension?
A. Program Library List
B. Programing List Library
C. PL/SQL Library Module Binary
D. Primary Library List
Ans: c
Q16. Which of the following builtin is used to invoke an alert in Oracle Forms?
A. SHOW_ALERT()
B. INVOKE ALERT()
C. LOAD_ALERT()
D. CALL ALERT()
Ans: a
Q17. Steve is working as a Form Developer. He starts designing a form to meet the requirements. Which is the default canvas for the form?
A. Content Canvas
B. Horizontal Canvas
C. Tab Canvas
D. Stacked Canvas
Ans: a
Q18. Which of the following is a valid menu item type in Oracle forms?
A. Magic
B. Check
C. All
D. Plain
Ans: c
Q20. If user wants to perform DML operations through a called form, in form to form navigation. Which of the following value has to be assigned to Query Mode property?
A. QUERY ONLY
B. QUERY WRITE
C. NO_QUERY ONLY
D. None
Ans: c