OC PLSQL SE AD3 MCQ with answers

Hello friends if you are looking for OC PLSQL SE AD MCQ | OC PLSQL SE AD Multiple choice questions | OC PLSQL SE AD Objective type questions | OC PLSQL SE AD Question answers dumps | OC PLSQL SE AD Accenture dumps

Please use ‘FIND IN PAGE OPTION’ in google chrome to find any questions

1. 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

2. 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

3. 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

4.which of the following is used to capture the type of error?

a ERROR_TYPE
bJERRORNAME
c)ERROR_CATEGORY

d)None
ANS:-a

5.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

6.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)

7.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

8.What is the default canvas in forms?
a)Content Canvas

bStacked Canvas
c)Horizontal Canvas
d)Tab Canvas
ANS:-a

9.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

10.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

11.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

12.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

13.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

14.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.

a)Deferred: No
Automatic Query: Yes/No

a)Deferred: Yes
Automatic Query: Yes

a)Deferred: Yes
Automatic Query: No

a)Deferred: Yes/No
Automatic Query: Yes
ANS:-a

15.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:-a

16.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

17.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

18.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

19.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

20.There are two forms
1. FORM1
2. 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

21.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)Al
ANS:-a

22.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

23.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?
Form Name:EMP_FORM

Data Block Name: Emp
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

24.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

25.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

26.Which of the following form builder module will have .pll extension?

a)Program Library List
b)Primary Library List
c)PL/SQL Library Module Binary

d)Programming List Library
ANS:-C

27.Which of the following module of oracle forms builder a menu can be

attached in the property palette?
a)Form Module
b)PL/SQL Library

c)Object Library
d)All

ANS:-a

28.Which of the following builtin is used to invoke an LOV in forms?

a)SHOW_LOV()

b)OPEN LOV()

c)LOAD_LOV()

dCALL_LOV()

ANS:-a

29.Which of the following builtin is used to invoke an alert in oracle
forms?
a)SHOW_ALERT()
b)CALL_ALERT()

cLOAD_ALERT()

d)INVOKEALERT()
ANS:-a

30.Which of the following builtin is used to change the visual attribute

property at runtime?
a)SET_ITEM_PROPERTY)

b)GETITEM_PROPERTYO

cSET PROPERTY_FORM()
d)SET_ITEM_ATTRIBUTE)

ANS:-a

31.Which of the trigger is used to handle oracle form errors?
a)ON-ERROR
b)WHEN-ERROR-OCCUUR

c)WHEN-ERROR-RAISED

d)NEW
ANS:-a

32.Which option should Lucy choose to display the current date in an item

named TransactionDate

in the Transaction

Module.

Choose most appropriate option.
aSYSDATE

b$$SYSDATESS

c)SSdate$s

d)$Scurrentdate$$
ANS:-C

33.Ram has created a form in which data block is created using wizard,

which of the following builtin is used to perform insertion

operation?
a)FORM_COMMIT;

bSAVE_COMMIT;
c)COMMIT_FORM;

d)LOG FORM;
ANS:-C

34.Which of the following builtin is used to retrieve the name of the

item that caused the ON-ERROR trigger to fire?
ANS:-5YSTEM.TRIGGER_ITEM

35.What is the default value for the Menu Module Property for a form.
Choose the most appropriate option.
a)DEFAULT

bSMARTBAR
c)DEFAULTSMARTBAR

d)DEFAULT&SMARTBAR

ANS:-d

36.Which of the following is a system variable, which holds a value that

indicates whether the current record is the last record in a block?
ajSYSTEM.LAST_RECORD
b]SYSTEM.FINAL_RECORD
c)SYSTEM.RECORD_LAST

d)SYSTEM.LAST_ROW

ANS:-a

37.In oracle forms, Which of the following builtin is used to displayya

message?
a)MESSAGE()
b)RAISE_MESSAGE()
c)DISPLAY_MESSAGE()

d)None
ANS:-a

38.Which of the following is not a correct match for component and

executable?
1)Form:.fmx

2)Menu:.mmx
3)PL/SQL Library:.plx

4)0bject Library.olx
a)1
b)2
c)3

d)4
ANS:-d

39.ldentify the appropriate display styles of an alert.

a Stop,Caution, Note
bWarn,Implify,Stop
c)Caution, Note, Simple

d)None of the above
ANS:-a

40.State True or False
In master detail, If the deferred Property is set to "Yes' and Automatic

Query is set to "Yes,The associated detail records are retrieved when

the form
cursor is positioned on the detail block.
ANS:-True

41.To create a 'CUT' (Which cuts the selected text}menu option in menu

module. Which type of menu has to be selected?
a)Magic

b)Plained
c)Checked
d)All

ANS:-a

42.Which of the following builtin is used to change the menu property at
run time?
ANS:-SET MENU_ITEM_PROPERTY

43.Which of the following function is used to create a record group?
a)CREATE_QUERY_FORM_GROUP()

bCREATE GROUP_FROM_QUERY()

c)CREATE_GROUP_QUERY()

d)CREATE QUERY()
ANS:-b

44.Which of the following is a system variable that holds the value of
the current record number?
ANS:-SYSTEM.CURSOR_RECORD (SYSTEM.CURRENT_RECORD)

45.Which of the following is a valid menu item type in oracle forms?

a)Magic
b)Plain

ccheck

dall
ANS:-d

46.In oracle forms what is the return type of SHOW_LOV() builtin?
a)NUMBER

bDate
c)VARCHAR2

d)Boolean
ANS:-d

47.Identify the first step that needs to be performed in order to attach
a custom menu module to a form module.

Choose the most appropriate option.

acreates the executable of the menu module by compiling the same.
b)Attach the menu module to the appropriate form.

c)Create the executable of the menu module by executing the same.

d)None of the above.
ANS:-a

48.Which of the following can be associated only to an item and not to a

module in Oracle forms?
a)Menu
b)Popup Menu

cBoth
d)None
ANS:-Menu (ans doubt)

49.State True/False
An alert can have maximum five buttons.

ANS:-False

S0.Which of the following builtin cannot be used in oracle forms?

a)RAISE APPLICATION_ERROR()
bCALL_FORM()
c)DBMS_OUTPUT.PUT_LINE()

d)CLEAR FORM()
ANS:-C

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'

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?
ANS:-When-new-form-instance, EXECUTE_QUERY
58.which of the following trigger can be used to perform datablock level

validation?
ANS:-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

trigger?

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

dall
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)Which of the following options are VALID for canvases?
ANS
1.By default, any canvas created, is assigned at runtime to the window

named WINDOW1
2.Content Canvas can be created with the help of Layout wizard, Layout

Editor and Object Navigator
3.A tab canvas, made up of one or more tab pages, allows you to group and

display a large amount of related information on a single,dynamic canvas
object.
4.A stacked canvas with raise on entry property set to yes can be

displayed only through navigation or programmatic control.

71)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.

72)Which of the following functions can be accomplished only with the use
of key triggers?
ANS:

1.Changing function keys default functionalityY
2.Disabling function keys

73)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

74)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

75In 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

76)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(ans doubt)

77)which two statements are true of a Query Record Group?(choose two)
a)The record group is associated with a query.

bThe record group can be created only at run time.
c)The record group can be created and modified only at design time.

d)The record group can be created and modified at design time or at run
time.

ANS-AD

78)Which three statements about display items are true?
a)A display item can be a database item.

bThe content of a display item can be read and change programmatically.
c)If a display item is a part of a control block, its calculation mode

property is ignored.
d)A display item does not have a Format mask property,so a text item must

be used where that functionality is required.
e)The content of a display item can be validated using a Key-Next-ltem
trigger with the scope of the display item.
f)A display item does not have a Multi-Line Property, so a text item must

be used where the functionality is required.
ANS -ABF

79 which two statements define a static record group?

a)The record group can be created only at run time.
b)The record group is not associated with a query.
c)The record group can be created and modified only at design time.

d)The record group can be created and modified at design time or at run

time.
ANS:-BC

80)An application uses a menu that contains a check type menu item. You

want to programmatically toogle the checked

/unchecked state of the check item.
which two built-ins can you use to accomplish this?(Choose two)
a)FIND_ITEM
b)REPLACE_MENU

c)FIND_MENU_ITEM
d)GET_ITEM_PROPERTY

eSET_ITEM_PROPERTY
fSET_MENU_ITEM_PROPERTY
g)GET_MENU_ITEM_PROPERTY
ANS:- FG

81)How can you programmatically determine which button a user pressed to

respond to an alert?
a)Use the GET_ALERT_PROPERTY function.
b)Use the GET_ALERT_BUTTON_PROPERTY function.
c)Check the value returned by the SHOW_ALERT function to see if it is 1,2

or 3.
d)Check the value returned by the SHOW_ALERT function to see if it is
ALERT BUTTON1,ALERT_BUTTON2 and ALERT_BUTTON3.

ANS:-d

82)Which of the following are the types parameters passed from calling

form?(choose three)
a)GLOBAL

bSYSTEM
c)PARAMETER
d)LOCAL

ANS:-abc

83)Which of the following built in is used to add elements in list item

at run time?

aJADD_LIST_ELEMENT()

b)ADD_ELEMENT()
c)ADD_LIST_ELEMENTS()

d)ADD_ELEMENTS()

ANS:-a

84)Which of the following contains select statement associated with LOV
in oracle forms?

a)RECORD GROUP
b)BLOCK GROUP

c)OBJECT GROUP

d)PLSQL LIBRARY

ANS:-a

85)Which of the following item type has to be chosen for displaying more

than 4 options for a single field?
a)TEXT ITEM

b)RADIO BUTTON
c)LIST ITEM
d)ALL

ANS:-C

86)In oracle forms, Business Logic is written in which of the following

languages?

a)Java
b)HTML
c)XML

d)PL/SQL
ANS:-d

87)which of the following is valid item type in oracle forms?
a)TEXT ITEMM

b)RADIO BUTTON
c)LIST ITEM

d)ALL

ANS:-d

88)In forms development, Which GUI item needs to be considered for the

fields like GENDER?
a)RADIO BUTTON
bjCHECK BOX
c}TEXT ITEM

d)DISPLAY ITEM

ANS:-a

89 Which of the following builtin is used to clear a list in oracle
forms?
a)CLEAR_LIST_ITEM()

b)FLUSH_ITEM()
c)FLUSH_LIST_ITEM()
dhCLEAR_LIST()

ANS:-d

90)Which of the following database can oracle forms connect to?

a)Oracle Database
b)Oracle NoSQL database
c)DB2

d)None
ANS:-a

91)How many ALERTS can be created on a single form?
a)1
b)2
c)3

d)Any Number
ANS:-d

92)What is the difference between LOV and List item?
ANS:-LOV displays multi column information where as the list itemn

displays single column information.

93)Oracle forms are used to develop front applications in oracle Ebusiness rule?
ANS:-True

94)Which of the following are the various ways to printa message in

oracle forms?
a)MESSAGE()

b)DISPLAY(0

c}PRINT()

d)None
ANS:-a

95)Which of the following library can contain objects such as Data
Blocks, Items, Canvases, windows etc.
a)PLSQL library

b)Object Library

c)Object Navigator
d)Data Library
ANS:-b

96)Lucifier Created a Login form. When user login, he should get a
BOOKING form where he can book tickets for a movie.

He wrote the following codein When-button-pressed

of Login Button.

BEGIN

CALL_FORM'FORM',NO_HIDE,No_REPLACE,QUERY_ONLY);

END
Whenever he has logged in and tried booking details for Avengers. However
when he is typing something in booking
form, he is getting an error "Form is running in query only mode" what is

the reason for this?
ANS:- Modify the code in login button as

CALL_FORM(FORM",NO_HIDE,NO_REPLACE, NO_QUERY_ONLY);

97)You wish to have certain values initialized in a form when the form is

first opened. Which trigger
will you use? Choose an appropriate

option.

a)WHEN-NEW-FORM
b)PRE-FORM
c)PRE-LOGON

d)WHEN-NEW-FORM-INSTANCE

ANS:-b

98)Which built in combination we use to create a parameter list and check

the parameter list created successfully?

a)CREATE_PARAMETER_LIST

bID_NULL

c)CREATEQUERY_PARAMETER_LIST
d)ID-NULL
ANS:-AB

99 Which are the valid statements about canvases,windows?(choose three)
a)An application may have a single window into which all canvases are

displayed.
b)Canvases are the form components that are used to display items.

c)Canvases and windows are non-form components.
d)The window is the frame through which the canvas is used.
ANS:-ABD

100)Which built-in we can use to toggle checked/unchecked state of the

check item?(choose two)
a)FIND_ITEM
b)SET_MENU_ITEM_PROPERTY
c)GET_MENU_ITEM_PROPERTY
d)GET_ITEM_PROPERTY
ANS:- BC

101)Which is the valid statements about obj libraries?
a)Object Libraries are saved as part of the form module.

bIndividuals items cannot be placed into an object library.
c)All Object libraries in the current working directory are opened when

the form builder is opened.
dUsing Object libraries can immense network performance...
ANS:-C

102)Which property of relation object is used for the coordination

between a Master and Detail Block in
Master-Detail Form. Choose an appropriate option.
a)loin Condition

b)Delete Record Behaviour
c)Deferred
d)None of the above

ANS:-a

103)Which are the valid statements about key triggers?(Choose three)
a)Key triggers change the default behaviour of the function key.

b))Key-trigger fires when the key combination of corresponding function..
c)A function key can be disabled by acting NULL trigger.

d)Key-triggers cannot change the default behaviour of the function key.
ANS:-abc

104)What is the physical and logical limit of canvases in a form?
a)No limit

b)10-15
c)1-5

d)2-4
ANS:-ab

105) Which builtin should be used to invoke one form from another form

so that you can navigate between the two forms?
a)CALL_FORM

b)OPEN_FORM

c)NEWFORM
d)RUN_FORM

ANS:-b

106)While inserting a radio button in form

no of radio buttons can be

