master detail relationship-- oracle

How does one backup a database using the export utility? (for DBA)
Oracle exports are "logical" database backups (not physical) as they extract data and logical definitions from the database into a file. Other backup strategies normally back-up the physical data files.
One of the advantages of exports is that one can selectively re-import tables, however one cannot roll-forward from an restored export file. To completely restore a database from an export file one practically needs to recreate the entire database.
Always do full system level exports (FULL=YES). Full exports include more information about the database in the export file than user level exports.

What are the built_ins used the display the LOV? 
Show_lov
List_values

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 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