• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Oracle Interview Questions Answers

Question - 101 : - What is a private synonym?

Answer - 101 : - Only its owner can access a private synonym.

Question - 102 : - What is Read-Only Transaction ?

Answer - 102 : - A Read-Only transaction ensures that the results of each query executed in the transaction are consistant with respect to the same point in time.

Question - 103 : - Does a grouping done for objects in the layout editor affect the grouping done in the data model editor?

Answer - 103 : - No.

Question - 104 : - What is the use of Control File ?

Answer - 104 : - When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.

Question - 105 : - What are clusters?

Answer - 105 : - Clusters are groups of one or more tables physically stores together to share common columns and are often used together.

Question - 106 : - What are built-ins associated with timers?

Answer - 106 : - find_timercreate_timerdelete_timer

Question - 107 : - How many windows in a form can have console?

Answer - 107 : - Only one window in a form can display the console, and you cannot change the console assignment at runtime.

Question - 108 : - What are the types of calculated columns available?

Answer - 108 : - Summary, Formula, Placeholder column.

Question - 109 : - When will the data in the snapshot log be used?

Answer - 109 : - We must be able to create a after row trigger on table (i.e., it should be not be already available) After giving table privileges. We cannot specify snapshot log name because oracle uses the name of the master table in the name of the database objects that support its snapshot log. The master table name should be less than or equal to 23 characters. (The table name created will be MLOGS_tablename, and trigger name will be TLOGS name).

Question - 110 : - What is lexical reference? How can it be created?

Answer - 110 : - Lexical reference is place_holder for text that can be embedded in a sql statements. A lexical reference can be created using & before the column or parameter name.

Computer Contributors

krishan
Rajeev Katiyar
Yes Baroda

Share your email for latest updates

Name:
Email:

Our partners