CBSE Class 12 Informatics Practices Question 11 of 41

Review of Database Concepts & SQL — Question 14

Back to all questions
14
Question

Question 14

Which of the following keywords is used to display non-repeated values in MySQL?

  1. Unique
  2. All
  3. Order by
  4. Distinct
Answer

Distinct

Reason — The DISTINCT keyword is used to display the unique values of the column in MySQL.


Source: This question is from Review of Database Concepts & SQL, Informatics Practices — Class 12, CBSE Board.

Key Concepts Covered

This question tests your understanding of the following concepts from the chapter Review of Database Concepts & SQL: Question, Keywords, Display, Non, Repeated, Values. These are fundamental topics in Informatics Practices that students are expected to master as part of the CBSE Class 12 curriculum.

A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Informatics Practices papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.

How to Approach MCQs

Multiple choice questions test your ability to quickly recall facts and apply concepts. Read all options carefully before selecting your answer. Use the process of elimination to rule out clearly incorrect options first. If two options seem similar, look for the subtle difference that makes one more accurate. For numerical MCQs, verify your answer by substituting it back into the problem.

Key Points to Remember

  • Read the question carefully and identify all parts before answering.
  • Use the terminology specific to this subject and chapter.
  • Review the textbook content for this chapter before attempting questions.
  • Practice writing concise, well-structured answers within time limits.

Practice more questions from Review of Database Concepts & SQL — Informatics Practices, Class 12 CBSE