Oracle Interview Questions And Answers


Computer Tutorials
Earn Money From Internet
Cheap Freelancers
Ask An Expert

Register Cheap Domain
Data Recovery
Best Mutual Funds
Trading Forex Online
Cheap Web Hosting
Ajax Tutorials
Cheap Cell Phone Plans
Free Mobile Learning
Job Portal
Photoshop Tutorials
Cheap Jewelry
Cheapest Air Travel

Oracle Interview Questions And Answers


Page 58 of 95 If the value in the text item matches one of the values in the
first column of the LOV, validation succeeds, the LOV is not
displayed, and processing continues normally.
If the value in the text item does not match one of the values in
the first column of the LOV, Oracle Forms displays the LOV and uses
the text item value as the search criteria to automatically reduce the
list.

48. What are the built_ins used the display the LOV?

Show_lov
List_values

49. What are the built-ins that are used to Attach an LOV
programmatically to an item?

set_item_property
get_item_property
(by setting the LOV_NAME property)

50. What are the built-ins that are used for setting the LOV
properties at runtime?

get_lov_property
set_lov_property

51. What is a record group?

A record group is an internal Oracle Forms that structure that
hs a column/row framework similar to a database table. However, unlike
database tables, record groups are separate objects that belong to
the form module which they are defined.

52. How many number of columns a record group can have?

A record group can have an unlimited number of columns of type CHAR,
LONG, NUMBER, or DATE provided that the total number of column does
not exceed 64K.

53. What is the Maximum allowed length of Record group Column?

Record group column names cannot exceed 30 characters.

54. What are the different types of Record Groups?

Query Record Groups
NonQuery Record Groups
State Record Groups

55. What is a Query Record Group?

A query record group is a record group that has an associated
SELECT statement. The columns in a query record group derive their
default names, data types, had lengths from the database columns
referenced in the SELECT statement. The records in query record group
are the rows retrieved by the query associated with that record group.