CBSE Class 11 Informatics Practices Question 8 of 37

Structured Query Language (SQL) — Question 16

Back to all questions
16
Question

Question 16

Rajat wants to delete a primary key constraint from the table. Select an appropriate command to do so.

  1. Create
  2. Alter
  3. Drop
  4. Delete
Answer

Alter

Reason — The ALTER TABLE command is used to delete a primary key constraint from the table.


Source: This question is from Structured Query Language (SQL), Informatics Practices — Class 11, CBSE Board.

Key Concepts Covered

This question tests your understanding of the following concepts from the chapter Structured Query Language (SQL): Question, Rajat, Wants, Delete, Primary, Key. These are fundamental topics in Informatics Practices that students are expected to master as part of the CBSE Class 11 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 Structured Query Language (SQL) — Informatics Practices, Class 11 CBSE