Can a formula column be obtained through a selec

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

(Continued from previous question...)

249. Can a formula column be obtained through a select statement?

Yes

(Continued on next question...)

Other Job Interview Questions

• What is your typical day like?
• Explain the read, write, and execute permissions on a UNIX directory.
• Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; what error will we get. Why?
• What is forms_DDL?
• What command would you use to create a backup control file?
• Explain the difference between a hot backup and a cold backup and the benefits associated with each.
• What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?
• What is a SNAPSHOT LOG?
• What is an index? How it is implemented in Oracle database?
• What is the use of image_zoom built-in?
• More...