Chapter 8 Introduction to Structured Query Language (SQL) — Online MCQ Test
INFORMATICS PRACTICES · Grade 11 · CBSE(NCERT)
Practice Chapter 8 Introduction to Structured Query Language (SQL) with a free chapter-wise online MCQ test.
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.
Chapter 8 Introduction to Structured Query Language (SQL) — Important Questions & Answers
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.
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.
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.
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.
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.
Ordering by Marks in descending order places the highest marks first, which helps identify the top scorer.