Which statement is true regarding distinct keywords?
Answer options
A
DISTINCT removes duplicate values in the SELECT clause.
B
DISTINCT can be used multiple times in a SELECT statement.
C
DISTINCT applies only to numeric columns.
D
DISTINCT and UNIQUE are different keywords.
Correct answer: DISTINCT removes duplicate values in the SELECT clause.
Explanation
Quick AnswerThe correct answer is DISTINCT removes duplicate values in the SELECT clause. because it directly addresses the core logic of Database Management.
DISTINCT eliminates duplicate rows from the query result.