Chapter Exam

Chapter 8 Introduction to Structured Query Language (SQL) — Online MCQ Test

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

Answer: A. CREATE TABLE — CREATE TABLE is a DDL command used to define a new table structure in a database.

Q: Which SQL command is used to retrieve data from a table?

Answer: B. SELECT — SELECT is used to query and display data from one or more tables.

Q: A student wants to add a new column named Age to an existing table Student. Which SQL command should be used?

Answer: B. ALTER TABLE Student ADD Age — ALTER TABLE with ADD is used to modify the structure of an existing table by adding a column.

Q: Which statement is used to rename a table in SQL in many DBMSs?

Answer: C. ALTER TABLE RENAME TO — Many SQL systems use ALTER TABLE ... RENAME TO to rename an existing table.

Q: Which query is valid to display the top scorer if marks are stored in the table Result?

Answer: A. SELECT * FROM Result ORDER BY Marks DESC; — Ordering by Marks in descending order places the highest marks first, which helps identify the top scorer.

INFORMATICS PRACTICES · Grade 11 · CBSE(NCERT)

Practice Chapter 8 Introduction to Structured Query Language (SQL) with a free chapter-wise online MCQ test for CBSE(NCERT) Grade 11 INFORMATICS PRACTICES. This chapter covers: Introduces SQL for managing relational databases. Covers Data Definition Language (DDL) Data Manipulation Language (DML) creating databases and tables inserting updating deleting r.... 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 8 Introduction to Structured Query Language (SQL) — Important Questions & Answers (FAQ)

Frequently asked questions from CBSE(NCERT) Grade 11 INFORMATICS PRACTICES — Chapter 8 Introduction to 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. CREATE TABLE ✓
B. INSERT INTO
C. SELECT
D. UPDATE

Answer: A. CREATE TABLE
CREATE TABLE is a DDL command used to define a new table structure in a database.

Which SQL command is used to retrieve data from a table?

A. DELETE
B. SELECT ✓
C. DROP
D. ALTER

Answer: B. SELECT
SELECT is used to query and display data from one or more tables.

A student wants to add a new column named Age to an existing table Student. Which SQL command should be used?

A. INSERT INTO Student (Age)
B. ALTER TABLE Student ADD Age ✓
C. UPDATE Student SET Age
D. CREATE TABLE Student Age

Answer: B. ALTER TABLE Student ADD Age
ALTER TABLE with ADD is used to modify the structure of an existing table by adding a column.

Which statement is used to rename a table in SQL in many DBMSs?

A. RENAME TABLE
B. CHANGE TABLE
C. ALTER TABLE RENAME TO ✓
D. MODIFY TABLE NAME

Answer: C. ALTER TABLE RENAME TO
Many SQL systems use ALTER TABLE ... RENAME TO to rename an existing table.

Which query is valid to display the top scorer if marks are stored in the table Result?

A. SELECT * FROM Result ORDER BY Marks DESC; ✓
B. SELECT * FROM Result WHERE Marks MAX;
C. SELECT * FROM Result ORDER BY Marks ASC;
D. SELECT TOP Marks FROM Result;

Answer: A. SELECT * FROM Result ORDER BY Marks DESC;
Ordering by Marks in descending order places the highest marks first, which helps identify the top scorer.