assigned to a radio group. Choose most appropriate option.

a)Four

bUnlimited
c)Ten

d)None of the above
ANS:- b

107)which of the following property can be set using visual Attribute of

oracle forms?

a)Foreground color
b)Background color

c)Font Name
d)All

ANS:-d

108)Following builtin is used to change the property of an alert at

runtime?
a)SET_ITEM_PROPERTY()0

bSETALERT_PROPERTY()
c)SET ALERT()
d)NONE
ANS:-b

109)Which application trigger is required to be attached to a text item

to display field for every row record being inserted through
oracle form?
ANS:-when-new-record-instance
110)Which of the following is the argument value that allows you to only

read the data from base tables?
ANS:-QUERY ONLY

111)which builtin is used to destroy parameter list from the memory?
ANS:-DESTROY_PARAMETER_LIST

112)A single block can be connected to multiple database objects like

table,view or synonym.
ANS:-true

113)Which is the VALID statement about FRAMES?

a)Frame is not an object with properties.
b)Each frame cannot be associated with a block.

c)Frames cannot be grouped within an object library.

d)Frames are used to visually group data objects or control objects.
ANS:-d

114)You wish to implement the logic for changing a text item as noneditable ina form when

the form is loaded into the browser.
In which trigger we can implement the logic.

ANS:-when-new-form-instance
115)The customer is filling up the ORDER_ENTRY form. Various triggers are
written for the ITEM_DETAILS text field.

What will be the sequence of firing these triggers for the text item?

ANS:-pre-text-item,when-new-item-instance,key-next-item, when-validateitem,post-text-item

116)What is the physical and logical limit of toolbar canvases in a form?

a)No limit,10-15
b)No limit,1-5
c)No limit,10

d)Zero limit, 10-15
ANS:-a (ans doubt)

117)Which is the valid statement about blocks?
a)A block connected to any database object is called control block.
b)A block not connected to any database object is called data aware

block.
c)A block connected to any database object is called data aware block.

d)A block must be connected to only table.
ANS:-C

118)Which builtin will copies the value into the object by name you

specify?
a)COPY

bjcOPY_CASE
c)CP_PLAN

djCOPY_IN

ANS:-a

119)You wish to implement a list item initially with few values for a

column in a data block and then allow the users to enter the values
in the column at runtime, which list items type will allow you to achieve

this behaviour?
a)A poplist
bJA TList

c)A combo box

d)None
ANS:-C

120)which of the following functions can be accomplished only with the

use of key triggers?
a)Navigating between blocks
b)Disabling functions keys

c)Validating data

d)Modifying data before it is committed
e)Changing function key's default functionality
ANS:-be

121)which of the following system variable returns the record position

status?
ANS:-CURSOR_RECORD

Query record group
A query record group is a record group that has an associated SELECT

statement. Query record groups can be created and modified at design time
or at runtime.
Non-query record group
A non-query record group isa group that does not have an associated

query. Non-query record groups can be created and modified only at
runtime.
Static record group
A static record group is not associated

with a query. Static record

groups can be created and modified only at design time.

MCQ 2

1. WHICH OF THE FOLLOWING PL SQL COLLECTION HAS TO BE INITIALLY DENSE AND CAN BECOME
SPARSE IF NEEDED?
ANS: NESTED TABLE

2. IDENTIFY THE EXTERNAL LOB CHOOSE MOST APPROPRIATE OPTION?
ANS: BFILE
3. WHICH OF THE FOLLOWING PACKAGE IS USED TO IMPLEMENT DYNAMIC SQL?
ANS: DBMs_sQL

4. WHICH OF THE COLLECTION TYPES ARE USABLE AS cOLOUMN DATATYPE IN A TABLE?
ANS: VARRAY AND NESTED TABLE

5. BFILE CAN BE ACCESSED IN BOTH READ AND WRITE MODE SAY TRUE OR FALSE?
ANS: FALSE

1.which of the following is not true about a view in oracle?
Ans: View cannot be created if base table does not exist.
2.which of the following is a valid named block in Oracle PL/SQL?
Ans: All(stored procedure,function,trigger)
3.which PL/SQL builtin procedure is used to raise a user-defined exxeption in oracle PL/SQL?
Ans: RAISE_APPLICATION_ERROR()
4.Which of the following collection is a sparse by its nature?
Ans: both
5.in oracle database,which trigger can be created on database object table?
Ans:before
6.which of the following is a valid trigger event type in oracle pl/sql?
Ans: All(DML,DDL,Logon &Logoff)
7.which of the following is not an external LOB in oracle PL/SQL?
Ans: both(BLOB,CLOB)
8.which of the following is a bounded collection in oracle PL?SQL?
Ans: Varray
9.which of the folloing is a unbounded collection in oracle PL?SQL?
Ans: Both(Nested table,associated array)
10.which type of exception in oracle pl/sql will have a built-in name associated with it?
Ans: predefined exceptions
11. which of the following is mandatory to consider in creation of a PL/SQL function?
Ans: All
12.In oracle PL/SQL ,we can implement polymorphism using which of the following component?
Ans: Package
13.What Is the default mode of a parameter in oracle PL/SQL?
Ans: IN
14.In oracle database,which trigger can be created on database object view?

Ans:Instead of
15.which of the following is a valid collection type in PL/SQL?
Ans: PL/SQL table
16.which of the following are valid for forward declarations?
Ans: 1)All identifiers and subprograms have to be declared before use.
2)Forward declaration consists of the subprogram specification terminated by a semicolon.
3)A forward declaration is used for defining the subprograms in logical or alphabetical
order,defining mutually recursive subprograms and for grouping sub
17.Consider the procedure given below.
CREATE OR REPLACE PROCEDURE PROC_1 AS num1 NUMBER(2);
Num2 NUMBER(2);
ans NUMBER(3);
BEGIN
ans:=num1+num2;
DBMS_OUTPUT_LINE(‘SUM IS’|| ans);
END;
Ans:EXEC PROC_1;
18.Consider the following code:
1.CREATE TABLE songs(songid char(5),singer varchar2(10));
2.INSERT INTO songs values(‘S1’,’Sonu’);
3.ALTER TABLE songs MODIFY songid char(3);
4.ALTER TABLE songs MODIFY singer varchar2(5);
Ans: Statement 3
19. Identify the internl LOB’s.
Ans: BLOB,CLOB,NCLOB
20.Which of the following otion s/are valid with respect to cursor?
Ans: All of the above
21.Assume that the statements are executed one after the other,empno is declared as primary key.

Ans: DUP_VAL_ON_INDEX exception is raised
22.Which command will delete all data drom a table and will write to the rollback segment?
Ans: DELETE
23.Identify the typical modeling reviews
Ans: Inconsisytent views of database,Incompatible data concepts and datatypes,redundant data
24.which statement about triggers is true?
Ans: you use a database trigger to fire when an INSERT statement occurs
25.What is a condition predicate in a DML trigger?
Ans: A conditional predicate allos you to combine several DML triggering events into one in the
trigger body.
26. Which of the following otion s/are valid for FORWARD DECLARARTIONS?
Ans: All the identifiers and subprograms have to be decalred before use,forward declarartion is used
for defining the subprograms in loical or alphabeticl order, defining mutually recursive subprograms
and for grouping subprograms,forward declarartion consists of subprogrms specification terminated
by a semicolon.
27.CREATE TABLE workers (wid char(3) DEFULT LIKE ‘W%’,wname VARCHAR2(10));
What is the output of above query?
Ans: Query fails as pattern matching not allowed in create statement.
28.Which of the following are true about PIVOT tool?
Ans: It automates the oracle PL/SQL code quality rview process,It makes sure that the best practice
rules are applied to each and every line of code,Output of the code quality tool is in two formats as
HTML and XML.
29.For both implicit and explicit cursors ,identify the sequence of operations that PL/SQL performs in
order to execute a sql statement in a program.
Ans: PARSE,BIND,OPEN,EXECUTE
30.consider the following trigger:
CREATE OR REPLACE TRIGGER upper_trig BEFORE INSERT or UPDATE of ename on new_emp
For each ro begin:new.ename:=UPPER(:old.ename);
END;
What will happen when above code is executed?

Ans: Converts all names into upper case
31.which of the following are valid exceptions?
Ans:TOO_MANY_ROWS,ZERO_DIVIDE,INVALID_CURSOR,NO_DATA_FOUND
32.for the pragma directive: PRAGMA EXCEPTION_INIT(exception _name,error_number) The value
of error_number should be
Anss: Any orcle error code other than predefined exception
33. the old and new qualifiers can be ued in ehich of trigger?
Ans: Row evel DML trigger
34. A fetch statement of a cursor returns multiple rows
Ans: false
35.An error-trapping function SQLCODE returns a numeric value 1,--------.
Ans: when user-defined exception is raised.

1.

which parametr made in pl/sql needs bind variable when procedure or
function is execute at schema level?
ans:---->out

2.

....project team customized pre configured validation rules in PIVOT
ans:---->yes

3.

considering the presence of columns salary,employee_id,ename in
employee table where employee_id is primary key column
predict the outcome of below procedure creation............
ans:---->procedure will be created with funtional erorrs

4.

consider=emp(empid,ename) has two rows with below values
row1=(1000,'first name')
row2=(1001,'second name')........
ans:------>1000 first name 1001 second name

5.

html validation report in pivot is used by
ans:----->pl/sql developer

6.

which database object cannot be tested with same type of database
object
ans:----->package

7.

what will happen if a function is defined in package body without
defining the function specification in package specificaton?

ans:----->it is called as private function and you will able to
access......
8.

which of the following is oracle pl/sql collection cannot be defined
at schema level
ans:----->associate table or plsql table

9.

__________ attributre is used to declare a variable for handling table
records and also for an explicit cursor records....with appropriate
option
ans:----->%row type

10.

the old and new qualifiers can used in which type of trigger? choose
most appropriate.....

ans:---->Row level dml trigger
11.

....execution of trigger can be achieved using the _______
clause.fill in the blanks.......
ans:----->option 2:when

12.

......project team customized pre configured validation rules in
pivot
ans:---->yes

13.

consider the following code,predict the output of the program
declare.....
n Numlist=NumList(10,20.....)........
n.Delete(3,6);
ans:----->deletes the element 3 through 6

14.

identify the component of a lob that references to where the lob
value is physically stored
ans:----->LOB Locator

15.

oracle pl/sql supports following data types

ans:----->both
16.

consider the procedure given below
create or replace procedure proc_1 as
num1 NUMBER(2);num2 NUMBER(2);.......

ans:------->all of the above
17.

consider the presence of column named 'department _name' table and
also table named 'employees' choose ....
declare

typet1 is table of employees%row type v1 t1;.....
ans:---->error at line number
18.

6

which of the following is true about packages 1.package body
....2.package specification ...3package can have....
ans:------>1,2 and 3

19.

considering the presence of columns salary employee id in employees
table also the presence of employees with employee_id 100 predict the
output of function creation
create or replace....
v_asal number

.......

return v_sal
ans:------>fuction creates with compilation error as size is mentioned
for a parameter
20.

considering the presence of a column named 'first_name' in 'emp'
table choose the output of the below program

declare
type t1 is table of varchar2(20)......
select first name bulk collect into v1 from emp;
ans:----->error at line number 5
21.

create a multi dimensional collection in pl/sql
ans:------>true

22.

considering the presence of table with column marks .....when an
update operation is performed on marks...
create or replace Trigger updated marks........
Dbms.output.line(old marks are ||old marks........)

end.
ans: ------>it will raise an error as :old and :new cannot be used in
this type of trigger
23.

predict the output of following code

declare
e_exception EXCEPTION;............
when others then......
end;
ans.------>handled in when others section

24.

..... a bind variable declare and value assigned as below two
statements .....

_ENO:100.......
consider below creation of code.....
the presence of columns salary,employee_id in the employees....
.return V_ASAL ;......
ans:------>it will return the annual salary of....present.otherwise raises
an exception .....
25.

predict the outcome of the below procedure creation (Line numbers are
only for reference and needs to be excluded while creation )

create or replace......
execute immmediate truncate from table......
end; /
ans:------->procedure gets created with compilation errors as there is an
error at line 4
26.

which of the following type of oracle pl/sql collection is used for
sparse collection through out its life time ?

ans: ------->associated array
27.

can project team customized pre configured validation rules in pivot

ans.----->yes
28.

validation report in pivot is in which format?

ans.------>HTML
29.

considering the presence of columns salary,employee id,e_name in
employees table
where employee_id is primary key constrained column
predict the outcome of the below procedure creation
create or replace ......
insert into emolyese(ename,salary)values......
end;

ans:----->procedure succesfully gets created

30.

predict the output of below code
declare
v_var1 number;
v_var2 v_var1%type.....
dbms_output.put_line(v_var2);
end

ans:----->numeric or value error
31.

considering the presence of ename in new_emp table ,predict the
outcome of the following trigger
create or replace trigger upper_trig before insert or update.....
new.ename=upper(:old.ename)
end;

ans:-------->trigger gets created successfully
32.

which of the following collection type can be created both at schema
level and pl/sql block?

ans.------->nested table
33.

identify the external lob choose most appropriate option

ans:----->bfile
34.

.....row level trigger will execute if the update statement is
affecting 10 rows

ans.------->10
35.

with respect to a condition predicate in a dml trigger choose
appropriate option.

most

ans:------->A conditional predicate allows you to combine several dml
triggering events in to one inthe trigger body
36.

which of the following pl/sql collection has to be initially dense
and can become sparse if needed?

ans.------->nested array
37.

which of the following exception will not have a bullitin exception
name in pl/sql

ans:------->non-predefined exceptions
38.

which of the collection type can be created both at the schema level
and pl/sql block?

ans:-------->nested table
39.

which pl/sql collection would fit the below scenario

assesment student data of discipline cse(computer science and
engineering) in a college with maximum 60
ans:------->Varray
40.

considering the presence of the columns named 'ename' and 'sal' in
'emp' table and in absence of 1234 employee number.....choose the
output of the
below program

