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?

Database Administrator (DBA) Interview Question
Database Administrator (DBA) Interview Question

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.