Database Administrator (DBA) Question:
Download Questions PDF

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?

Answer:

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

Download Database Administrator (DBA) Interview Questions And Answers PDF

Previous QuestionNext Question
What is an index and How it is implemented in Oracle database?Give two methods you could use to determine what DDL changes have been made.