declare
........
select sal*12 into v_sal from emp where empno=1234;
.......
end;
ans:------->exception at line number 5 as there is no employees with
employee number 1234
41.

....Sql code of exception with name NO_DATA_FOUND?

ans:------->100
42.

which statement is true about triggers? choose most appropriate
option.

ans:------>You use a database trigger to fire when an insert statement
occurs.
43.

which of the following pl/sql collection has to be initially dense
and can become sparse if needed?

ans.----->nested table
44.

which of the following builtin is used to associate a exception name
for a non-predefined exception?

ans.----->EXCEPTION_INIT()
45.

which of the following is not a predefined exception ?

ans:------>COLLECTION_NULL
46.

which of the following pl/sql collection will allow index by of
varchar2 data type?

ans.------->Associative array

------------------75 pages pdf------------------------------------------------------------------------

47. which of the following types of oracle pl/sql collection is used for
Sparse collection through out its life time.
Ans:--- Associative array
Nested table

48. Create or replace trigger upper_trig before insert or update of ename
on new_emp
for each row
begin
:new.ename=UPPER(:old.ename);
End;
Ans:--Trigger Created Successfully

49. Which of the following is the SQL CODE for exception with name
TOO_MANY_ROWS
Ans:--1422

50. with respect to a conditional predicate in DML trigger choose most
Appropriate option
Ans:-- A conditional predicate in a DML triggering Events into one.

51. What is the sql code of Exception with Name NO_DATA_FOUND
Ans:-- 100

52. which procedure is used to create Customized Error message?Choose Most
Appropriate option
Ans:-Raise_Application_Error

53. Which of the following is not a valid index by data types in Associate
Arrays?
Ans:-- date

54. which of the following exception will not have a builtin Exception
name in sql?
Ans:--- Non-predefined Exception

