• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Oracle Interview Questions Answers

Question - 71 : - What are the three types of user exits available ?

Answer - 71 : - Oracle Precompiler exits, Oracle call interface, NonOracle user exits.

Question - 72 : - What is a SNAPSHOT LOG ?

Answer - 72 : - A snapshot log is a table in the master database that is associated with the master table. ORACLE uses a snapshot log to track the rows that have been updated in the master table. Snapshot logs are used in updating the snapshots based on the master table.

Question - 73 : - How can we reduce the network traffic?

Answer - 73 : - - Replication of data in distributed environment. - Using snapshots to replicate data. - Using remote procedure calls.

Question - 74 : - What is WHEN-Database-record trigger?

Answer - 74 : - Fires when oracle forms first marks a record as an insert or an update. The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or commit as an insert or update. c generally occurs only when the operators modifies the first item in the record, and after the operator attempts to navigate out of the item.

Question - 75 : - What database block size should I use? (for DBA)

Answer - 75 : - Oracle recommends that your database block size match, or be multiples of your operating system block size. One can use smaller block sizes, but the performance cost is significant. Your choice should depend on the type of application you are running. If you have many small transactions as with OLTP, use a smaller block size. With fewer but larger transactions, as with a DSS application, use a larger block size. If you are using a volume manager, consider your "operating system block size" to be 8K. This is because volume manager products use 8K blocks (and this is not configurable).

Question - 76 : - What is a Redo Log ?

Answer - 76 : - The set of Redo Log files YSDATE,UID,USER or USERENV SQL functions, or the pseudo columns LEVEL or ROWNUM.

Question - 77 : - What is Full Backup ?

Answer - 77 : - A full backup is an operating system backup of all data files, on-line redo log files and control file that constitute ORACLE database and the parameter.

Question - 78 : - When do you use data parameter type?

Answer - 78 : - When the value of a data parameter being passed to a called product is always the name of the record group defined in the current form. Data parameters are used to pass data to products invoked with the run_product built-in subprogram.

Question - 79 : - What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Answer - 79 : - The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.

Question - 80 : - What is the diff. when confine mode is on and when it is off?

Answer - 80 : - When confine mode is on, an object cannot be moved outside its parent in the layout.

Computer Contributors

Rajeev Katiyar
Yes Baroda

Share your email for latest updates


Our partners