Ibm Discussions

Exam C2090-616 All Questions

View all questions & answers for the C2090-616 exam

Go to Exam

Exam C2090-616 topic 1 question 43 discussion

Actual exam question from IBM's C2090-616

Question #: 43
Topic #: 1

[All C2090-616 Questions]

Consider the following query and the resulting set of data:
SELECT empno, lastname FROM emp WHERE empno BETWEEN "˜000020' and "˜000070'
Result:

If the query below is executed, how many rows will be returned?
SELECT empno FROM emp WHERE empno > "˜000020' AND empno "˜000070'

A. 0
B. 1
C. 3
D. 5

Show Suggested Answer

Suggested Answer: C 🗳️

by deepdg23 at July 9, 2020, 8:15 a.m.

Comments

Submit Cancel

JamesBond

3 years, 4 months ago

Yes syntax error, answer should be "C" typo error.

upvoted 1 times

...

deepdg23

4 years, 4 months ago

The SQL has syntax error wrt answer : C Correct SQL: SELECT empno FROM emp WHERE empno > "˜000020' AND empno < "˜000070'

upvoted 2 times

...