55.
create or replace Trigger Updated_marks
Before update on student
Begin
Dbms_output.put_line('old marks are'||:old.Marks||'New Marks
are'||:New.marks);
Ans:----- it will raise error as :old and :new cannot be allowed in table
level Triggers

56.

create or replace Function Annual_salary

return number
IS
V_sal number;
Begin
select*12 into v_sal from Employees where Employee_id=100;
return v_sal;
end;

ANS:----

57.

Function gets created Successfully

HTML validation Report in PIVOT is used by-------

ANS:--- Project Manager

58.

what is the following is valid exception code that a user can give
for user defined exception

Ans:-----20999

59.

in oracle pl/sql which of the following is stored as a database
objects when once created

Ans:--- All[Triiger,function,procedure]

60.

which of the following is not a predefined Exception

Ans:---which is started with collection option is correct

61.

Represent student data of discipline CSE in a college with maximum of
60 seats

Ans:---All

62.

Which of the following is a bounded and dense collection in sql?

Ans:---Varray

63.

Create or replace Trigger upper_trig Before Insert or update of ename
on new_emp

for each row
Begin
:new.Ename:=UPPER(:old.Ename);
End;

Ans:--- Trigger created Successfully

64.

what will happen if a function is defined in package body withou
defining in package specifiacation

Ans:----- it gives invalid identifire error

65.

which of the following package is used to perform operations on LOBS

Ans:---- dbms_lobs

66.

which of the following is true about order of

Exceptions?

Ans:-- optipons1,3

67.

can project team constructed pre customized validation rules in
pivot?

Ans:----------- YES

68.

In a RAISE_APPLICATION_ERROR what is the valid range of eeroor number
can make use of it?

Ans:--

69.

-20000 to -20999

which of the following exception will not have a builtin error name
in pl/sql

Ans:--Non-predefined Exception

70.

predict the output of the following code

Declare
v_var1 number;
v_var2 v_var1%Type;
Begin

v_var2:='A';
dbms_output.put_line(v_var2);
End;
Ans:------------------------Numeric or value eroor:Character to number
conversion Error

71.

What is pivot Stands for?

Ans:------------- project insights and visualization toolkit

72.

Which of the following is a type of Triggering Event for instead of
Trigger in oracle database

Ans:------------DML

73.

with respect to a condition predicate in a DML trigger choose most
Appropriate option

Ans:---Single lined Ans is correct

74.

create or replace function Annualsal(p_Eno Number)

return number
is
v_sal number;
Begin
select salary*12 into v_sal from employees where employee_id=p_eno;
return v_sal;
end;
Ans:--- It will return Annual salary of an employee if else present
...........otherwise raise an exception

75.

which of the following package is used to implement dynamic sql

Ans:--DBMS_sql

76.

which of the following plsql collection not defined at Schema level

Ans:=-- Associative Array

77.

non-predefined Exception can be defined with name using

Ans:-- Pragma_Exception_init

78.

create or replace procedure new_employee(P_Ename varchar2,p_sal
number)

Is
Begin
insert into Employees(first_name,salary) values(p_Ename,p_sal);
commit;
End;
Ans:---

79.

validation Report in Pivot is in which format?

Ans:--- HTML

80.

Which property of database guarantees persistence of an action once
notified about its success

Ans:--Durability

81.

which of the following pl/sql collection will allow INDEX BY of
VARCHAR2 Data type?

Ans:--

Associative Array

82.

which of these pl/sql collection datatypes also known as Associative
Array?

Ans:-- PL/sql Table

83.

declare
v_ename varchar2;

Begin
select ename into v_ename from emp where empno=1234';
dbms_output.put_line(v_ename);
end;

Ans:--range

84.

Error at line 2 , as the string length constraint must be in

declare
type t1 is table of varchar2(20);

v1 t1;
begin
select first_name bulk collect into v1 from emp;
dbms(v1);
end;
Ans:--- Error at line number 6

85.

create multi-dimensional collection in pl/sql?

Ans:--Yes
86.

which built in cannot be used with Associative Array?

Ans:-- Extend

87.

which parameter mode in pl/sql needs a bind variable when procedure
or function is excuted at schema level?

Ans:--

88.

OUT

which is true about trigger?

Ans:-You use a database Trigger to fire when an Insert statement Occurs

89.

qution not visible in pdf

Ans:--Handled in when others section

90.

Difference between collection Built-in Trim and delete

Ans:--- Delete deletes elements from any position in collection where as
Trim deletes elements from end of the Varray and nested table

1. WHICH OF THE FOLLOWING PL SQL COLLECTION HAS TO BE INITIALLY DENSE AND CAN BECOME
SPARSE IF NEEDED?
ANS: NESTED TABLE
2. IDENTIFY THE EXTERNAL LOB CHOOSE MOST APPROPRIATE OPTION?
ANS: BFILE
3. WHICH OF THE FOLLOWING PACKAGE IS USED TO IMPLEMENT DYNAMIC SQL?
ANS: DBMS_SQL
4. WHICH OF THE COLLECTION TYPES ARE USABLE AS COLOUMN DATATYPE IN A TABLE?
ANS: VARRAY AND NESTED TABLE
5. BFILE CAN BE ACCESSED IN BOTH READ AND WRITE MODE SAY TRUE OR FALSE?
ANS: FALSE
6. CONSIDER THE PROCEDURE GIVEN BELOW.
CREATE OR REPLACE PROCEDURE PROC_1 AS
num 1 NUMBER(2);
num2 NUMBER(2);
ans NUMBER(3);
BEGIN
ans = num1+num2;
DBMS _OUTPUT.PUT_LINE(‘SUM IS’|| ANS);
END;
ASSUMING THAT THE APPROPRIATE PROCEDURE IS CREATED SUCCESSFULLY, IDENTIFY THE VALID
OPTION THAT IS USED TO EXECUTE THE PROCEDURE.CHOOSE APPROPRIATE OPTION?
ANS: EXEC PROC_1
7. CONSIDERING THE PRESENCE OF THE COLOUMN NAMED ‘ENAME’ IN ‘EMP’ TABLE AND ALSO 1234
EMPLOYEE NUMBER, CHOOSE THE APPROPRIATE OUTPUT THE GIVEN BELOW.
DECLARE
V_ENAME VARCHAR2;
BEGIN
SELECT ENAME INTO V_ENAME FROM EMP WHERE EMPNO=1234;
DBMS_OUTPUT.PUT_LINE (V_ENAME);
END;/
ANS: ERROR AT LINE 2
8. THE OLD AND NEW QUALIFIERS CAN BE USED IN WHICH TYPE OF TRIGGER? CHOOSE THE MOST
APPROPRIATE OPTION?
ANS: ROW LEVEL DML TRIGGER
9. IN ORACLE PL/SQL , WHICH OF THE FOLLOWING CAN BE USED AS RELATIONAL NOT EQUAL TO
OPERATOR?
ANS: ALL (!=,<>,~= )
10. WHICH OF THE FOLLOWING TYPE OF ORACLE PL/SQL COLLECTION IS USED FOR SPARSE
COLLECTION THROUGH OUT ITS LIFE TIME?

ANS: ASSOCIATED ARRAY
11. CONSIDERING THE PRESENCE OF A TABLE STUDENT WITH COLOUMNS MARKS .
PREDICT THE OUTPUT OF THE BELOW TRIGGER EXECUTION WHEN AN UPDATE OPERATION IS
PERFORMED ON MARKS COLUMN OF STUDENT TABLE (WITH SET SERVEROUTPUT ON)
CREATE OR REPLACE TRIGGER UPDATED_MARKS
AFTER UPDATE ON STUDENT
BEGIN
DBMS_OUTPUT.PUT_LINE (“OLD MARKS ARE:”||:OLD MARKS||”NEW MARKS ARE:”||:NEW MARKS);
END ?
ANS: IT WILL RAISE AN ERROR AS :OLD AND :NEW CANNOT BE USED
14. CONSIDERING THE PRESENCE OF COLOUMNS SALARY,EMPLOYEE_ID IN EMPLOYEES TABLE AND
ABSENCE OF EMPLOYEE WITH EMPLOYEE_ID 100.
PREDICT THE OUTCOME OF THE BELOW FUNCTION CREATION.
CREATE OR REPLACE FUNCTION ANNUALSALARY
RETURN NUMBER
IS
V_ASAL NUMBER;
BEGIN
SELECT SALARY*12 INTO V_ASAL FROM EMPLOYEES WHERE EMPLOYEE_ID=100;
RETURNV_ASAL;
END;
ANS: FUNCTION CREATES WITH COMPILATION ERRORS AS SIZE IS MENTIONED FOR/FUNCTION GETS
CREATED WITH RUNTIME ERRORS
13. WITH RESPECT TO A CONDITION PREDICATE IN A DML TRIGGER.CHOOSE MOST APPROPRIATE
OPTION?
ANS: A CONDITIONAL PREDICATE ALLOWS YOU TO COMBINE SEVERAL DML TRIGGERING EVENTS
INTO ONE
14. WHICH OF THE FOLLOWING IS CORRECT TRIGGER TO CHECK UPDATE ON EMP TABLE BETWEEN
9AM AND 6PM?CHOOSE THE MOST APPROPRIATE OPTION?
ANS: CREATE OR REPLACE TRIGGER EMP_UPDATE_CHECK
BEFORE UPDATE ON EMP
BEGIN
IF(TO_CHAR(SYSDATE. ‘HH24’) BETWEEN ‘9’ AND ‘18’) THEN
RAISE_APPLICATION_ERROR(-2055, ‘MODIFICATION OF EMPLOYEE NOT P**** DURING
BUSINESS HOURS’);
END IF;
END;
/
15. WHICH OF THE FOLLOWING CAN BE A TRIGGERING EVENT FOR A INSTEAD OF TRIGGERIN ORACLE
DATABASE?
ANS: DML
16. WHICH OF THE FOLLOWING CANNOT BE INCLUDED IN A PL/SQL PACKAGE? CHOOSE THE MOST
APPROPRIATE OPTION?
ANS: TRIGGERS
17. WHICH OF THE FOLLOWING PACKAGE IS USED TO PERFORM OPERATIONS ON LOBS?
ANS: DBMS_LOB
18. WHICH PARAMETER MODE IN PL/SQL NEEDS A BIND VARIABLE WHEN PROCEDURE OR FUNCTION
IS EXECUTED AT SCHEMA LEVEL?
ANS: ALL (IN,OUT,OUT IN)

19. HOW MANY TIMES A BEFORE UPDATE ROW LEVEL TRIGGER WILL EXECUTE IF THE UPDATE
STATEMENT IS AFFECTING 10 ROWSIMMEDIATE
ANS: 10
20. ORACLE PL/SQL SUPPORTS FOLLOWING NUM1PES?
ANS: BOTH
21. WHICH OF THE FOLLOWING IS ORACLE PL/SQL COLLECTION CANNOT BE DEFINED AT SCHEMA
LEVEL?
ANS: ASSOCIATIVE ARRAY
22. CONDITIONAL EXECUTION OF A TRIGGER CAN BE ACHIEVED USING THE……………CLAUSE.FILL IN
THE BLANKS WITH AN APPROPRIATE OPTION?
ANS: WHEN
23. WHATS OF THE FOLLOWING IS A VALID EXCEPTION CODE THAT A USER CAN GIVE FOR USER
DEFINED EXCEPTION?
ANS: -2999
24 …………………………..ATTRIBUTE IS USED TO DECLARE A VARIABLE FOR HANDLING TABLE RECORDS
AND ALSO FOR AN EXPLICIT CURSOR RECORDS? FILL IN THE BLANK WITH AN APPROPRIATE OPTION?
ANS: %ROWTYPE
25. WHICH OF THE FOLLOWING ABOUT EXISTS METHODS OF PL/SQL COLLECTION IS TRUE?
ANS: RETURNS TRUE IF AND ONLY IF SPECIFIED ELEMENT OF ASSOCIATIVE ARRAY OR VARRAY OR
NESTED TABLE EXITS.
26. WHICH OF THE FOLLOWING STATEMENT IS TRUE FOR REGARDING A DATABASE TRIGGER?CHOOSE
THE MOST APPROPRIATE OPTION?
ANS: A BLOCK OF CODE WHICH IS IMPLICITLY INVOKED UPON OCCURRENCE OF A DATABASE EVENT

27. CAN PROJECT TEAM CUSTOMIZED PRE CONFIGURED VALIDATION RULES IN RA?
ANS: YES
28. WHICH OF THE FOLLOWING TYPE OF EXCEPTION WILL NOT HAVE A BUILTIN EXCEPTION NAME IN
PL/SQL?
ANS: NON PREDEFINED EXCEPTIONS
29. WHICH OF THE FOLLOWING IS/ARE A PREDEFINED EXCEPTION? 1. VALUE_ERROR 2.
INVALID_NUMBER
ANS: BOTH 1 and 2
30. PREDICT THE OUTCOME OF THE BELOW PROCEDURE CREATION.(LINE NUMBERS ARE ONLY FOR
REFERNCE AND NEED TO BE EXCLUDED WHILE CREATION)
1. CREATE OR REPLACE PROCEDURE DROP_TABLE(P_TNAME VARCHAR2)
2. IS
3. BEGIN
4. EXECUTE IMMEDIATE ‘DROP FROM ‘||P_TNAME
5. END;
6. /
ANS: PROCEDURE GETS CREATED WITH COMPILATION ERRORS AS THERE IS AN ERROR AT LINE 4
31. CONSIDER A BIND VARIABLE DECLARED AND VALUE ASSIGNED AS BELOW TWO STATEMENTS.
VARIABLE P_ENO NUMBER;
EXEC :P_ENO=100;
NOW CONSIDER THE BELOW FUNCTION CREATION CODE. CONSIDERING THE PRESENCE OF
COLOUMNS SALARY,EMPLOYEE_ID IN A TABLE EMPLOYEES.PREDICT THE RESULT OF THE FUNCTION
WHEN EXECUTED AFTER ITS CREATION.
CREATE OR REPLACE FUNCTION ANNUALSAL(P_ENO NUMBER)
RETURN NUMBER
IS
V_ASAL NUMBER
BEGIN
SELECT SALARY*12 INTO V_ASAL FROM EMPLOYEES WHERE EMPLOYEE_ID=P_ENO;
RETURN V_ASAL;
END;
ANS: IT WILL RETURN THE ANNUAL SALARY OF AN EMPLOYEE IF….PRESENT.OTHERWISE RAISES AN
EXCEPTION
32. CONSIDERING THE PRESENCE OF A COLOUMN NAMED ‘FIRST_NAME’ IN ’EMP’ TABLE.CHOOSE
THE OUTPUT OF THE BELOW PROGRAM.
1.DECLARE
2. TYPE T1 IS TABLE OF VARCHAR2(20);
3. V1 T1;
4. BEGIN
5. SELECT FIRST_NAME BULK COLLECT INTO V1 FROM EMP;
6. DBMS_OUTPUT.PUT_LINE(V1);
7. END;
ANS: ERROR AT LINE NUMBER 6
33. WHAT IS THE SQLCODE OF EXCEPTION WITH NAME NO_DATA_FOUND?
ANS: 100
34. CONSIDER THE FOLLOWING CODE, PREDICT THE OUT OF THE PROGRAM? DECLARE TYPE NUMLIST
IS TABLE OF NUMBER N NUMLIST= NUMLIST,(10,20,30,40,50,60,70,80,90,100) BEGIN NDELETE(3,6)
END?
ANS : DELETE THE ELEMENTS 3 THROUGH 6
35. CONSIDERING THE PRESENCE OF COLOMNS SALARY, EMPLOYEE_ID, ENAME IN EMPLOYEES
TABLE.WHERE EMPLOYEE_ID IS A PRIMARY KEY CONSTRAINED COLOUMN.PREDICT THE OUTCOMEOF
THE BELOW PROCEDURE CREATION.
CREATE OR REPLACE PROCEDURE NEW_EMPLOYEE (P_ENAME VARCHAR2, P_SAL NUMBER)
IS
BEGIN
INSERT INTO EMPLOYEES (ENAME, SALARY) VALUES(P_ENAME, P_SAL);
COMMIT;
END;
ANS: PROCEDURE WILL BE CREATED WITH RUNTIME ERRORS
36. PREDICT THE OUTPUT OF BELOW CODE.DECLARE V_VAR1 NUMBER, V_VAR2 V_VAR1%TYPE;
BEGIN V_VAR 2 = ‘A’ ; DBMS_OUTPUT.PUT_LINE(V_VAR2); END?
ANS: NUMERIC OR VALUE ERROR
37. CONSIDERING THE PRESENCE OF COLOUMN ENAME IN NEW_EMP TABLE,PREDICT THE OUTCOME
OF THE FOLLOWING TRIGGER.CREATE OR REPLACE TRIGGER UPPER_TRIG BEFORE INSERT OR UPDATE
OF ENAME ON NEW_EMP FOR EACH ROW BEGIN NEW.ENAME=UPPER(:OLD.ENMAE); END;
ANS: TRIGGER GETS CREATED SUCCESSFULLY
38. WHICH OF THE FOLLOWING COLLECTION TYPE CAN BE CREATED BOTH SCHEMA LEVEL AND IN
PL/SQL BLOCK?
ANS: NESTED TABLE

39. PREDICT THE OUTPUT OF THE FOLLOWING CODE?DECLARE E_EXCEPTION EXCEPTION BEGIN
DECLARE E_EXCEPTION EXCEPTION BEGIN RAISE E_EXCEPTION END EXCEPTION WHEN E_EXCEPTION
THEN DBMS_OUTPUT.PUT_LINE(“HANDLED IN E_HANDLING EXCEPTION”) WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(“HANDLED IN WHEN OTHERS SECTION”) END?
ANS: HANDLED IN WHEN OTHERS SECTION
40. WHICH PL/SQL COLLECTION TYPE WOULD FIT IN THE BELOW SCENARIO.THE PRESENT STUDENTS
DTA OF DISCIPLINE CSE(COMPUTER SCIENCE AND ENGINEERING) IN A COLLEGE WITH MAXIMUM 60?
ANS: VARRAY
41. CONSIDERING THE PRESENCE OF THE COLOUMN NAMED ‘ENAME ’ AND ‘SAL ‘ IN ‘EMP ’ TABLE
AND ALSO 1234 EMPLOYEE NUMBER ,CHOOSE THE OUTPUT OF THE BELOW PROGRAM.DECLARE
V_ENAME VARCHAR2; V_SAL NUMBER; BEGIN SELECT *12 INTO V_SAL FROM EMP WHERE
EMPNO=1234;SELECT ENAME INTO V_ENAME FROM EMP WHERE
EMPNO=1234;DBMS_OUTPUT.PUT_LINE (V_ENAME);END;?
ANS: EXCEPTION AT LINE NUMBER 5 AS THERE IS NO EMPLOYEE WITH EMPLOYEE NUMBER 1234.
42. WHICH STATEMENT IS TRUE ABOUT TRIGGERS?CHOOSE MOST APPROPRIATE OPTION?
ANS: YOU USE A DATABASE TRIGGER TO FIRE WHEN AN INSERT STATEMENT OCCOURS.
43. WHICH OF THE FOLLOWING PL/SQL COLLECTION WILL ALLOW INDEC BY OF VARCHAR2 DATA
TYPE?
ANS: ASSOCIATIVE ARRAY
44. WHICH OF THE FOLLOWING IS NOT A PREDEFINED EXCEPTION?
ANS: COLLECTION_NULL
45. WHICH OF THE FOLLOWING BUILTIN IS USED TO ASSOCIATE A EXECPTION NAME FOR A NONPREDEFINED EXCEPTION?
ANS: EXCEPTION_INIT()
46. IDENTIFY THE COMPONENT OF A LOB THAT REFERENCES TOWHERE THE LOB VALUE IS PHYSICALLY
STORED.CHOOSE APPROPRIATE OPTION?
ANS: LOB LOCATOR.
47. WHAT WILL HAPPEN IF A FUNCTION IS DEFINED IN PACKAGE BODY WITH OUT DEFINING THE
FUNCTION SPECIFICATION IN PACKAGE SPECIFICATION?
ANS: IT IS CALLED AS PRIVATE FUNCTION AND YOU WILL ABLE TO ACCESS
48. WHICH OF THE FOLLOWING IS THE SQL CODE FOR EXCEPTION WITH NAME TOO_MANY_ROWS?
ANS: - 1422
49. WHICH PROCEDURE CAN BE USED TO CREATE A CUSTOMIZED ERROR MESSAGE?CHOOSE MOST
APPROPRIATE OPTION?
ANS: RAISE_APPLICATION_ERROR
50. WHICH OF THE FOLLOWING IS NOT A VALID INDEX BY DATATYPES IN ASSOCIATIVE ARRAYS?
ANS: DATE
51. HTML VALIDATION REPORT IN PIVOT IS USED BY
ANS:PL/SQL DEVELOPER
52. IN ORACLE PL/SQL ,WHICH OF THE FOLLOWING IS STORED AS A DATABASE OBJECT WHEN ONCE
CREATED?
ANS: ALL
53. WHICH OF THE FOLLOWING IS A BOUNDED AND DENSE COLLECTION IN PL/SQL?

ANS: VAARAY
--54. IN WHICH OF THE FOLLOWING OPTION BEST DESCRIBES TOO_MANY_ROWS NAMED
EXCEPTIONS.CHOOSE APPROPRIATE OPTION?
ANS:PRE-DEFINED EXCEPTION
55. NON-PREDEFINED EXCEPTION CAN BE DEFINED WITH NAME USING .CHOOSE MOST APPROPRIATE
OPTION?
ANS: PRAGMA EXCEPTION_INIT
56. VIEWS CREATE A COPY OF THE DATA FROM THE BASE TABLE?
ANS: TRUE
57. ORACLE PL/SQL SUPPORTS FOLLOWING DATATYPE?
ANS: BOTH (SCALAR AND COMPOSITE)
58. WHICH OF THE FOLLOWING IA VALID NAMED BLOCK IN ORACLE PL/SQL?
ANS: ALL (STORED PROCEDURE, FUNCTION, TRIGGER)
59. WHICH OF THE FOLLOWING COLLECTION IS A SPARSE BY IT’S NATURE?
ANS: ASSOCIATIVE ARRAY
60. WHICH OF THE FOLLOWING PL/SQL COLLECTION IS DENSE THROUGH OUT ITS EXISTENCE IN A
PROGRAM EXECUTION?
ANS :- VARRAY
61. IN ORACLE DATABASE, WHICH TRIGGER CAN BE CREATED ON DATABASE OBJECT TABLE?
ANS :- DATABASE TRIGGER
62. WHICH PL/SQL BUILTIN PROCEDURE IS USED TO RAISE A USER-DEFINED EXCEPTION IN ORACLE
PL/SQL?
ANS :- RAISE_APPLICATION_ERROR()
--63. IN ORACLE DATABASE, WHICH TRIGGER TIMING CAN BE CREATED ON DATABASE OBJECT VIEW?
ANS :- INSTEAD OF
64. WHICH OF THE FOLLOWINF IS A VALID COLLECTION TYPE IN PL/SQL?
ANS :- PL/SQL TABLE
65. WHICH OF THE FOLLOWING IS A BOUNDED COLLECTION IN ORACLE PL/SQL?
ANS :- VARRAY
66. WHICH OF THE FOLLOWING IS A VALID TRIGGER TIMING IN ORACLE PL/SQL?
ANS :- ALL (BEFORE, AFTER, INSTEADOF)
67. WHICH OF THE FOLLOWING IS A VALID PL/SQL COLLECTION BUILTIN?
ANS :- ALL (COUNT, DELETE, TRIM)
--68. IN ORACLE PL/SQL, WE CAN IMPLEMENT POLYMORPHISM USING WHICH OF THE FOLLOWING
COMPONENT?
ANS :69. WHICH OF THE FOLLOWING IS A VALID PREDEFINED EXCEPTION IN PL/SQL?
ANS :- NO_DATA_FOUND
70. WHICH OF THE FOLLOWING IS SERVER SIDE PROGRAM IN PL/SQL?
ANS :- ALL(STORED PROCEDURE, FUNCTION, PACKAGE)

71. WHICH OF THE FOLLOWING IS MANDATORY IN PL/SQL FUNCTION?
ANS :- HAVING RETURN STATEMENT
72. WHICH OF THE FOLLOWING IS A VALID TRIGGER TYPE IN PL/SQL?
ANS :- BOTH(ROW LEVEL AND STATEMENT LEVEL)
73. :NEW AND :OLD QUALIFIERS CAN BE USED ONLY IN ROW LEVEL TRIGGER?
ANS : TRUE
74. WHICH OF THE FOLLOWING APPROACHES ARE USED TO IMPLEMENT DYNAMIC SQL?
ANS : BOTH (USING EXECUTE IMMEDIATE AND USING DBMS_SQL PACKAGE)

1. 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
2. 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
3. Which of the following is considered as the advantage of property
class in Oracle forms?
a)If 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)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.
c)To help maintain consistency in the form. Oracle forms builder provides
a solution of property class.
d)All
Ans:d
4.which of the following is used to capture the type of error?
a)ERROR_TYPE
b)ERROR_NAME
c)ERROR_CATEGORY
d)None
Ans:a
5.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
6.In oracle forms, Which of the following triggers is used to trap the
check box events when the selection is changed?
a)WHEN-CHECKBOX-CHANGED
b)WHEN-BUTTON-CHANGED
c)WHEN-CHECK-CHANGED
d)WHEN-CHECK-BOX-CHANGED
Ans:WHEN-CHECKBOX-CHANGED (a)
7.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
8.What is the default canvas in forms?
a)Content Canvas
b)Stacked Canvas
c)Horizontal Canvas
d)Tab Canvas
Ans:a
9.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-BUTTON-CHANGED
c)WHEN-RADIO-MOVED
d)WHEN-RADIO-BUTTON-CHANGED
Ans:a
10.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
11.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
12.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
13.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
14.Ajay Created a Master Detail Form.
MasterBlock:Customer
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.
a)Deferred: No
Automatic Query: Yes/No
a)Deferred: Yes
Automatic Query: Yes
a)Deferred: Yes
Automatic Query: No
a)Deferred: Yes/No
Automatic Query: Yes
Ans:a
15.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:a
16.Identify 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.
b)WHEN-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
17.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)NO_QUERY_ONLY
c)QUERY_WRITE
d)None
Ans: b
18.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
19.Which of the following options is used to save the form data?
a)Commit_Form;
b)Clear_Form(DO_COMMIT);
c)clear_form(Ask_commit);
d)All
Ans:d
20.There are two forms
1. FORM1
2. 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
21.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
c)Collections
d)All
Ans:a
22.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
23.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?
Form Name:EMP_FORM
Data Block Name: Emp
a)set insert allowed to yes,update allowed to yes. Query Allowed Yes in
the property palette of in the Emp Datablock.
b)set insert allowed to no,update allowed to no. Query Allowed Yes in the
property palette of in the Emp Datablock.
c)set 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
24.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
25.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
26.Which of the following form builder module will have .pll extension?
a)Program Library List
b)Primary Library List
c)PL/SQL Library Module Binary
d)Programming List Library
Ans:c
27.Which of the following module of oracle forms builder a menu can be
attached in the property palette?
a)Form Module
b)PL/SQL Library
c)Object Library
d)All
Ans:a
28.Which of the following builtin is used to invoke an LOV in forms?
a)SHOW_LOV()
b)OPEN_LOV()
c)LOAD_LOV()
d)CALL_LOV()
Ans:a
29.Which of the following builtin is used to invoke an alert in oracle
forms?
a)SHOW_ALERT()
b)CALL_ALERT()
c)LOAD_ALERT()
d)INVOKE_ALERT()
Ans:a

