Oracle Interview Questions and Answers
Question - 181 : - What are difference between post database commit and post-form commit?
Answer - 181 : - Post-form commit fires once during the post and commit transactions process, after the database commit occurs. The post-form-commit trigger fires after inserts, updates and deletes have been posted to the database but before the transactions have been finalized in the issuing the command. The post-database-commit trigger fires after oracle forms issues the commit to finalized transactions.
Question - 182 : - What are the different display styles of list items?
Answer - 182 : - Pop_listText_listCombo box
Question - 183 : - Which of the above methods is the faster method?
Answer - 183 : - performing the calculation in the query is faster.
Question - 184 : - With which function of summary item is the compute at options required?
Answer - 184 : - percentage of total functions.
Question - 185 : - What are parameters?
Answer - 185 : - Parameters provide a simple mechanism for defining and setting the valuesof inputs that are required by a form at startup. Form parameters are variables of type char,number,date that you define at design time.
Question - 186 : - What are the three types of user exits available ?
Answer - 186 : - Oracle Precompiler exits, Oracle call interface, NonOracle user exits.
Question - 187 : - How many windows in a form can have console?
Answer - 187 : - Only one window in a form can display the console, and you cannot change the console assignment at runtime.
Question - 188 : - What is an administrative (privileged) user?
Answer - 188 : - Oracle DBAs and operators typically use administrative accounts to manage the database and database instance. An administrative account is a user that is granted SYSOPER or SYSDBA privileges. SYSDBA and SYSOPER allow access to a database instance even if it is not running. Control of these privileges is managed outside of the database via password files and special operating system groups. This password file is created with the orapwd utility.
Question - 189 : - What are the two repeating frame always associated with matrix object?
Answer - 189 : - One down repeating frame below one across repeating frame.
Question - 190 : - What are the master-detail triggers?
Answer - 190 : - On-Check_delete_masterOn_clear_detailsOn_populate_details