Lakshya Education MCQs

Question: SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.
Options:
A.True
B.False
Answer: Option B

Submit Answer & Explaination

Earn Reward Points by submitting Detailed Explaination for this Question

More Questions on This Topic :

Question 1. Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.
  1.    True
  2.    False
Answer: Option A
Question 2. The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.
  1.    True
  2.    False
Answer: Option A
Question 3. The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.
  1.    True
  2.    False
Answer: Option A
Question 4. Indexes can usually be created for both primary and secondary keys.
  1.    True
  2.    False
Answer: Option A
Question 5. A dynamic view is one whose contents materialize when referenced.
  1.    True
  2.    False
Answer: Option A
Question 6. SQL is a programming language.
  1.    True
  2.    False
Answer: Option B

Check all Questions in this Topic : Click HERE