30.Which of the following builtin is used to change the visual attribute
property at runtime?
a)SET_ITEM_PROPERTY()
b)GET_ITEM_PROPERTY()
c)SET_PROPERTY_FORM()
d)SET_ITEM_ATTRIBUTE()
Ans:a
31.Which of the trigger is used to handle oracle form errors?
a)ON-ERROR
b)WHEN-ERROR-OCCUR
c)WHEN-ERROR-RAISED
d)NEW
Ans:a
32.Which option should Lucy choose to display the current date in an item
named TransactionDate in the Transaction Module.
Choose most appropriate option.
a)SYSDATE
b)$$SYSDATE$$
c)$$date$$
d)$$currentdate$$
Ans:c
33.Ram has created a form in which data block is created using wizard,
which of the following builtin is used to perform insertion
operation?
a)FORM_COMMIT;
b)SAVE_COMMIT;
c)COMMIT_FORM;
d)LOG_FORM;
Ans:c
34.Which of the following builtin is used to retrieve the name of the
item that caused the ON-ERROR trigger to fire?
Ans:SYSTEM.TRIGGER_ITEM
35.What is the default value for the Menu Module Property for a form.
Choose the most appropriate option.
a)DEFAULT
b)SMARTBAR
c)DEFAULTSMARTBAR
d)DEFAULT&SMARTBAR
Ans:d
36.Which of the following is a system variable, which holds a value that
indicates whether the current record is the last record in a block?
a)SYSTEM.LAST_RECORD
b)SYSTEM.FINAL_RECORD
c)SYSTEM.RECORD_LAST
d)SYSTEM.LAST_ROW
Ans:a

37.In oracle forms, Which of the following builtin is used to display a
message?
a)MESSAGE()
b)RAISE_MESSAGE()
c)DISPLAY_MESSAGE()
d)None
Ans:a
38.Which of the following is not a correct match for component and
executable?
1)Form:.fmx
2)Menu:.mmx
3)PL/SQL Library:.plx
4)Object Library:.olx
a)1
b)2
c)3
d)4
Ans:d
39.Identify the appropriate display styles of an alert.
a)Stop,Caution,Note
b)Warn,Implify,Stop
c)Caution,Note,Simple
d)None of the above
Ans:a
40.State True or False
In master detail, If the deferred Property is set to 'Yes' and Automatic
Query is set to 'Yes',The associated detail records are retrieved when
the form
cursor is positioned on the detail block.
Ans:True
41.To create a 'CUT' (Which cuts the selected text)menu option in menu
module. Which type of menu has to be selected?
a)Magic
b)Plained
c)Checked
d)All
Ans:a
42.Which of the following builtin is used to change the menu property at
run time?
Ans:SET_MENU_ITEM_PROPERTY
43.Which of the following function is used to create a record group?
a)CREATE_QUERY_FORM_GROUP()
b)CREATE_GROUP_FROM_QUERY()
c)CREATE_GROUP_QUERY()
d)CREATE_QUERY()
Ans:b

44.Which of the following is a system variable that holds the value of
the current record number?
Ans:SYSTEM.CURSOR_RECORD (SYSTEM.CURRENT_RECORD)
45.Which of the following is a valid menu item type in oracle forms?
a)Magic
b)Plain
c)check
d)all
Ans:d
46.In oracle forms what is the return type of SHOW_LOV() builtin?
a)NUMBER
b)Date
c)VARCHAR2
d)Boolean
Ans:d
47.Identify the first step that needs to be performed in order to attach
a custom menu module to a form module.
Choose the most appropriate option.
a)creates the executable of the menu module by compiling the same.
b)Attach the menu module to the appropriate form.
c)Create the executable of the menu module by executing the same.
d)None of the above.
Ans:a
48.Which of the following can be associated only to an item and not to a
module in Oracle forms?
a)Menu
b)Popup Menu
c)Both
d)None
Ans:Menu (ans doubt)
49.State True/False
An alert can have maximum five buttons.
Ans:False
50.Which of the following builtin cannot be used in oracle forms?
a)RAISE_APPLICATION_ERROR()
b)CALL_FORM()
c)DBMS_OUTPUT.PUT_LINE()
d)CLEAR_FORM()
Ans:c
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.
a)when-new-record-instance
b)when-new-item-instance
c)when-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.
b)write 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
b)only 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:SET_ITEM_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?
a)when-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
b)Saving 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?
Ans:When-new-form-instance,EXECUTE_QUERY
58.which of the following trigger can be used to perform datablock level
validation?
Ans:when-new-block-instance
59.which of the following options can be used to raise an error in a form
module?
a)raise_application_error
b)rise trigger_form

c)raise 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?
a)Content 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
b)when-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)Which of the following options are VALID for canvases?
Ans:
1.By default, any canvas created, is assigned at runtime to the window
named WINDOW1
2.Content Canvas can be created with the help of Layout wizard,Layout
Editor and Object Navigator.
3.A tab canvas, made up of one or more tab pages, allows you to group and
display a large amount of related information on a single,dynamic canvas
object.
4.A stacked canvas with raise on entry property set to yes can be
displayed only through navigation or programmatic control.
71)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.
72)Which of the following functions can be accomplished only with the use
of key triggers?
Ans:
1.Changing function keys default functionality
2.Disabling function keys
73)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
74)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
75)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
c)Isolated
d)All
Ans:d
76)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)If 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(ans doubt)
77)which two statements are true of a Query Record Group?(choose two)
a)The record group is associated with a query.
b)The record group can be created only at run time.
c)The record group can be created and modified only at design time.
d)The record group can be created and modified at design time or at run
time.
Ans:AD
78)Which three statements about display items are true?
a)A display item can be a database item.
b)The content of a display item can be read and change programmatically.
c)If a display item is a part of a control block,its calculation mode
property is ignored.
d)A display item does not have a Format mask property,so a text item must
be used where that functionality is required.
e)The content of a display item can be validated using a Key-Next-Item
trigger with the scope of the display item.
f)A display item does not have a Multi-Line Property, so a text item must
be used where the functionality is required.
Ans:ABF
79)which two statements define a static record group?
a)The record group can be created only at run time.
b)The record group is not associated with a query.
c)The record group can be created and modified only at design time.
d)The record group can be created and modified at design time or at run
time.
Ans:BC
80)An application uses a menu that contains a check type menu item. You
want to programmatically toogle the checked
/unchecked state of the check item.
which two built-ins can you use to accomplish this?(Choose two)
a)FIND_ITEM
b)REPLACE_MENU
c)FIND_MENU_ITEM
d)GET_ITEM_PROPERTY

e)SET_ITEM_PROPERTY
f)SET_MENU_ITEM_PROPERTY
g)GET_MENU_ITEM_PROPERTY
Ans: FG
81)How can you programmatically determine which button a user pressed to
respond to an alert?
a)Use the GET_ALERT_PROPERTY function.
b)Use the GET_ALERT_BUTTON_PROPERTY function.
c)Check the value returned by the SHOW_ALERT function to see if it is 1,2
or 3.
d)Check the value returned by the SHOW_ALERT function to see if it is
ALERT_BUTTON1,ALERT_BUTTON2 and ALERT_BUTTON3.
Ans:d
82)Which of the following are the types parameters passed from calling
form?(choose three)
a)GLOBAL
b)SYSTEM
c)PARAMETER
d)LOCAL
Ans:abc
83)Which of the following built in is used to add elements in list item
at run time?
a)ADD_LIST_ELEMENT()
b)ADD_ELEMENT()
c)ADD_LIST_ELEMENTS()
d)ADD_ELEMENTS()
Ans:a
84)Which of the following contains select statement associated with LOV
in oracle forms?
a)RECORD GROUP
b)BLOCK GROUP
c)OBJECT GROUP
d)PLSQL LIBRARY
Ans:a
85)Which of the following item type has to be chosen for displaying more
than 4 options for a single field?
a)TEXT ITEM
b)RADIO BUTTON
c)LIST ITEM
d)ALL
Ans:c
86)In oracle forms, Business Logic is written in which of the following
languages?
a)Java
b)HTML
c)XML
d)PL/SQL

Ans:d
87)which of the following is valid item type in oracle forms?
a)TEXT ITEM
b)RADIO BUTTON
c)LIST ITEM
d)ALL
Ans:d
88)In forms development, Which GUI item needs to be considered for the
fields like GENDER?
a)RADIO BUTTON
b)CHECK BOX
c)TEXT ITEM
d)DISPLAY ITEM
Ans:a
89)Which of the following builtin is used to clear a list in oracle
forms?
a)CLEAR_LIST_ITEM()
b)FLUSH_ITEM()
c)FLUSH_LIST_ITEM()
d)CLEAR_LIST()
Ans:d
90)Which of the following database can oracle forms connect to?
a)Oracle Database
b)Oracle NoSQL database
c)DB2
d)None
Ans:a
91)How many ALERTS can be created on a single form?
a)1
b)2
c)3
d)Any Number
Ans:d
92)What is the difference between LOV and List item?
Ans: LOV displays multi column information where as the list item
displays single column information.
93)Oracle forms are used to develop front applications in oracle Ebusiness rule?
Ans:True
94)Which of the following are the various ways to print a message in
oracle forms?
a)MESSAGE()
b)DISPLAY()
c)PRINT()
d)None
Ans:a

95)Which of the following library can contain objects such as Data
Blocks, Items, Canvases, windows etc.
a)PLSQL library
b)Object Library
c)Object Navigator
d)Data Library
Ans:b
96)Lucifier Created a Login form. When user login, he should get a
BOOKING form where he can book tickets for a movie.
He wrote the following codein When-button-pressed of Login Button.
BEGIN
CALL_FORM('FORM',NO_HIDE,NO_REPLACE,QUERY_ONLY);
END;
Whenever he has logged in and tried booking details for Avengers. However
when he is typing something in booking
form, he is getting an error "Form is running in query only mode" what is
the reason for this?
Ans: Modify the code in login button as
CALL_FORM('FORM',NO_HIDE,NO_REPLACE,NO_QUERY_ONLY);
97)You wish to have certain values initialized in a form when the form is
first opened. Which trigger
will you use? Choose an appropriate option.
a)WHEN-NEW-FORM
b)PRE-FORM
c)PRE-LOGON
d)WHEN-NEW-FORM-INSTANCE
Ans:b
98)Which built in combination we use to create a parameter list and check
the parameter list created successfully?
a)CREATE_PARAMETER_LIST
b)ID_NULL
c)CREATE_QUERY_PARAMETER_LIST
d)ID-NULL
Ans:AB
99)Which are the valid statements about canvases,windows?(choose three)
a)An application may have a single window into which all canvases are
displayed.
b)Canvases are the form components that are used to display items.
c)Canvases and windows are non-form components.
d)The window is the frame through which the canvas is used.
Ans:ABD
100)Which built-in we can use to toggle checked/unchecked state of the
check item?(choose two)
a)FIND_ITEM
b)SET_MENU_ITEM_PROPERTY
c)GET_MENU_ITEM_PROPERTY
d)GET_ITEM_PROPERTY

Ans: BC
101)Which is the valid statements about obj libraries?
a)Object Libraries are saved as part of the form module.
b)Individuals items cannot be placed into an object library.
c)All Object libraries in the current working directory are opened when
the form builder is opened.
d)Using Object libraries can immense network performance...
Ans:C
102)Which property of relation object is used for the coordination
between a Master and Detail Block in
Master-Detail Form. Choose an appropriate option.
a)Join Condition
b)Delete Record Behaviour
c)Deferred
d)None of the above
Ans:a
103)Which are the valid statements about key triggers?(Choose three)
a)Key triggers change the default behaviour of the function key.
b))Key-trigger fires when the key combination of corresponding function..
c)A function key can be disabled by acting NULL trigger.
d)Key-triggers cannot change the default behaviour of the function key.
Ans:abc
104)What is the physical and logical limit of canvases in a form?
a)No limit
b)10-15
c)1-5
d)2-4
Ans:ab
105) Which builtin should be used to invoke one form from another form
so that you can navigate between the two forms?
a)CALL_FORM
b)OPEN_FORM
c)NEW_FORM
d)RUN_FORM
Ans:b
106)While inserting a radio button in form___ no of radio buttons can be
assigned to a radio group. Choose most appropriate option.
a)Four
b)Unlimited
c)Ten
d)None of the above
Ans: b
107)which of the following property can be set using visual Attribute of
oracle forms?
a)Foreground color
b)Background color
c)Font Name

