Choose the result of the following sql statement.SELECT hire_dateFROM empwhere to_char(hire_date) > '01-FEB-00';A. 01-APR-00B. 01-OCT-00C. 01-APR-99D. 01-DEC-00

  • Interview Candidate
  • 1
  • 1954

Showing Answers 1 - 1 of 1 Answers

Jim Abraham

  • May 27th, 2006
 

Ans: B

Reason: as 2 strings are compared the first three characters are ignored

the 4th character A/D are less that F of the second string being compared

so only O stands greater that F. Clearly 01-OCT-00 is greater that 01-FEB-00 

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions