Oracle11g SQL Fundamentals I:1ZO-051

After describing the JOB_HISTORY table, you discover that the START_DATE and END_DATE columns have a data type of DATE.

Consider the expression END_DATE-START_DATE. (Choose two correct statements.)

A. A value of DATE data type is returned.

B. A value of type NUMBER is returned.

C. A value of type VARCHAR2 is returned.

D. The expression is invalid since arithmetic cannot be performed on columns with DATE data types.

E. The expression represents the days between the END_DATE and START_DATE less one day.


click here to Post your comments and suggestions regarding this page.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License