Lot of users are accessing select sysdate from d

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

(Continued from previous question...)

288. 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?

No error message indication will be there.
It displays the current system date.

(Continued on next question...)

Other Job Interview Questions

• What is On-line Redo Log?
• Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
• What is a Schema?
• What is a Tablespace?
• What is Full Backup?
• How is link tool operation different bet. reports 2 & 2.5?
• What is a SNAPSHOT LOG?
• What is the maximum number of triggers, can apply to a single table?
• What is strip sources generate options?
• Give the two types of tables involved in producing a star schema and the type of data they hold.
• More...