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: A,D
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: A,B,F
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: B,C
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: F,G
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: A,B,C
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 thefields 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()
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 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: A,B
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: A,B,D
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: B
[…] « Previous Next » […]