Q1.In oracle forms, Which of the following is used to get the item property at run time?
a)GET_ITEM_PROPERTY()
b)GET_PROPERTY()
c)GET_PROPERTY_ITEM()
d)None
ANS: A
Q2.When the user navigates from one record to another record in a block, which trigger can be fired among the given options?
a)WHEN-NEW-FORM-INSTANCE
b)WHEN-NEW-RECORD-INSTANCE
c)PRE-FORM
d)WHEN-NEW-BLOCK-INSTANCE
ANS: B
Q3.Which of the following is considered as the advantage of property class in Oracle forms?
a)lf one or more properties of the data entry field require change, a
property class enables at the other data entry fields on the form to map
to this change.
b)lf each property is individually set, then it will be tedious to
maintain the standards in the form. A property class helps to avoid this.
c)To help maintain consistency in the form. Oracle forms builder provides
a solution of property class.
d)All
ANS: D
Q4.which of the following is used to capture the type of error?
a ERROR_TYPE
bJERRORNAME
c)ERROR_CATEGORY
d)None
ANS: A
Q5.which of the following is used to valid value returned by SHOW_ALERT() builtin?
a)0
b)1
c)2
d)alert_button1
ANS: D
Q6.In oracle forms, Which of the following triggers is used to trap the check box events when the selection is changed?
aWHEN-CHECKBOX-CHANGED
bWHEN-BUTTON-CHANGED
cWHEN-CHECK-CHANGED
d)WHEN-CHECK-BOX-CHANGED
ANS: WHEN-CHECKBOX-CHANGED (a)
Q7.Which of the following property cannot be set using Visual Attribute of Oracle Forms?
a)Menu Module
b)Font Style
c)Font size
d)Foreground Color
ANS: A
Q8.What is the default canvas in forms?
a)Content Canvas
bStacked Canvas
c)Horizontal Canvas
d)Tab Canvas
ANS: A
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
bWHEN-BUTTON-CHANGED
c)WHEN-RADIO-MOVED
d)WHEN-RADIO-BUTTON-CHANGED
ANS: A
Q10.Which of the following is not an object of a form module? Choose most appropriate option.
a)Visual Attributes
b)Property Classes
c)Triggers
d)Menus
ANS: D
Q11.In the Master-Detail form, when the user queries for the records in the master block and starts moving through them, Which of the following options can occur in the detail block? Choose the most appropriate option.
a)The detail records can get displayed automatically after the master
record is displayed.
b)The detail records can be displayed only when the cursor is positioned
on the detail block.
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 used to capture the error code in oracle forms?
a ERROR_TYPE
b)ERROR_cODE
c)ERROR_NAME
d)None
ANS: B
Q13.In Master detail block, Which of the following property specifies how the deletion of the record when the master block should affect the detail block.
a)Delete record behaviour
b)Remove record behaviour
c)Delete Row behaviour
d)Delete Record
ANS: A
Q14.Ajay Created a Master Detail Form.
MasterBlock:Custommer
DetailBlock:Transaction
When he query Customer block he needs all transactions for that customer need to be automatically appear in detail block.
What are the valid Relations properties need to be set to meet this requirement.
ANS: )Deferred: No Automatic Query: Yes/No
Q15.Which of the following is the valid value for SWITCH MENU argument of open_form builtin?
a)DO_REPLACE
b)REPLACE
c)DO_REMOVE
d)DO_SWITCH
ANS: )Deferred: No Automatic Query: Yes/No
Q16.ldentify the appropriate trigger that should be created to check that a primary key value is unique immediately after it is entered by the
operator.
Choose the most appropriate option.
a)WHEN-VALIDATE-ITEM trigger that issues a SELECT statement to check if
the value already exists in the block’s datasource.
bWHEN-NEW-ITEM-INSTANCE trigger that issues a SELECT statement to check
if the value already exists in the block’s datasource.
c)POST-TEXT-ITEM trigger that issues a SELECT statement to check if the
value already exists in the block’s datasource.
d)None
ANS: A
Q17.If user wants to peform 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)NO_QUERY_ONLY
c)QUERY_WRITE
d)None
ANS: B
Q18.Raman created Patient details form. He wants to autogenerate Patient_Id for every new patient record? Which of the following is
appropriate trigger to achieve this requirement?
a)When-new-record-instance
b)post-item
c)When-validate-item
d)Post-record
ANS: A
Q19.Which of the following options is used to save the form data?
a)Commit_Form;
b)Clear_Form(DO_COMMIT);
cclear_form(Ask_commit);
d)All
ANS: D
Q20.There are two forms FORM1 FORM2
Each of these forms needs to have menu module MENU1 attached.
Which of the following property of FORM1 and FORM2 needs to be given with
MENU1 location?
a)Menu Module
b)Module
c)Module Menu
d)All of the above
ANS: B
Q21.Which of the following is a collection of program units that includes
procedures,functions and packages independent of the form module.
a)PL/SQL Library
b)Object Library
cCollections
d)All
ANS: A
Q22.Which of the following builtin is used to move from one block to another block in oracle forms?
a)Go_BLOCK)
b)MOVE_BLOCK()
c)NAVIGATE_BLOCK()
d)None
ANS: A
Q23.Theresa created a form to search for existing employees details. However she is able to add new employees and able to modify existing details also, which should be restricted. Select the appropriate option to achieve this requirement?
a set insert allowed to yes,update allowed to yes. Query Allowed Yes in
the property palette of in the Emp Datablock.
bset insert allowed to no,update allowed to no. Query Allowed Yes in the
property palette of in the Emp Datablock.
cset insert allowed to no,update allowed to yes. Query Allowed Yes in
the property palette of in the Emp Datablock.
d)set insert allowed to yes,update allowed to no. Query Allowed Yes in
the property palette of in the Emp Datablock.
ANS: B
Q24.Which one of these options can be used to raise an error in a form
module?
Choose most appropriate option.
ANS: RAISE FORM_TRIGGER_FAILURE
Q25.Laxman created Products form. When he runs the form he is able to query the existing products and modify them. However he was not able to
add a new product and getting an error as ‘Cannot perform this operation’. What might be
the reason?
a)Update Allowed is set to ‘yes’ Query Allowed is set to ‘yes’ and insert
allowed is set to ‘yes’
b]Update Allowed is set to ‘yes’ Query Allowed is set to ‘no’ and insert
allowed is set to ‘yes’.
c)Update Allowed is set to ‘yes’ Query Allowed is set to ‘yes’ and insert
allowed is set to ‘no’.
d)Update Allowed is set to ‘no’ Query Allowed is set to ‘yes’ and insert
allowed is set to ‘no’.
ANS: C
[…] « Previous Next » […]