Breaking News
Loading...
Wednesday 3 April 2013

Oracle Interview Questions and Answers 23

04:27

What is the main diff. bet. Reports 2.0 & Reports 2.5?
Report 2.5 is object oriented.


What are the Built-ins to display the user-named editor?
A user named editor can be displayed programmatically with the built in procedure SHOW-EDITOR, EDIT_TETITEM independent of any particular text item.


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.


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.


What does the term panel refer to with regard to pages?
A panel is the no. of physical pages needed to print one logical page.


What is a master detail relationship?
A master detail relationship is an association between two base table blocks- a master block and a detail block. The relationship between the blocks reflects a primary key to foreign key relationship between the tables on which the blocks are based.


What is a library?
A library is a collection of subprograms including user named procedures, functions and packages.


What is an anchoring object & what is its use? What are the various sub events a mouse double click event involves?
An anchoring object is a print condition object which used to explicitly or implicitly anchor other objects to itself.


Use the add_group_column function to add a column to record group that was created at a design time?
False


What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?
Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.


What is the use of break group? What are the various sub events a mouse double click event involves?
A break group is used to display one record for one group ones. While multiple related records in other group can be displayed.


What tuning indicators can one use? (for DBA)
The following high-level tuning indicators can be used to establish if a database is performing optimally or not:
. Buffer Cache Hit Ratio
Formula: Hit Ratio = (Logical Reads - Physical Reads) / Logical Reads
Action: Increase DB_CACHE_SIZE (DB_BLOCK_BUFFERS prior to 9i) to increase hit ratio
. Library Cache Hit Ratio
Action: Increase the SHARED_POOL_SIZE to increase hit ratio


What tools/utilities does Oracle provide to assist with performance tuning? (for DBA)
Oracle provide the following tools/ utilities to assist with performance monitoring and tuning:
. TKProf
. UTLBSTAT.SQL and UTLESTAT.SQL - Begin and end stats monitoring
. Statspack
. Oracle Enterprise Manager - Tuning Pack


<<Previous 1  2 3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19 
20  21  22  23  24  25 26 27 28 29 30 Next>>



Share This :
Tags:

0 comments:

Post a Comment

 
Toggle Footer