PrepAway - Latest Free Exam Questions & Answers

Which of the following statements would produce the given query result:

Consider a table TAB1 having the following values:
TAB1
—————–COL1 COL2
—- —-A 10
B 20
C 30
A 10
D 40
C 20
Consider the result of a given query:
COL1
—-A
B
C
D

Which of the following statements would produce the given query result:

PrepAway - Latest Free Exam Questions & Answers

A.
SELECT COL1 FROM TAB1 ORDER BY COL1 FETCH FIRST 4 ROWS ONLY

B.
SELECT COL1 FROM TAB1 FETCH FIRST 4 ROWS ONLY

C.
SELECT DISTINCT COL1 FROM TAB1

D.
SELECT UNIQUE COL1 FROM TAB1

Explanation:


Leave a Reply