d)All
Ans:d
108)Following builtin is used to change the property of an alert at
runtime?
a)SET_ITEM_PROPERTY()
b)SET_ALERT_PROPERTY()
c)SET_ALERT()
d)NONE
Ans:b
109)Which application trigger is required to be attached to a text item
to display field for every row record being inserted through
oracle form?
Ans:when-new-record-instance
110)Which of the following is the argument value that allows you to only
read the data from base tables?
Ans:QUERY_ONLY
111)which builtin is used to destroy parameter list from the memory?
Ans:DESTROY_PARAMETER_LIST
112)A single block can be connected to multiple database objects like
table,view or synonym.
Ans:true
113)Which is the VALID statement about FRAMES?
a)Frame is not an object with properties.
b)Each frame cannot be associated with a block.
c)Frames cannot be grouped within an object library.
d)Frames are used to visually group data objects or control objects.
Ans:d
114)You wish to implement the logic for changing a text item as noneditable in a form when the form is loaded into the browser.
In which trigger we can implement the logic.
Ans:when-new-form-instance
115)The customer is filling up the ORDER_ENTRY form. Various triggers are
written for the ITEM_DETAILS text field.
What will be the sequence of firing these triggers for the text item?
Ans:pre-text-item,when-new-item-instance,key-next-item,when-validateitem,post-text-item
116)What is the physical and logical limit of toolbar canvases in a form?
a)No limit,10-15
b)No limit,1-5
c)No limit,10
d)Zero limit,10-15
Ans:a (ans doubt)
117)Which is the valid statement about blocks?
a)A block connected to any database object is called control block.
b)A block not connected to any database object is called data aware
block.

c)A block connected to any database object is called data aware block.
d)A block must be connected to only table.
Ans:c
118)Which builtin will copies the value into the object by name you
specify?
a)COPY
b)COPY_CASE
c)CP_PLAN
d)COPY_IN
Ans:a
119)You wish to implement a list item initially with few values for a
column in a data block and then allow the users to enter the values
in the column at runtime, which list items type will allow you to achieve
this behaviour?
a)A poplist
b)A TList
c)A combo box
d)None
Ans:c
120)which of the following functions can be accomplished only with the
use of key triggers?
a)Navigating between blocks
b)Disabling functions keys
c)Validating data
d)Modifying data before it is committed
e)Changing function key's default functionality
Ans:be
121)which of the following system variable returns the record position
status?
Ans:CURSOR_RECORD

Query record group
A query record group is a record group that has an associated SELECT
statement. Query record groups can be created and modified at design time
or at runtime.
Non-query record group
A non-query record group is a group that does not have an associated
query. Non-query record groups can be created and modified only at
runtime.
Static record group
A static record group is not associated with a query. Static record
groups can be created and modified only at design time.
1. 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
2. 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
3. Which of the following is considered as the advantage of property
class in Oracle forms?
a)If 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)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.
c)To help maintain consistency in the form. Oracle forms builder provides
a solution of property class.
d)All
ANS:-d
4.which of the following is used to capture the type of error?
a)ERROR_TYPE
b)ERROR_NAME
c)ERROR_CATEGORY
d)None
ANS:-a
5.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
6.In oracle forms, Which of the following triggers is used to trap the
check box events when the selection is changed?
a)WHEN-CHECKBOX-CHANGED
b)WHEN-BUTTON-CHANGED
c)WHEN-CHECK-CHANGED
d)WHEN-CHECK-BOX-CHANGED
ANS:-WHEN-CHECKBOX-CHANGED (a)
7.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
8.What is the default canvas in forms?
a)Content Canvas
b)Stacked Canvas
c)Horizontal Canvas
d)Tab Canvas
ANS:-a
9.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-BUTTON-CHANGED
c)WHEN-RADIO-MOVED
d)WHEN-RADIO-BUTTON-CHANGED
ANS:-a
10.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
11.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
12.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
13.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

14.Ajay Created a Master Detail Form.
MasterBlock:Customer
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.
a)Deferred: No
Automatic Query: Yes/No
a)Deferred: Yes
Automatic Query: Yes
a)Deferred: Yes
Automatic Query: No
a)Deferred: Yes/No
Automatic Query: Yes
ANS:-a
15.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:-a
16.Identify 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.
b)WHEN-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
17.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)NO_QUERY_ONLY
c)QUERY_WRITE
d)None
ANS:- b
18.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
19.Which of the following options is used to save the form data?
a)Commit_Form;
b)Clear_Form(DO_COMMIT);
c)clear_form(Ask_commit);
d)All
ANS:-d
20.There are two forms
1. FORM1
2. 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
21.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
c)Collections
d)All
ANS:-a
22.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
23.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?
Form Name:EMP_FORM
Data Block Name: Emp
a)set insert allowed to yes,update allowed to yes. Query Allowed Yes in
the property palette of in the Emp Datablock.
b)set insert allowed to no,update allowed to no. Query Allowed Yes in the
property palette of in the Emp Datablock.
c)set 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
24.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
25.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
26.Which of the following form builder module will have .pll extension?
a)Program Library List
b)Primary Library List
c)PL/SQL Library Module Binary
d)Programming List Library
ANS:-c
27.Which of the following module of oracle forms builder a menu can be
attached in the property palette?
a)Form Module
b)PL/SQL Library
c)Object Library
d)All
ANS:-a
28.Which of the following builtin is used to invoke an LOV in forms?
a)SHOW_LOV()
b)OPEN_LOV()

c)LOAD_LOV()
d)CALL_LOV()
ANS:-a
29.Which of the following builtin is used to invoke an alert in oracle
forms?
a)SHOW_ALERT()
b)CALL_ALERT()
c)LOAD_ALERT()
d)INVOKE_ALERT()
ANS:-a
30.Which of the following builtin is used to change the visual attribute
property at runtime?
a)SET_ITEM_PROPERTY()
b)GET_ITEM_PROPERTY()
c)SET_PROPERTY_FORM()
d)SET_ITEM_ATTRIBUTE()
ANS:-a
31.Which of the trigger is used to handle oracle form errors?
a)ON-ERROR
b)WHEN-ERROR-OCCUR
c)WHEN-ERROR-RAISED
d)NEW
ANS:-a
32.Which option should Lucy choose to display the current date in an item
named TransactionDate in the Transaction Module.
Choose most appropriate option.
a)SYSDATE
b)$$SYSDATE$$
c)$$date$$
d)$$currentdate$$
ANS:-c
33.Ram has created a form in which data block is created using wizard,
which of the following builtin is used to perform insertion

operation?
a)FORM_COMMIT;
b)SAVE_COMMIT;
c)COMMIT_FORM;
d)LOG_FORM;
ANS:-c
34.Which of the following builtin is used to retrieve the name of the
item that caused the ON-ERROR trigger to fire?
ANS:-SYSTEM.TRIGGER_ITEM
35.What is the default value for the Menu Module Property for a form.
Choose the most appropriate option.
a)DEFAULT
b)SMARTBAR
c)DEFAULTSMARTBAR
d)DEFAULT&SMARTBAR
ANS:-d
36.Which of the following is a system variable, which holds a value that
indicates whether the current record is the last record in a block?
a)SYSTEM.LAST_RECORD
b)SYSTEM.FINAL_RECORD
c)SYSTEM.RECORD_LAST
d)SYSTEM.LAST_ROW
ANS:-a
37.In oracle forms, Which of the following builtin is used to display a
message?
a)MESSAGE()
b)RAISE_MESSAGE()
c)DISPLAY_MESSAGE()
d)None
ANS:-a
38.Which of the following is not a correct match for component and
executable?
1)Form:.fmx

2)Menu:.mmx
3)PL/SQL Library:.plx
4)Object Library:.olx
a)1
b)2
c)3
d)4
ANS:-d
39.Identify the appropriate display styles of an alert.
a)Stop,Caution,Note
b)Warn,Implify,Stop
c)Caution,Note,Simple
d)None of the above
ANS:-a
40.State True or False
In master detail, If the deferred Property is set to 'Yes' and Automatic
Query is set to 'Yes',The associated detail records are retrieved when
the form
cursor is positioned on the detail block.
ANS:-True
41.To create a 'CUT' (Which cuts the selected text)menu option in menu
module. Which type of menu has to be selected?
a)Magic
b)Plained
c)Checked
d)All
ANS:-a
42.Which of the following builtin is used to change the menu property at
run time?
ANS:-SET_MENU_ITEM_PROPERTY
43.Which of the following function is used to create a record group?
a)CREATE_QUERY_FORM_GROUP()
b)CREATE_GROUP_FROM_QUERY()

c)CREATE_GROUP_QUERY()
d)CREATE_QUERY()
ANS:-b
44.Which of the following is a system variable that holds the value of
the current record number?
ANS:-SYSTEM.CURSOR_RECORD (SYSTEM.CURRENT_RECORD)
45.Which of the following is a valid menu item type in oracle forms?
a)Magic
b)Plain
c)check
d)all
ANS:-d
46.In oracle forms what is the return type of SHOW_LOV() builtin?
a)NUMBER
b)Date
c)VARCHAR2
d)Boolean
ANS:-d
47.Identify the first step that needs to be performed in order to attach
a custom menu module to a form module.
Choose the most appropriate option.
a)creates the executable of the menu module by compiling the same.
b)Attach the menu module to the appropriate form.
c)Create the executable of the menu module by executing the same.
d)None of the above.
ANS:-a
48.Which of the following can be associated only to an item and not to a
module in Oracle forms?
a)Menu
b)Popup Menu
c)Both
d)None
ANS:-Menu (ans doubt)

49.State True/False
An alert can have maximum five buttons.
ANS:-False
50.Which of the following builtin cannot be used in oracle forms?
a)RAISE_APPLICATION_ERROR()
b)CALL_FORM()
c)DBMS_OUTPUT.PUT_LINE()
d)CLEAR_FORM()
ANS:-c
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.
a)when-new-record-instance
b)when-new-item-instance
c)when-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.
b)write 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
b)only 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:-SET_ITEM_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?
a)when-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
b)Saving 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?
ANS:-When-new-form-instance,EXECUTE_QUERY
58.which of the following trigger can be used to perform datablock level
validation?
ANS:-when-new-block-instance
59.which of the following options can be used to raise an error in a form
module?
a)raise_application_error
b)rise trigger_form
c)raise 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?
a)Content 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
b)when-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)Which of the following options are VALID for canvases?
ANS:1.By default, any canvas created, is assigned at runtime to the window
named WINDOW1
2.Content Canvas can be created with the help of Layout wizard,Layout

Editor and Object Navigator.
3.A tab canvas, made up of one or more tab pages, allows you to group and
display a large amount of related information on a single,dynamic canvas
object.
4.A stacked canvas with raise on entry property set to yes can be
displayed only through navigation or programmatic control.
71)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.
72)Which of the following functions can be accomplished only with the use
of key triggers?
ANS:1.Changing function keys default functionality
2.Disabling function keys
73)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
74)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
75)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
c)Isolated
d)All
ANS:-d
76)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)If 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(ans doubt)
77)which two statements are true of a Query Record Group?(choose two)
a)The record group is associated with a query.
b)The record group can be created only at run time.
c)The record group can be created and modified only at design time.
d)The record group can be created and modified at design time or at run
time.
ANS:-AD
78)Which three statements about display items are true?
a)A display item can be a database item.
b)The content of a display item can be read and change programmatically.
c)If a display item is a part of a control block,its calculation mode
property is ignored.
d)A display item does not have a Format mask property,so a text item must
be used where that functionality is required.
e)The content of a display item can be validated using a Key-Next-Item
trigger with the scope of the display item.
f)A display item does not have a Multi-Line Property, so a text item must
be used where the functionality is required.
ANS:-ABF
79)which two statements define a static record group?
a)The record group can be created only at run time.
b)The record group is not associated with a query.
c)The record group can be created and modified only at design time.

d)The record group can be created and modified at design time or at run
time.
ANS:-BC
80)An application uses a menu that contains a check type menu item. You
want to programmatically toogle the checked
/unchecked state of the check item.
which two built-ins can you use to accomplish this?(Choose two)
a)FIND_ITEM
b)REPLACE_MENU
c)FIND_MENU_ITEM
d)GET_ITEM_PROPERTY
e)SET_ITEM_PROPERTY
f)SET_MENU_ITEM_PROPERTY
g)GET_MENU_ITEM_PROPERTY
ANS:- FG
81)How can you programmatically determine which button a user pressed to
respond to an alert?
a)Use the GET_ALERT_PROPERTY function.
b)Use the GET_ALERT_BUTTON_PROPERTY function.
c)Check the value returned by the SHOW_ALERT function to see if it is 1,2
or 3.
d)Check the value returned by the SHOW_ALERT function to see if it is
ALERT_BUTTON1,ALERT_BUTTON2 and ALERT_BUTTON3.
ANS:-d
82)Which of the following are the types parameters passed from calling
form?(choose three)
a)GLOBAL
b)SYSTEM
c)PARAMETER
d)LOCAL
ANS:-abc
83)Which of the following built in is used to add elements in list item
at run time?

a)ADD_LIST_ELEMENT()
b)ADD_ELEMENT()
c)ADD_LIST_ELEMENTS()
d)ADD_ELEMENTS()
ANS:-a
84)Which of the following contains select statement associated with LOV
in oracle forms?
a)RECORD GROUP
b)BLOCK GROUP
c)OBJECT GROUP
d)PLSQL LIBRARY
ANS:-a
85)Which of the following item type has to be chosen for displaying more
than 4 options for a single field?
a)TEXT ITEM
b)RADIO BUTTON
c)LIST ITEM
d)ALL
ANS:-c
86)In oracle forms, Business Logic is written in which of the following
languages?
a)Java
b)HTML
c)XML
d)PL/SQL
ANS:-d
87)which of the following is valid item type in oracle forms?
a)TEXT ITEM
b)RADIO BUTTON
c)LIST ITEM
d)ALL
ANS:-d
88)In forms development, Which GUI item needs to be considered for the

