Every Book Back multiple-choice question from Structured Query Language (SQL) (12th Standard Computer Science, Samacheer Kalvi) — each with the correct option highlighted and a clear, worked explanation. Free to read in English and Tamil.
Q1
Which SQL commands provide definitions for creating table structures, deleting relations, and modifying relation schemas?
- A. DDLCorrect
- B. DML
- C. DCL
- D. DQL
Explanation. Data Definition Language consists of SQL commands like CREATE, ALTER, and DROP that define, modify, or delete the database structure and schemas.
Q2
Which command lets you change the structure of a table?
- A. SELECT
- B. ORDER BY
- C. MODIFY
- D. ALTERCorrect
Explanation. The ALTER command is a DDL statement used to change the structure of an existing table, such as adding, modifying, or dropping columns.
Q3
Which of the following commands deletes a table along with its structure?
- A. DROPCorrect
- B. DELETE
- C. DELETE ALL
- D. ALTER TABLE
Explanation. The DROP TABLE command is used to completely delete both the table structure and all of its recorded data from the database.
Q4
Queries can be generated using which of the following commands?
- A. SELECTCorrect
- B. ORDER BY
- C. MODIFY
- D. ALTER
Explanation. The SELECT command is the primary Data Query Language statement used to retrieve and query specific data from one or more tables.
Q5
Which clause is used to sort data in a database?
- A. SORT BY
- B. ORDER BYCorrect
- C. GROUP BY
- D. SELECT
Explanation. The ORDER BY clause is used to sort the retrieved records in either ascending or descending order based on specified column values.
About these Structured Query Language (SQL) questions
These are the Book Back multiple-choice questions for Structured Query Language (SQL) from the Tamil Nadu State Board (Samacheer Kalvi) 12th Standard Computer Science syllabus. Each question shows the correct option and an original, step-by-step explanation so you understand the method, not just the answer. Use the answer key above to jump to any question, then take the practice test to check yourself under exam-like conditions.
Frequently asked questions
How many MCQs are there in Structured Query Language (SQL)?
This chapter has 5 book-back multiple-choice questions, each with the correct answer and a step-by-step explanation.
Are these 12th Standard Computer Science MCQs free to practise online?
Yes. Every question, answer and explanation here is free, and you can also take them as a timed practice test.
Where can I find the Structured Query Language (SQL) book-back answers?
The correct option for each question is highlighted on this page with a worked explanation, plus a quick answer-key summary at the top.
