What is a pseudo column. Give some examples?

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

(Continued from previous question...)

108. What is a pseudo column. Give some examples?

pseudo columns are used to access object content and other information
examples::
rowid
versions_xid
versions_operation
versions_startscn
versions_endscn
sysdate
systimestamp
rownum
ora_rowscn object_value
level (only in hierarchical queries with connect by user

(Continued on next question...)

Other Job Interview Questions

• Name three advisory statistics you can collect.
• Why is it preferable to create a fewer no. of queries in the data model?
• Diffrence between a “where” clause and a “having” claus
• Audit Trial
• What is the effect of setting the value “CHOOSE” for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?
• When do you use data parameter type?
• What are the benefits of distributed options in databases?
• If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
• Do View contain Data?
• What is the function of Optimizer?
• More...