Chapter Exam

Chapter 12: Structured Query Language (SQL) — Online MCQ Test

Q: Which SQL command is used to create a new table in a database?

Answer: B. CREATE — CREATE is a DDL command used to define and create database objects like tables.

Q: Which of the following is a Data Manipulation Language (DML) command?

Answer: C. INSERT — INSERT is a DML command used to add new records into a table.

Q: Which SQL command is used to change the structure of an existing table?

Answer: A. ALTER — ALTER is a DDL command used to modify the structure of an existing table.

Q: What will be the result of the SQL statement: SELECT * FROM STUDENT WHERE MARKS > 80?

Answer: C. All students whose marks are greater than 80 — The WHERE condition filters and returns only those rows where MARKS is greater than 80.

Q: Which SQL statement is used to give a user permission to insert records into a table?

Answer: A. GRANT INSERT ON table_name TO user_name; — GRANT is used to assign privileges, and INSERT privilege allows adding records into a table.

COMPUTER SCIENCE · CLASS 12th · Tamil Nadu State Board

Practice Chapter 12: Structured Query Language (SQL) with a free chapter-wise online MCQ test for Tamil Nadu State Board CLASS 12th COMPUTER SCIENCE. This chapter covers: Focusing on database operations this chapter introduces SQL syntax and commands. It covers data definition data manipulation and data control language statements for creating table.... AI-generated questions from basic to board-exam level, with instant results and explanations.

Questions

20m

Time Limit

Attempts Left

10 random questions from this chapter (mixed difficulty)
Questions you've seen before won't repeat until the pool resets
You have 20 minutes — exam auto-submits when time is up
Maximum 3 attempts per chapter
Results and explanations shown immediately after submission

New here? Register free — includes 3 free chapter exams.

Chapter 12: Structured Query Language (SQL) — Important Questions & Answers (FAQ)

Frequently asked questions from Tamil Nadu State Board CLASS 12th COMPUTER SCIENCE — Chapter 12: Structured Query Language (SQL), with answers and explanations. These are sample questions; the exam has its own separate question set.

Which SQL command is used to create a new table in a database?

A. INSERT
B. CREATE ✓
C. SELECT
D. UPDATE

Answer: B. CREATE
CREATE is a DDL command used to define and create database objects like tables.

Which of the following is a Data Manipulation Language (DML) command?

A. DROP
B. ALTER
C. INSERT ✓
D. GRANT

Answer: C. INSERT
INSERT is a DML command used to add new records into a table.

Which SQL command is used to change the structure of an existing table?

A. ALTER ✓
B. INSERT
C. SELECT
D. COMMIT

Answer: A. ALTER
ALTER is a DDL command used to modify the structure of an existing table.

What will be the result of the SQL statement: SELECT * FROM STUDENT WHERE MARKS > 80?

A. All students whose marks are 80 or less
B. Only the student with exactly 80 marks
C. All students whose marks are greater than 80 ✓
D. All students in the table

Answer: C. All students whose marks are greater than 80
The WHERE condition filters and returns only those rows where MARKS is greater than 80.

Which SQL statement is used to give a user permission to insert records into a table?

A. GRANT INSERT ON table_name TO user_name; ✓
B. REVOKE INSERT ON table_name FROM user_name;
C. CREATE INSERT ON table_name TO user_name;
D. ALTER INSERT ON table_name TO user_name;

Answer: A. GRANT INSERT ON table_name TO user_name;
GRANT is used to assign privileges, and INSERT privilege allows adding records into a table.

Choose Your Plan & Start Practising

All plans cover every subject and chapter of your registered grade.

Free

₹0

3 exams · 1 year

Start Free →

Active

₹350

12 exams · 1 year

Get Active →

Pro

₹899

Unlimited exams · 1 year

Get Pro →

Compare all plans in detail →