Multiple Choice
Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?
A) SELECT ONLY V_CODE
FROM PRODUCT;
B) SELECT UNIQUE V_CODE
FROM PRODUCT;
C) SELECT DIFFERENT V_CODE
FROM PRODUCT;
D) SELECT DISTINCT V_CODE
FROM PRODUCT;
Correct Answer:

Verified
Correct Answer:
Verified
Q65: In Oracle, the _ function converts a
Q66: The conditional LIKE must be used in
Q67: Although SQL commands can be grouped together
Q68: A(n) _, also known as a nested
Q69: How many rows would be returned from
Q70: Most SQL implementations yield case-insensitive searches.
Q71: A(n) _ query specifies which data should
Q72: Rows can be grouped into smaller collections
Q74: If a designer wishes to create an
Q75: An alias cannot be used when a