Ask a Question
Advertise on boostr.in
Organizational Research By
Surprising Reserch Topic
Question:The EMP table contains the following columns: EMPNO NUMBER(6) HIREDATE DATE Review the following SELECT statement: SELECT empno, TO_DATE('31-DEC-99') - hiredate FROM emp WHERE hiredate BETWEEN '31-DEC-00' AND '31-DEC-01'; What are the results of this statement?
a. ¬†¬†¬†¬†¬†¬†¬†The employee numbers of any employees hired on January 1, 2001 are displayed
b. ¬†¬†¬†¬†¬†¬†¬†Date and numeric values are returned
c. ¬†¬†¬†¬†¬†¬†¬†Only numeric values are returned
d. ¬†¬†¬†¬†¬†¬†¬†The employee numbers of all employees hired before the year 2001 are displayed
e. ¬†¬†¬†¬†¬†¬†¬†Only the employee numbers of all employees are displayed because the BETWEEN operator used in the WHERE clause condition is a number function
Sep 13, 2013
Sep 12, 2013
to add a comment.
Related Hot Questions
Your name to display (optional):
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
To avoid this verification in future, please