fields like GENDER?
a)RADIO BUTTON
b)CHECK BOX
c)TEXT ITEM
d)DISPLAY ITEM
ANS:-a
89)Which of the following builtin is used to clear a list in oracle
forms?
a)CLEAR_LIST_ITEM()
b)FLUSH_ITEM()
c)FLUSH_LIST_ITEM()
d)CLEAR_LIST()
ANS:-d
90)Which of the following database can oracle forms connect to?
a)Oracle Database
b)Oracle NoSQL database
c)DB2
d)None
ANS:-a
91)How many ALERTS can be created on a single form?
a)1
b)2
c)3
d)Any Number
ANS:-d
92)What is the difference between LOV and List item?
ANS:- LOV displays multi column information where as the list item
displays single column information.
93)Oracle forms are used to develop front applications in oracle Ebusiness rule?
ANS:-True
94)Which of the following are the various ways to print a message in
oracle forms?
a)MESSAGE()

b)DISPLAY()
c)PRINT()
d)None
ANS:-a
95)Which of the following library can contain objects such as Data
Blocks, Items, Canvases, windows etc.
a)PLSQL library
b)Object Library
c)Object Navigator
d)Data Library
ANS:-b
96)Lucifier Created a Login form. When user login, he should get a
BOOKING form where he can book tickets for a movie.
He wrote the following codein When-button-pressed of Login Button.
BEGIN
CALL_FORM('FORM',NO_HIDE,NO_REPLACE,QUERY_ONLY);
END;
Whenever he has logged in and tried booking details for Avengers. However
when he is typing something in booking
form, he is getting an error "Form is running in query only mode" what is
the reason for this?
ANS:- Modify the code in login button as
CALL_FORM('FORM',NO_HIDE,NO_REPLACE,NO_QUERY_ONLY);
97)You wish to have certain values initialized in a form when the form is
first opened. Which trigger
will you use? Choose an appropriate option.
a)WHEN-NEW-FORM
b)PRE-FORM
c)PRE-LOGON
d)WHEN-NEW-FORM-INSTANCE
ANS:-b
98)Which built in combination we use to create a parameter list and check
the parameter list created successfully?

a)CREATE_PARAMETER_LIST
b)ID_NULL
c)CREATE_QUERY_PARAMETER_LIST
d)ID-NULL
ANS:-AB
99)Which are the valid statements about canvases,windows?(choose three)
a)An application may have a single window into which all canvases are
displayed.
b)Canvases are the form components that are used to display items.
c)Canvases and windows are non-form components.
d)The window is the frame through which the canvas is used.
ANS:-ABD
100)Which built-in we can use to toggle checked/unchecked state of the
check item?(choose two)
a)FIND_ITEM
b)SET_MENU_ITEM_PROPERTY
c)GET_MENU_ITEM_PROPERTY
d)GET_ITEM_PROPERTY
ANS:- BC
101)Which is the valid statements about obj libraries?
a)Object Libraries are saved as part of the form module.
b)Individuals items cannot be placed into an object library.
c)All Object libraries in the current working directory are opened when
the form builder is opened.
d)Using Object libraries can immense network performance...
ANS:-C
102)Which property of relation object is used for the coordination
between a Master and Detail Block in
Master-Detail Form. Choose an appropriate option.
a)Join Condition
b)Delete Record Behaviour
c)Deferred
d)None of the above

ANS:-a
103)Which are the valid statements about key triggers?(Choose three)
a)Key triggers change the default behaviour of the function key.
b))Key-trigger fires when the key combination of corresponding function..
c)A function key can be disabled by acting NULL trigger.
d)Key-triggers cannot change the default behaviour of the function key.
ANS:-abc
104)What is the physical and logical limit of canvases in a form?
a)No limit
b)10-15
c)1-5
d)2-4
ANS:-ab
105) Which builtin should be used to invoke one form from another form
so that you can navigate between the two forms?
a)CALL_FORM
b)OPEN_FORM
c)NEW_FORM
d)RUN_FORM
ANS:-b
106)While inserting a radio button in form___ no of radio buttons can be
assigned to a radio group. Choose most appropriate option.
a)Four
b)Unlimited
c)Ten
d)None of the above
ANS:- b
107)which of the following property can be set using visual Attribute of
oracle forms?
a)Foreground color
b)Background color
c)Font Name
d)All

ANS:-d
108)Following builtin is used to change the property of an alert at
runtime?
a)SET_ITEM_PROPERTY()
b)SET_ALERT_PROPERTY()
c)SET_ALERT()
d)NONE
ANS:-b
109)Which application trigger is required to be attached to a text item
to display field for every row record being inserted through
oracle form?
ANS:-when-new-record-instance
110)Which of the following is the argument value that allows you to only
read the data from base tables?
ANS:-QUERY_ONLY
111)which builtin is used to destroy parameter list from the memory?
ANS:-DESTROY_PARAMETER_LIST
112)A single block can be connected to multiple database objects like
table,view or synonym.
ANS:-true
113)Which is the VALID statement about FRAMES?
a)Frame is not an object with properties.
b)Each frame cannot be associated with a block.
c)Frames cannot be grouped within an object library.
d)Frames are used to visually group data objects or control objects.
ANS:-d
114)You wish to implement the logic for changing a text item as noneditable in a form when
the form is loaded into the browser.
In which trigger we can implement the logic.
ANS:-when-new-form-instance
115)The customer is filling up the ORDER_ENTRY form. Various triggers are
written for the ITEM_DETAILS text field.
What will be the sequence of firing these triggers for the text item?
ANS:-pre-text-item,when-new-item-instance,key-next-item,when-validateitem,post-text-item

116)What is the physical and logical limit of toolbar canvases in a form?
a)No limit,10-15
b)No limit,1-5
c)No limit,10
d)Zero limit,10-15
ANS:-a (ans doubt)
117)Which is the valid statement about blocks?
a)A block connected to any database object is called control block.
b)A block not connected to any database object is called data aware
block.
c)A block connected to any database object is called data aware block.
d)A block must be connected to only table.
ANS:-c
118)Which builtin will copies the value into the object by name you
specify?
a)COPY
b)COPY_CASE
c)CP_PLAN
d)COPY_IN
ANS:-a
119)You wish to implement a list item initially with few values for a
column in a data block and then allow the users to enter the values
in the column at runtime, which list items type will allow you to achieve
this behaviour?
a)A poplist
b)A TList
c)A combo box
d)None
ANS:-c
120)which of the following functions can be accomplished only with the
use of key triggers?
a)Navigating between blocks
b)Disabling functions keys

c)Validating data
d)Modifying data before it is committed
e)Changing function key's default functionality
ANS:-be
121)which of the following system variable returns the record position
status?
ANS:-CURSOR_RECORD
Query record group
A query record group is a record group that has an associated SELECT
statement. Query record groups can be created and modified at design time
or at runtime.
Non-query record group
A non-query record group is a group that does not have an associated
query. Non-query record groups can be created and modified only at
runtime.
Static record group
A static record group is not associated with a query. Static record
groups can be created and modified only at design time.

MCQ 2

1. WHICH OF THE FOLLOWING PL SQL COLLECTION HAS TO BE INITIALLY DENSE AND CAN BECOME
SPARSE IF NEEDED?
ANS: NESTED TABLE
2. IDENTIFY THE EXTERNAL LOB CHOOSE MOST APPROPRIATE OPTION?
ANS: BFILE
3. WHICH OF THE FOLLOWING PACKAGE IS USED TO IMPLEMENT DYNAMIC SQL?
ANS: DBMS_SQL
4. WHICH OF THE COLLECTION TYPES ARE USABLE AS COLOUMN DATATYPE IN A TABLE?
ANS: VARRAY AND NESTED TABLE
5. BFILE CAN BE ACCESSED IN BOTH READ AND WRITE MODE SAY TRUE OR FALSE?
ANS: FALSE
6. CONSIDER THE PROCEDURE GIVEN BELOW.
CREATE OR REPLACE PROCEDURE PROC_1 AS

num 1 NUMBER(2);
num2 NUMBER(2);
ans NUMBER(3);
BEGIN
ans = num1+num2;
DBMS _OUTPUT.PUT_LINE(‘SUM IS’|| ANS);
END;
ASSUMING THAT THE APPROPRIATE PROCEDURE IS CREATED SUCCESSFULLY, IDENTIFY THE VALID
OPTION THAT IS USED TO EXECUTE THE PROCEDURE.CHOOSE APPROPRIATE OPTION?
ANS: EXEC PROC_1
7. CONSIDERING THE PRESENCE OF THE COLOUMN NAMED ‘ENAME’ IN ‘EMP’ TABLE AND ALSO 1234
EMPLOYEE NUMBER, CHOOSE THE APPROPRIATE OUTPUT THE GIVEN BELOW.
DECLARE
V_ENAME VARCHAR2;
BEGIN
SELECT ENAME INTO V_ENAME FROM EMP WHERE EMPNO=1234;
DBMS_OUTPUT.PUT_LINE (V_ENAME);
END;/
ANS: ERROR AT LINE 2
8. THE OLD AND NEW QUALIFIERS CAN BE USED IN WHICH TYPE OF TRIGGER? CHOOSE THE MOST
APPROPRIATE OPTION?
ANS: ROW LEVEL DML TRIGGER
9. IN ORACLE PL/SQL , WHICH OF THE FOLLOWING CAN BE USED AS RELATIONAL NOT EQUAL TO
OPERATOR?
ANS: ALL (!=,<>,~= )
10. WHICH OF THE FOLLOWING TYPE OF ORACLE PL/SQL COLLECTION IS USED FOR SPARSE
COLLECTION THROUGH OUT ITS LIFE TIME?

ANS: ASSOCIATED ARRAY
11. CONSIDERING THE PRESENCE OF A TABLE STUDENT WITH COLOUMNS MARKS .
PREDICT THE OUTPUT OF THE BELOW TRIGGER EXECUTION WHEN AN UPDATE OPERATION IS
PERFORMED ON MARKS COLUMN OF STUDENT TABLE (WITH SET SERVEROUTPUT ON)
CREATE OR REPLACE TRIGGER UPDATED_MARKS
AFTER UPDATE ON STUDENT
BEGIN
DBMS_OUTPUT.PUT_LINE (“OLD MARKS ARE:”||:OLD MARKS||”NEW MARKS ARE:”||:NEW MARKS);
END ?
ANS: IT WILL RAISE AN ERROR AS :OLD AND :NEW CANNOT BE USED
14. CONSIDERING THE PRESENCE OF COLOUMNS SALARY,EMPLOYEE_ID IN EMPLOYEES TABLE AND
ABSENCE OF EMPLOYEE WITH EMPLOYEE_ID 100.
PREDICT THE OUTCOME OF THE BELOW FUNCTION CREATION.
CREATE OR REPLACE FUNCTION ANNUALSALARY
RETURN NUMBER
IS
V_ASAL NUMBER;
BEGIN
SELECT SALARY*12 INTO V_ASAL FROM EMPLOYEES WHERE EMPLOYEE_ID=100;
RETURNV_ASAL;
END;
ANS: FUNCTION CREATES WITH COMPILATION ERRORS AS SIZE IS MENTIONED FOR/FUNCTION GETS
CREATED WITH RUNTIME ERRORS
13. WITH RESPECT TO A CONDITION PREDICATE IN A DML TRIGGER.CHOOSE MOST APPROPRIATE
OPTION?
ANS: A CONDITIONAL PREDICATE ALLOWS YOU TO COMBINE SEVERAL DML TRIGGERING EVENTS
INTO ONE
14. WHICH OF THE FOLLOWING IS CORRECT TRIGGER TO CHECK UPDATE ON EMP TABLE BETWEEN
9AM AND 6PM?CHOOSE THE MOST APPROPRIATE OPTION?
ANS: CREATE OR REPLACE TRIGGER EMP_UPDATE_CHECK
BEFORE UPDATE ON EMP
BEGIN
IF(TO_CHAR(SYSDATE. ‘HH24’) BETWEEN ‘9’ AND ‘18’) THEN
RAISE_APPLICATION_ERROR(-2055, ‘MODIFICATION OF EMPLOYEE NOT P**** DURING
BUSINESS HOURS’);
END IF;
END;
/
15. WHICH OF THE FOLLOWING CAN BE A TRIGGERING EVENT FOR A INSTEAD OF TRIGGERIN ORACLE
DATABASE?
ANS: DML
16. WHICH OF THE FOLLOWING CANNOT BE INCLUDED IN A PL/SQL PACKAGE? CHOOSE THE MOST
APPROPRIATE OPTION?
ANS: TRIGGERS
17. WHICH OF THE FOLLOWING PACKAGE IS USED TO PERFORM OPERATIONS ON LOBS?
ANS: DBMS_LOB
18. WHICH PARAMETER MODE IN PL/SQL NEEDS A BIND VARIABLE WHEN PROCEDURE OR FUNCTION

IS EXECUTED AT SCHEMA LEVEL?
ANS: ALL (IN,OUT,OUT IN)

