10 Apr, 2007
Database Interview Questions
- How do you call other Oracle Products from Oracle Forms? - Run_product is a built-in, Used to invoke one of the supported oracle tools products and specifies the name of the document or module to be run. If the called product is unavailable at the time of the call, Oracle Forms returns a message to the operator.
- What is the main diff. bet. Reports 2.0 & Reports 2.5? - Report 2.5 is object oriented.
- What are the different file extensions that are created by oracle reports? - Rep file and Rdf file.
- What is strip sources generate options? - Removes the source code from the library file and generates a library files that contains only pcode. The resulting file can be used for final deployment, but can not be subsequently edited in the designer.ex. f45gen module=old_lib.pll userid=scott/tiger strip_source YES output_file
- What is the basic data structure that is required for creating an LOV? - Record Group.
- What is the Maximum allowed length of Record group Column? - Record group column names cannot exceed 30 characters.
- Which parameter can be used to set read level consistency across multiple queries? - Read only
- What are the different types of Record Groups? - Query Record Groups NonQuery Record Groups State Record Groups
- From which designation is it preferred to send the output to the printed? - Previewer
- what are difference between post database commit and post-form commit? - 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.
