MM International School
Session 2025-26
Class 11 th Part B Unit 4 Relational Database management System
Practice Worksheet
Multiple Choice Questions.
1. MySQL is an example of a:
a) Operating System
b) Database Management System
c) Programming Language
d) Web Server
2. Which command is used to show all databases in MySQL?
a) SHOW TABLES;
b) SHOW DATABASES;
c) LIST DB;
d) DISPLAY DB;
3. Which SQL statement is used to retrieve data from a table?
a) GET
b) SELECT
c) EXTRACT
d) RETRIEVE
4. Which keyword is used to remove a row from a table?
a) DELETE
b) REMOVE
c) ERASE
d) CLEAR
5. The command to remove a table completely is:
a) DELETE TABLE
b) DROP TABLE
c) CLEAR TABLE
d) REMOVE TABLE
6. A collection of related tables is called:
a) Field
b) Record
c) Database
d) Query
7. Which MySQL clause sorts data?
a) SORT BY
b) ORDER BY
c) GROUP BY
d) ARRANGE
8. A row in a table is also known as:
a) Field
b) Record
c) Column
d) Attribute
9. What is the purpose of the DISTINCT keyword?
a) To delete duplicate records permanently
b) To display only unique values from a column
c) To modify existing records
d) To rename a table
10. Which of the following is a valid SQL data type?
a) NUMBER
b) STRING
c) VARCHAR
d) WORD
11. The LIKE operator is used for:
a) Sorting data
b) Pattern matching
c) Deleting data
d) Inserting data
12. The wildcard for multiple characters in LIKE is:
a) ?
b) %
c) #
d) *
13. Which function returns the total number of rows?
a) SUM()
b) COUNT()
c) AVG()
d) TOTAL()
14. Which command is used to insert data?
a) ADD
b) INSERT INTO
c) PUT INTO
d) CREATE
15. Primary key cannot be:
a) Unique
b) Null
c) Indexed
d) Numeric
16. What does DDL stand for?
a) Data Definition Language
b) Data Derive Language
c) Direct Database Language
d) Data Device Language
17. The SQL command to change an existing value is:
a) UPDATE
b) REPLACE
c) MODIFY
d) CHANGE
18. To rename a column, we use:
a) RENAME COLUMN
b) MODIFY COLUMN
c) ALTER TABLE
d) CHANGE FIELD
19. Which key uniquely identifies each record?
a) Foreign Key
b) Alternate Key
c) Primary Key
d) Super Key
20. What is the meaning of NULL in MySQL?
a) Zero
b) Empty string
c) No value
d) Space
21. The AS keyword in MySQL is used to:
a) Delete a table
b) Rename a column or table temporarily
c) Insert data
d) Sort data
22. Which query returns unique values from a column named `city`?
a) SELECT UNIQUE city FROM students;
b) SELECT ONLY city FROM students;
c) SELECT DISTINCT city FROM students;
d) SELECT city FROM students;
23. A column defined as NOT NULL means:
a) The column must always contain a value
b) The column accepts NULL values
c) The column stores only numbers
d) The column is optional
24. Which SQL command updates the age of a student whose id = 5?
a) UPDATE students SET age = 15 WHERE id = 5;
b) MODIFY students age = 15 WHEN id = 5;
c) CHANGE students SET age = 15 IF id = 5;
d) INSERT INTO students age = 15 WHERE id = 5;
Answer the following questions.
1. What is MySQL? Mention any two features of MySQL.
2. What is the difference between a database and a table?
3. Define the terms: Field, Record, and Tuple.
4. What is a Primary Key? Give an example.
5. What is the difference between DELETE and DROP commands?
6. What is the purpose of the SELECT statement? Give an example.
7. Explain the use of the DISTINCT keyword with an example.
8. What is the ORDER BY clause? How is it used?
9. What is the purpose of the WHERE clause? Write an example query.
10. What is the LIKE operator? Write queries using `%` and `_` wildcards.
11. What are SQL functions? Explain COUNT() with an example.
12. What is the NOT NULL constraint? Why is it used?
13. Write the difference between DDL and DML commands.
14. What is the UPDATE command? Write its syntax.
15. What is the AS keyword used for? Give an example.