What is Read-Only Transaction?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

193. What is Read-Only Transaction?

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

(Continued on next question...)

Other Job Interview Questions

• What does ROLLBACK do?
• When do you use data parameter type?
• What is difference between UNIQUE constraint and PRIMARY KEY constraint?
• What is the basic data structure that is required for creating an LOV?
• How is link tool operation different bet. reports 2 & 2.5?
• What does the term panel refer to with regarda to pages?
• Can a formula column referred to columns in higher group?
• Compare and contrast TRUNCATE and DELETE for a table.
• How to run SQL script from a Unix Shell?
• Any three PL/SQL Exceptions?
• More...