Wednesday, September 5, 2012

Oracle DBA Interview Questions Part 6



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.
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.
What is an OLE?
 Object Linking & Embedding provides you with the capability to integrate objects from many Windows applications into a single compound document creating integrated applications enables you to use the features form.
Is it possible to modify an external query in a report which contains it?
 No.
Does a grouping done for objects in the layout editor affect the grouping done in the data model editor?
 No.
Can a repeating frame be created without a data group as a base?
No
If a break order is set on a column would it affect columns which are under the column?
 No
Is it possible to set a filter condition in a cross product group in matrix reports?
 No
Do user parameters appear in the data modal editor in 2.5?
 No
Can you pass data parameters to forms?
 No
Is it possible to link two groups inside a cross products after the cross products group has been created?
 no
What are the different modals of windows?
 Modeless windows Modal windows
What are modal windows?
 Modal windows are usually used as dialogs, and have restricted functionality compared to modeless windows. On some platforms for example operators cannot resize, scroll or iconify a modal window.

No comments :

Post a Comment