19. HOW MANY TIMES A BEFORE UPDATE ROW LEVEL TRIGGER WILL EXECUTE IF THE UPDATE
STATEMENT IS AFFECTING 10 ROWSIMMEDIATE
ANS: 10
20. ORACLE PL/SQL SUPPORTS FOLLOWING NUM1PES?
ANS: BOTH
21. WHICH OF THE FOLLOWING IS ORACLE PL/SQL COLLECTION CANNOT BE DEFINED AT SCHEMA
LEVEL?
ANS: ASSOCIATIVE ARRAY
22. CONDITIONAL EXECUTION OF A TRIGGER CAN BE ACHIEVED USING THE .............CLAUSE.FILL IN
THE BLANKS WITH AN APPROPRIATE OPTION?
ANS: WHEN
23. WHATS OF THE FOLLOWING IS A VALID EXCEPTION CODE THAT A USER CAN GIVE FOR USER
DEFINED EXCEPTION?
ANS: -2999
24 ..............................ATTRIBUTE IS USED TO DECLARE A VARIABLE FOR HANDLING TABLE RECORDS
AND ALSO FOR AN EXPLICIT CURSOR RECORDS? FILL IN THE BLANK WITH AN APPROPRIATE OPTION?
ANS: %ROWTYPE
25. WHICH OF THE FOLLOWING ABOUT EXISTS METHODS OF PL/SQL COLLECTION IS TRUE?
ANS: RETURNS TRUE IF AND ONLY IF SPECIFIED ELEMENT OF ASSOCIATIVE ARRAY OR VARRAY OR
NESTED TABLE EXITS.
26. WHICH OF THE FOLLOWING STATEMENT IS TRUE FOR REGARDING A DATABASE TRIGGER?CHOOSE
THE MOST APPROPRIATE OPTION?
ANS: A BLOCK OF CODE WHICH IS IMPLICITLY INVOKED UPON OCCURRENCE OF A DATABASE EVENT

27. CAN PROJECT TEAM CUSTOMIZED PRE CONFIGURED VALIDATION RULES IN RA?
ANS: YES
28. WHICH OF THE FOLLOWING TYPE OF EXCEPTION WILL NOT HAVE A BUILTIN EXCEPTION NAME IN
PL/SQL?
ANS: NON PREDEFINED EXCEPTIONS
29. WHICH OF THE FOLLOWING IS/ARE A PREDEFINED EXCEPTION? 1. VALUE_ERROR 2.
INVALID_NUMBER
ANS: BOTH 1 and 2
30. PREDICT THE OUTCOME OF THE BELOW PROCEDURE CREATION.(LINE NUMBERS ARE ONLY FOR
REFERNCE AND NEED TO BE EXCLUDED WHILE CREATION)
1. CREATE OR REPLACE PROCEDURE DROP_TABLE(P_TNAME VARCHAR2)
2. IS
3. BEGIN
4. EXECUTE IMMEDIATE ‘DROP FROM ‘||P_TNAME
5. END;
6. /
ANS: PROCEDURE GETS CREATED WITH COMPILATION ERRORS AS THERE IS AN ERROR AT LINE 4
31. CONSIDER A BIND VARIABLE DECLARED AND VALUE ASSIGNED AS BELOW TWO STATEMENTS.
VARIABLE P_ENO NUMBER;
EXEC :P_ENO=100;

NOW CONSIDER THE BELOW FUNCTION CREATION CODE. CONSIDERING THE PRESENCE OF
COLOUMNS SALARY,EMPLOYEE_ID IN A TABLE EMPLOYEES.PREDICT THE RESULT OF THE FUNCTION
WHEN EXECUTED AFTER ITS CREATION.
CREATE OR REPLACE FUNCTION ANNUALSAL(P_ENO NUMBER)
RETURN NUMBER
IS
V_ASAL NUMBER
BEGIN
SELECT SALARY*12 INTO V_ASAL FROM EMPLOYEES WHERE EMPLOYEE_ID=P_ENO;
RETURN V_ASAL;
END;
ANS: IT WILL RETURN THE ANNUAL SALARY OF AN EMPLOYEE IF….PRESENT.OTHERWISE RAISES AN
EXCEPTION
32. CONSIDERING THE PRESENCE OF A COLOUMN NAMED ‘FIRST_NAME’ IN ’EMP’ TABLE.CHOOSE
THE OUTPUT OF THE BELOW PROGRAM.
1.DECLARE
2. TYPE T1 IS TABLE OF VARCHAR2(20);
3. V1 T1;
4. BEGIN
5. SELECT FIRST_NAME BULK COLLECT INTO V1 FROM EMP;
6. DBMS_OUTPUT.PUT_LINE(V1);
7. END;
ANS: ERROR AT LINE NUMBER 6
33. WHAT IS THE SQLCODE OF EXCEPTION WITH NAME NO_DATA_FOUND?
ANS: 100
34. CONSIDER THE FOLLOWING CODE, PREDICT THE OUT OF THE PROGRAM? DECLARE TYPE NUMLIST
IS TABLE OF NUMBER N NUMLIST= NUMLIST,(10,20,30,40,50,60,70,80,90,100) BEGIN NDELETE(3,6)
END?
ANS : DELETE THE ELEMENTS 3 THROUGH 6
35. CONSIDERING THE PRESENCE OF COLOMNS SALARY, EMPLOYEE_ID, ENAME IN EMPLOYEES
TABLE.WHERE EMPLOYEE_ID IS A PRIMARY KEY CONSTRAINED COLOUMN.PREDICT THE OUTCOMEOF
THE BELOW PROCEDURE CREATION.
CREATE OR REPLACE PROCEDURE NEW_EMPLOYEE (P_ENAME VARCHAR2, P_SAL NUMBER)
IS
BEGIN
INSERT INTO EMPLOYEES (ENAME, SALARY) VALUES(P_ENAME, P_SAL);
COMMIT;
END;
ANS: PROCEDURE WILL BE CREATED WITH RUNTIME ERRORS
36. PREDICT THE OUTPUT OF BELOW CODE.DECLARE V_VAR1 NUMBER, V_VAR2 V_VAR1%TYPE;
BEGIN V_VAR 2 = ‘A’ ; DBMS_OUTPUT.PUT_LINE(V_VAR2); END?
ANS: NUMERIC OR VALUE ERROR
37. CONSIDERING THE PRESENCE OF COLOUMN ENAME IN NEW_EMP TABLE,PREDICT THE OUTCOME
OF THE FOLLOWING TRIGGER.CREATE OR REPLACE TRIGGER UPPER_TRIG BEFORE INSERT OR UPDATE
OF ENAME ON NEW_EMP FOR EACH ROW BEGIN NEW.ENAME=UPPER(:OLD.ENMAE); END;
ANS: TRIGGER GETS CREATED SUCCESSFULLY
38. WHICH OF THE FOLLOWING COLLECTION TYPE CAN BE CREATED BOTH SCHEMA LEVEL AND IN
PL/SQL BLOCK?
ANS: NESTED TABLE

39. PREDICT THE OUTPUT OF THE FOLLOWING CODE?DECLARE E_EXCEPTION EXCEPTION BEGIN
DECLARE E_EXCEPTION EXCEPTION BEGIN RAISE E_EXCEPTION END EXCEPTION WHEN E_EXCEPTION
THEN DBMS_OUTPUT.PUT_LINE(“HANDLED IN E_HANDLING EXCEPTION”) WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(“HANDLED IN WHEN OTHERS SECTION”) END?
ANS: HANDLED IN WHEN OTHERS SECTION
40. WHICH PL/SQL COLLECTION TYPE WOULD FIT IN THE BELOW SCENARIO.THE PRESENT STUDENTS
DTA OF DISCIPLINE CSE(COMPUTER SCIENCE AND ENGINEERING) IN A COLLEGE WITH MAXIMUM 60?
ANS: VARRAY
41. CONSIDERING THE PRESENCE OF THE COLOUMN NAMED ‘ENAME ’ AND ‘SAL ‘ IN ‘EMP ’ TABLE
AND ALSO 1234 EMPLOYEE NUMBER ,CHOOSE THE OUTPUT OF THE BELOW PROGRAM.DECLARE
V_ENAME VARCHAR2; V_SAL NUMBER; BEGIN SELECT *12 INTO V_SAL FROM EMP WHERE
EMPNO=1234;SELECT ENAME INTO V_ENAME FROM EMP WHERE
EMPNO=1234;DBMS_OUTPUT.PUT_LINE (V_ENAME);END;?
ANS: EXCEPTION AT LINE NUMBER 5 AS THERE IS NO EMPLOYEE WITH EMPLOYEE NUMBER 1234.
42. WHICH STATEMENT IS TRUE ABOUT TRIGGERS?CHOOSE MOST APPROPRIATE OPTION?
ANS: YOU USE A DATABASE TRIGGER TO FIRE WHEN AN INSERT STATEMENT OCCOURS.
43. WHICH OF THE FOLLOWING PL/SQL COLLECTION WILL ALLOW INDEC BY OF VARCHAR2 DATA
TYPE?
ANS: ASSOCIATIVE ARRAY
44. WHICH OF THE FOLLOWING IS NOT A PREDEFINED EXCEPTION?
ANS: COLLECTION_NULL
45. WHICH OF THE FOLLOWING BUILTIN IS USED TO ASSOCIATE A EXECPTION NAME FOR A NONPREDEFINED EXCEPTION?
ANS: EXCEPTION_INIT()
46. IDENTIFY THE COMPONENT OF A LOB THAT REFERENCES TOWHERE THE LOB VALUE IS PHYSICALLY
STORED.CHOOSE APPROPRIATE OPTION?
ANS: LOB LOCATOR.
47. WHAT WILL HAPPEN IF A FUNCTION IS DEFINED IN PACKAGE BODY WITH OUT DEFINING THE
FUNCTION SPECIFICATION IN PACKAGE SPECIFICATION?
ANS: IT IS CALLED AS PRIVATE FUNCTION AND YOU WILL ABLE TO ACCESS
48. WHICH OF THE FOLLOWING IS THE SQL CODE FOR EXCEPTION WITH NAME TOO_MANY_ROWS?
ANS: - 1422
49. WHICH PROCEDURE CAN BE USED TO CREATE A CUSTOMIZED ERROR MESSAGE?CHOOSE MOST
APPROPRIATE OPTION?
ANS: RAISE_APPLICATION_ERROR
50. WHICH OF THE FOLLOWING IS NOT A VALID INDEX BY DATATYPES IN ASSOCIATIVE ARRAYS?
ANS: DATE
51. HTML VALIDATION REPORT IN PIVOT IS USED BY
ANS:PL/SQL DEVELOPER
52. IN ORACLE PL/SQL ,WHICH OF THE FOLLOWING IS STORED AS A DATABASE OBJECT WHEN ONCE
CREATED?
ANS: ALL
53. WHICH OF THE FOLLOWING IS A BOUNDED AND DENSE COLLECTION IN PL/SQL?

ANS: VAARAY
--54. IN WHICH OF THE FOLLOWING OPTION BEST DESCRIBES TOO_MANY_ROWS NAMED
EXCEPTIONS.CHOOSE APPROPRIATE OPTION?
ANS:PRE-DEFINED EXCEPTION
55. NON-PREDEFINED EXCEPTION CAN BE DEFINED WITH NAME USING .CHOOSE MOST APPROPRIATE
OPTION?
ANS: PRAGMA EXCEPTION_INIT
56. VIEWS CREATE A COPY OF THE DATA FROM THE BASE TABLE?
ANS: TRUE
57. ORACLE PL/SQL SUPPORTS FOLLOWING DATATYPE?
ANS: BOTH (SCALAR AND COMPOSITE)
58. WHICH OF THE FOLLOWING IA VALID NAMED BLOCK IN ORACLE PL/SQL?
ANS: ALL (STORED PROCEDURE, FUNCTION, TRIGGER)
59. WHICH OF THE FOLLOWING COLLECTION IS A SPARSE BY IT’S NATURE?
ANS: ASSOCIATIVE ARRAY
60. WHICH OF THE FOLLOWING PL/SQL COLLECTION IS DENSE THROUGH OUT ITS EXISTENCE IN A
PROGRAM EXECUTION?
ANS :- VARRAY
61. IN ORACLE DATABASE, WHICH TRIGGER CAN BE CREATED ON DATABASE OBJECT TABLE?
ANS :- DATABASE TRIGGER
62. WHICH PL/SQL BUILTIN PROCEDURE IS USED TO RAISE A USER-DEFINED EXCEPTION IN ORACLE
PL/SQL?
ANS :- RAISE_APPLICATION_ERROR()
--63. IN ORACLE DATABASE, WHICH TRIGGER TIMING CAN BE CREATED ON DATABASE OBJECT VIEW?
ANS :- INSTEAD OF
64. WHICH OF THE FOLLOWINF IS A VALID COLLECTION TYPE IN PL/SQL?
ANS :- PL/SQL TABLE
65. WHICH OF THE FOLLOWING IS A BOUNDED COLLECTION IN ORACLE PL/SQL?
ANS :- VARRAY
66. WHICH OF THE FOLLOWING IS A VALID TRIGGER TIMING IN ORACLE PL/SQL?
ANS :- ALL (BEFORE, AFTER, INSTEADOF)
67. WHICH OF THE FOLLOWING IS A VALID PL/SQL COLLECTION BUILTIN?
ANS :- ALL (COUNT, DELETE, TRIM)
--68. IN ORACLE PL/SQL, WE CAN IMPLEMENT POLYMORPHISM USING WHICH OF THE FOLLOWING
COMPONENT?
ANS :69. WHICH OF THE FOLLOWING IS A VALID PREDEFINED EXCEPTION IN PL/SQL?
ANS :- NO_DATA_FOUND
70. WHICH OF THE FOLLOWING IS SERVER SIDE PROGRAM IN PL/SQL?
ANS :- ALL(STORED PROCEDURE, FUNCTION, PACKAGE)

71. WHICH OF THE FOLLOWING IS MANDATORY IN PL/SQL FUNCTION?
ANS :- HAVING RETURN STATEMENT
72. WHICH OF THE FOLLOWING IS A VALID TRIGGER TYPE IN PL/SQL?
ANS :- BOTH(ROW LEVEL AND STATEMENT LEVEL)
73. :NEW AND :OLD QUALIFIERS CAN BE USED ONLY IN ROW LEVEL TRIGGER?
ANS : TRUE
74. WHICH OF THE FOLLOWING APPROACHES ARE USED TO IMPLEMENT DYNAMIC SQL?
ANS : BOTH (USING EXECUTE IMMEDIATE AND USING DBMS_SQL PACKAGE)