10 Apr, 2007
Database Interview Questions
- What are the different display styles of list items? - Pop_list Text_list Combo box
- Which of the above methods is the faster method? - performing the calculation in the query is faster.
- With which function of summary item is the compute at options required? - percentage of total functions.
- What are parameters? - Parameters provide a simple mechanism for defining and setting the values of inputs that are required by a form at startup. Form parameters are variables of type char, number, date that you define at design time.
- What are the three types of user exits available? - Oracle Precompiler exits, Oracle call interface, NonOracle user exits.
- How many windows in a form can have console? - Only one window in a form can display the console, and you cannot change the console assignment at runtime
- If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated? - Only for 10 records.
- What are the two repeating frame always associated with matrix object? - One down repeating frame below one across repeating frame.
- What are the master-detail triggers? - On-Check_delete_master, On_clear_details, On_populate_details
- What are the different objects that you cannot copy or reference in object groups? - Objects of different modules Another object groups Individual block dependent items Program units.
