51.Which of the following library can store program units in oracle forms?
a)PL SQL Library
b)Object Library
c)object Navigator
d)Data Library
Ans: A
52.Ram wants to make TOTAL PRICE item to be non-editable in orders form
when the form applets loads. Select the appropriate trigger to achieve
the same.
alwhen-new-record-instance
b)when-new-item-instance
cwhen-validate-item
d)when-new-form-instance
Ans: D
53.Customer name is mandatory field in customer form, What are the
different ways to achieve this?
a)Go to property Palette of customer name and set required yes.
bwrite a code in when-validate-item of customer name to check whether
customer name is null.If null,raise a form error.
options
a)Only A is correct option
blonly B is correct option
c)Either A or B is suffice
d)Both A and B or needed
Ans: C
54.Choose the correct line of code to programatically set a visual
attribute named ‘VA_ERROR’ to item item1 present to block1?
Ans: SETITEM_PROPERTY(‘block1.item1′,current_record_attribute,’VA_ERROR’)
55.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?
awhen-validate-form
b)pre-form
c)pre-logon
d)post-form
Ans: B
56.Which of the following operations can be done with the ‘when-buttonpressed’ trigger?
a)Forms and Block Navigation
bjSaving the Form data
c)Invoking Calculations
d)All
Ans: D
57.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?
When-new-form-instance, EXECUTE_QUERY
58.which of the following trigger can be used to perform datablock level
validation?
when-new-block-instance
59.which of the following options can be used to raise an error in a form
module?
araise_application_error
brise trigger_form
craise form_trigger_failure
d)pragma exception init
Ans: C
60)Which of the following builtin is used to load an image in a image
item?
a)READ FILE()
b)READ IMAGE_FILE()
c)READ_IMAGE()
d)LOAD_IMAGE()
Ans: B
61)What are the different types of delete details we can have on master
detail forms?
ANS:-Non-Isolate,Cascade, Isolate
62)What are the different default triggers created when Master Deletes
Property is set to Cascade?
Master Deletes Property Resulting Triggers
a)Cascading On-Clear-Details
b)On-Populate-Details
c)Pre-delete
d) all
Ans: D
63)Which of the following contains the select statement associated with
LOV in oracle forms?
a)Record Group
b)Block Group
c)Object Group
d)PLSQL Library
Ans: A
64)Which of the valid canvas view?
aContent Canvas
b)Stacked Canvas
c)Horizontal Toolbar Canvas
d)All
Ans: D
65)The form builder launches a web browser and specifies the URL to run
the form. Inorder to run the form,there must be an
HTTP listener already started and goes by the name
a)Form Runtime Listener
b)OC4J HTTP Listener
c)Forms Listener
d)HTTP Listener
Ans: B
66)Which among the following can be classified as Navigational triggers?
ANS:-Pre-BLock, Post-Form,Post-Record etc.
67)while creating a master-detail form identify the trigger that will get
fired to check if the join column value in the master block is NULL or
not.
ANS:-ON_CHECK_DELETE_MASTER
68)Amit has placed two text items and a push button on the canvas. Pick
the triggers that get executed when he presses the tab key.
a)Post-text-item
bwhen-item-pressed
c)pre-text-item
d)key-next-item
Ans: A,C,D
69)The CUST_DEPT form has called the ORD_DET form for the user to enter
the order details for the customer. The CALL_FORM function has been used
to call
ORD_DET from CUST_DET. what is the feature of the CALL_FORM function?
ANS-When called form completes the operation, it releases lock and control goes back to the calling form.
70)Under which situations does the following error occur: No master
Blocks are available.
ANS:-If the foreign key is not defined at the block level.
71)Which of the following functions can be accomplished only with the use
of key triggers?
1.Changing function keys default functionalityY
2.Disabling function keys
72)Which of the following module of oracle forms builder a menu can be
attached in the property palette?
a)Form Module
b)PL/SQL cursor
c)Object Library
d)All
Ans: A
73)Which of the following is used to retrieve the name of the item that
caused the ON-ERROR trigger to fire?
ANS:-SYSTEM.TRIGGER_ITEM
74) In Master Detail Block, Which of the following value has to be set to
‘DELETE RECORD BEHAVIOUR’ so that a Master record can be deleted, but
the associated Detail Records are not affected?
a)NON-ISOLATED
b)Cascading
cIsolated
d)All
Ans: D
75)Which two statements about FORM_TRIGGER_FAILURE are true?(choose two)
a)You cannot raise FORM_TRIGGER_FAILURE in a exception handler.
b)FORM_TRIGGER_FAILURE does not cause an unhandled exception.
c)FORM_TRIGGER_FAILURE causes a trigger to fail in a controlled manner.
d)lf you use FORM_TRIGGER_FAILURE to fail a trigger that is called by
another trigger,the called trigger automatically fails.
e)Processing continues after FORM_TRIGGER_FAILURE is raised until the end
of the PL/sQL block that contains it.
f)You must code an exception handler to define how you want the
FORM_TRIGGER_FAILURE exception.
Ans: BC
[…] « Previous Next » […]
[…] « Previous Next » […]