CBSE Class 11 Informatics Practices Unit 3 MCQs with Answers | Database Concepts & SQL | 100 Important Questions (2026–27)
Class 11 · Informatics Practices
CBSE Class 11 Informatics Practices Unit 3 MCQs with Answers | Database Concepts & SQL
Preparing for your CBSE Class 11 Informatics Practices examination? Practice these 100 carefully selected MCQs based on the latest CBSE syllabus (2026–27). These questions cover Database Concepts, DBMS, Relational Data Model, SQL Commands, MySQL, Data Types, Data Definition Language (DDL), Data Query Language (DQL), Data Manipulation Language (DML), and competency-based questions.
- Introduction to Database
- Need for Database
- Database Management System (DBMS)
- Relational Data Model
- Domain, Tuple and Relation
- Candidate Key
- Primary Key
- Alternate Key
- Advantages of SQL
- Introduction to MySQL
- Database Creation
- MySQL Data Types
- CREATE DATABASE
- CREATE TABLE
- ALTER TABLE
- DROP DATABASE / TABLE
- SELECT Statement
- WHERE Clause
- Relational Operators
- BETWEEN Operator
- Logical Operators
- IS NULL / IS NOT NULL
- INSERT
- UPDATE
- DELETE
Database Concepts MCQs (Part 1)
Q1. A database is a:
A. Collection of unrelated files
B. Collection of organized data
C. Programming language
D. Spreadsheet only
Show Answer
Answer: B. Collection of organized data
Explanation: A database is an organized collection of related data that can be easily accessed, managed, and updated.
Q2. Which software is used to create and manage databases?
A. Compiler
B. DBMS
C. Interpreter
D. Operating System
Show Answer
Answer: B. DBMS
Explanation: A Database Management System (DBMS) is software that stores, retrieves, and manages databases efficiently.
Q3. The full form of DBMS is:
A. Database Machine System
B. Database Management System
C. Data Base Memory System
D. Database Monitor System
Show Answer
Answer: B. Database Management System
Explanation: DBMS stands for Database Management System.
Q4. Which of the following is an advantage of using a database?
A. Data redundancy is reduced.
B. Data security is improved.
C. Data can be shared easily.
D. All of these
Show Answer
Answer: D. All of these
Explanation: A DBMS reduces redundancy, improves security, supports data sharing, and maintains data integrity.
Q5. Which of the following is an example of a Database Management System?
A. MySQL
B. Python
C. MS Word
D. Photoshop
Show Answer
Answer: A. MySQL
Explanation: MySQL is a popular Relational Database Management System (RDBMS).
Q6. The organized collection of related records is called a:
A. Database
B. Program
C. Folder
D. Compiler
Show Answer
Answer: A. Database
Explanation: A database stores related information in an organized manner for efficient access and management.
Q7. Which of the following is NOT an advantage of a DBMS?
A. Data redundancy
B. Better security
C. Easy backup
D. Data sharing
Show Answer
Answer: A. Data redundancy
Explanation: One of the main objectives of a DBMS is to reduce data redundancy.
Q8. In the relational model, a row in a table is called a:
A. Domain
B. Attribute
C. Tuple
D. Field
Show Answer
Answer: C. Tuple
Explanation: A row in a relational table is known as a tuple or record.
Q9. In the relational model, a column in a table represents a:
A. Tuple
B. Domain
C. Record
D. Database
Show Answer
Answer: B. Domain
Explanation: A domain is the set of permissible values for an attribute (column) in a relation.
Q10. A relation in a relational database is represented as a:
A. Program
B. Table
C. File Folder
D. Spreadsheet Chart
Show Answer
Answer: B. Table
Explanation: In the relational data model, a relation is represented in the form of a table consisting of rows and columns.
Q11. Which key uniquely identifies each record in a table?
A. Candidate Key
B. Alternate Key
C. Primary Key
D. Foreign Key
Show Answer
Answer: C. Primary Key
Explanation: A Primary Key uniquely identifies each record in a table. It cannot contain duplicate or NULL values.
Q12. A candidate key that is not selected as the primary key is called:
A. Foreign Key
B. Composite Key
C. Alternate Key
D. Unique Key
Show Answer
Answer: C. Alternate Key
Explanation: Candidate keys that are not chosen as the primary key are known as Alternate Keys.
Q13. A candidate key is:
A. A key that always contains duplicate values
B. A field that uniquely identifies a record
C. A column that stores only numbers
D. A key used only for sorting
Show Answer
Answer: B. A field that uniquely identifies a record
Explanation: A Candidate Key is an attribute or combination of attributes that can uniquely identify each record in a table.
Q14. Which of the following can NEVER contain duplicate values?
A. Name
B. Address
C. Primary Key
D. Marks
Show Answer
Answer: C. Primary Key
Explanation: Every value in a Primary Key must be unique to identify each record correctly.
Q15. Which key can NEVER contain NULL values?
A. Candidate Key
B. Primary Key
C. Alternate Key
D. Secondary Key
Show Answer
Answer: B. Primary Key
Explanation: A Primary Key must always contain a unique, non-NULL value.
Q16. Which language is used to communicate with relational databases?
A. Python
B. Java
C. SQL
D. HTML
Show Answer
Answer: C. SQL
Explanation: SQL (Structured Query Language) is the standard language used to interact with relational databases.
Q17. The full form of SQL is:
A. Structured Query Language
B. Standard Query Language
C. Structured Question Language
D. Simple Query Language
Show Answer
Answer: A. Structured Query Language
Explanation: SQL stands for Structured Query Language.
Q18. Which of the following is an advantage of SQL?
A. Easy data retrieval
B. Data manipulation
C. Standardized language
D. All of these
Show Answer
Answer: D. All of these
Explanation: SQL is easy to learn, standardized, and supports efficient data retrieval and manipulation.
Q19. Which category of SQL commands is used to create and modify database objects?
A. DML
B. DQL
C. DDL
D. TCL
Show Answer
Answer: C. DDL
Explanation: Data Definition Language (DDL) is used to define database structures such as databases and tables.
Q20. Which SQL command is used to create a new database?
A. CREATE TABLE
B. CREATE DATABASE
C. NEW DATABASE
D. MAKE DATABASE
Show Answer
Answer: B. CREATE DATABASE
Explanation: The CREATE DATABASE command creates a new database in MySQL.
Q21. Which of the following is a valid MySQL data type for storing whole numbers?
A. VARCHAR
B. INT
C. DATE
D. CHAR
Show Answer
Answer: B. INT
Explanation: The INT data type is used to store whole numbers in MySQL.
Q22. Which MySQL data type is used to store variable-length character strings?
A. CHAR
B. VARCHAR
C. INT
D. FLOAT
Show Answer
Answer: B. VARCHAR
Explanation: VARCHAR stores variable-length strings and saves storage space.
Q23. Which data type is used to store dates in MySQL?
A. TIME
B. YEAR
C. DATE
D. DATETIME
Show Answer
Answer: C. DATE
Explanation: The DATE data type stores values in the format YYYY-MM-DD.
Q24. Which SQL command is used to create a new table?
A. NEW TABLE
B. CREATE TABLE
C. MAKE TABLE
D. ADD TABLE
Show Answer
Answer: B. CREATE TABLE
Explanation: The CREATE TABLE command creates a new table in a database.
Q25. Which SQL command is used to permanently delete a table from a database?
A. DELETE TABLE
B. REMOVE TABLE
C. DROP TABLE
D. ERASE TABLE
Show Answer
Answer: C. DROP TABLE
Explanation: The DROP TABLE command permanently removes a table and all its records.
Q26. Which SQL command is used to modify the structure of an existing table?
A. MODIFY TABLE
B. UPDATE TABLE
C. ALTER TABLE
D. CHANGE TABLE
Show Answer
Answer: C. ALTER TABLE
Explanation: The ALTER TABLE command is used to add, delete, or modify columns in an existing table.
Q27. Which SQL command is used to retrieve data from a table?
A. DISPLAY
B. SHOW
C. SELECT
D. GET
Show Answer
Answer: C. SELECT
Explanation: The SELECT statement is used to retrieve records from one or more tables.
Q28. Which clause specifies the table from which data is retrieved?
A. INTO
B. FROM
C. WHERE
D. GROUP BY
Show Answer
Answer: B. FROM
Explanation: The FROM clause specifies the table from which records are selected.
Q29. Which clause is used to filter records based on a condition?
A. HAVING
B. ORDER BY
C. WHERE
D. GROUP BY
Show Answer
Answer: C. WHERE
Explanation: The WHERE clause filters rows that satisfy the specified condition.
Q30. Which SQL statement correctly displays all records from the Student table?
A. SELECT Student;
B. SELECT * Student;
C. SELECT * FROM Student;
D. DISPLAY * FROM Student;
Show Answer
Answer: C. SELECT * FROM Student;
Explanation: The asterisk (*) represents all columns, and the FROM clause specifies the table name.
Q31. Which relational operator is used to check whether two values are equal?
A. =
B. ==
C. !=
D. <>
Show Answer
Answer: A. =
Explanation: In SQL, the = operator is used to compare whether two values are equal.
Q32. Which relational operator is used to check whether two values are not equal in MySQL?
A. ==
B. !=
C. <>
D. Both B and C
Show Answer
Answer: D. Both B and C
Explanation: MySQL supports both != and <> as the "not equal to" operator.
Q33. Which SQL query displays students whose marks are greater than 80?
A. SELECT * FROM Student WHERE Marks > 80;
B. SELECT Student WHERE Marks > 80;
C. SHOW Student Marks > 80;
D. DISPLAY Student WHERE Marks > 80;
Show Answer
Answer: A. SELECT * FROM Student WHERE Marks > 80;
Explanation: The WHERE clause is used to filter records based on a specified condition.
Q34. Which SQL operator is used to specify a range of values?
A. IN
B. BETWEEN
C. LIKE
D. EXISTS
Show Answer
Answer: B. BETWEEN
Explanation: The BETWEEN operator selects values within a specified range (inclusive).
Q35. Which SQL query displays students whose marks are between 60 and 80?
A. SELECT * FROM Student WHERE Marks BETWEEN 60 AND 80;
B. SELECT * FROM Student WHERE Marks = 60 TO 80;
C. SELECT * FROM Student WHERE Marks IN 60-80;
D. SELECT * FROM Student WHERE Marks RANGE 60,80;
Show Answer
Answer: A. SELECT * FROM Student WHERE Marks BETWEEN 60 AND 80;
Explanation: The BETWEEN operator includes both the starting and ending values.
Q36. Which logical operator returns TRUE only when both conditions are TRUE?
A. OR
B. NOT
C. AND
D. XOR
Show Answer
Answer: C. AND
Explanation: The AND operator returns TRUE only if all specified conditions are TRUE.
Q37. Which logical operator returns TRUE if at least one condition is TRUE?
A. AND
B. NOT
C. OR
D. BETWEEN
Show Answer
Answer: C. OR
Explanation: The OR operator returns TRUE when one or more conditions are TRUE.
Q38. Which logical operator reverses the result of a condition?
A. OR
B. AND
C. NOT
D. XOR
Show Answer
Answer: C. NOT
Explanation: The NOT operator returns the opposite Boolean value of a condition.
Q39. Which SQL clause is used in the following query?
SELECT * FROM Student WHERE City = 'Jaipur';
A. HAVING
B. WHERE
C. ORDER BY
D. GROUP BY
Show Answer
Answer: B. WHERE
Explanation: The WHERE clause filters records based on the specified condition.
Q40. Which SQL query displays employees whose salary is greater than 50000 and department is 'IT'?
A. SELECT * FROM Employee WHERE Salary > 50000 AND Department='IT';
B. SELECT * FROM Employee Salary > 50000 Department='IT';
C. SELECT Employee WHERE Salary > 50000;
D. SELECT * Employee Salary > 50000;
Show Answer
Answer: A. SELECT * FROM Employee WHERE Salary > 50000 AND Department='IT';
Explanation: The AND operator combines multiple conditions, and both must be TRUE for a record to be selected.
Q41. Which SQL operator is used to check whether a column contains a NULL value?
A. = NULL
B. IS NULL
C. NULL =
D. == NULL
Show Answer
Answer: B. IS NULL
Explanation: The IS NULL operator is used to find records where a column has no value (NULL).
Q42. Which SQL operator is used to display records where a column does NOT contain NULL values?
A. NOT NULL
B. != NULL
C. IS NOT NULL
D. <> NULL
Show Answer
Answer: C. IS NOT NULL
Explanation: The IS NOT NULL operator retrieves records whose specified column contains a value.
Q43. Which SQL query displays students whose phone number is not available?
A. SELECT * FROM Student WHERE Phone = NULL;
B. SELECT * FROM Student WHERE Phone IS NULL;
C. SELECT * FROM Student WHERE Phone == NULL;
D. SELECT * FROM Student WHERE Phone != NULL;
Show Answer
Answer: B. SELECT * FROM Student WHERE Phone IS NULL;
Explanation: NULL values cannot be compared using = or !=. Use IS NULL instead.
Q44. Which SQL command is used to insert a new record into a table?
A. ADD
B. INSERT
C. UPDATE
D. APPEND
Show Answer
Answer: B. INSERT
Explanation: The INSERT statement adds one or more new records to a table.
Q45. Which SQL statement is used to insert data into a table?
A. INSERT INTO Student VALUES (101, 'Aman', 92);
B. ADD Student VALUES (101, 'Aman', 92);
C. CREATE Student VALUES (101, 'Aman', 92);
D. UPDATE Student VALUES (101, 'Aman', 92);
Show Answer
Answer: A. INSERT INTO Student VALUES (101, 'Aman', 92);
Explanation: INSERT INTO ... VALUES is the correct syntax for adding a new row to a table.
Q46. Which SQL command is used to modify existing records in a table?
A. MODIFY
B. CHANGE
C. UPDATE
D. ALTER
Show Answer
Answer: C. UPDATE
Explanation: The UPDATE command changes the values of existing records in a table.
Q47. Which clause is generally used with the UPDATE statement to modify selected records?
A. GROUP BY
B. WHERE
C. ORDER BY
D. HAVING
Show Answer
Answer: B. WHERE
Explanation: The WHERE clause specifies which records should be updated. Without it, all records are updated.
Q48. Which SQL command is used to remove records from a table?
A. REMOVE
B. DELETE
C. DROP
D. ERASE
Show Answer
Answer: B. DELETE
Explanation: The DELETE statement removes one or more records from a table.
Q49. Which clause should normally be used with the DELETE statement to remove specific records?
A. ORDER BY
B. GROUP BY
C. WHERE
D. LIMIT
Show Answer
Answer: C. WHERE
Explanation: The WHERE clause identifies which records should be deleted. Omitting it deletes all records from the table.
Q50. Which SQL statement updates the marks of the student whose RollNo is 101 to 95?
A. UPDATE Student SET Marks = 95 WHERE RollNo = 101;
B. UPDATE Student Marks = 95 RollNo = 101;
C. MODIFY Student SET Marks = 95;
D. CHANGE Student SET Marks = 95;
Show Answer
Answer: A. UPDATE Student SET Marks = 95 WHERE RollNo = 101;
Explanation: The correct syntax for updating records is UPDATE table_name SET column = value WHERE condition;.
Q51. Which category of SQL commands is used to retrieve data from a database?
A. DDL
B. DML
C. DQL
D. TCL
Show Answer
Answer: C. DQL
Explanation: Data Query Language (DQL) is used to retrieve data from a database. The SELECT statement belongs to DQL.
Q52. Which category of SQL commands includes INSERT, UPDATE, and DELETE?
A. DDL
B. DML
C. DQL
D. TCL
Show Answer
Answer: B. DML
Explanation: Data Manipulation Language (DML) is used to insert, modify, and delete records in a table.
Q53. Which SQL command belongs to DDL?
A. SELECT
B. INSERT
C. CREATE TABLE
D. UPDATE
Show Answer
Answer: C. CREATE TABLE
Explanation: CREATE TABLE is a Data Definition Language (DDL) command used to create a new table.
Q54. Which SQL command belongs to DQL?
A. SELECT
B. DELETE
C. ALTER
D. INSERT
Show Answer
Answer: A. SELECT
Explanation: The SELECT statement is used to retrieve data from one or more tables.
Q55. Which SQL command belongs to DML?
A. DROP
B. CREATE
C. INSERT
D. ALTER
Show Answer
Answer: C. INSERT
Explanation: The INSERT statement adds new records to a table and is a DML command.
Q56. Which SQL command is used to remove an entire database?
A. DELETE DATABASE
B. REMOVE DATABASE
C. DROP DATABASE
D. ERASE DATABASE
Show Answer
Answer: C. DROP DATABASE
Explanation: The DROP DATABASE command permanently removes a database along with all its tables.
Q57. Which SQL command is used to add a new column to an existing table?
A. CREATE COLUMN
B. ALTER TABLE
C. INSERT COLUMN
D. UPDATE TABLE
Show Answer
Answer: B. ALTER TABLE
Explanation: The ALTER TABLE command is used to add, modify, or remove columns from an existing table.
Q58. Which SQL query displays only the Name column from the Student table?
A. SELECT Name Student;
B. SELECT Name FROM Student;
C. SHOW Name Student;
D. DISPLAY Name FROM Student;
Show Answer
Answer: B. SELECT Name FROM Student;
Explanation: The SELECT column_name FROM table_name; statement retrieves only the specified column.
Q59. Which SQL statement displays the Name and Marks columns from the Student table?
A. SELECT Name, Marks FROM Student;
B. SELECT (Name Marks) Student;
C. SHOW Name, Marks Student;
D. DISPLAY Name Marks FROM Student;
Show Answer
Answer: A. SELECT Name, Marks FROM Student;
Explanation: Multiple columns are separated using commas in the SELECT statement.
Q60. Which SQL statement removes all records from the Student table but keeps the table structure intact?
A. DROP TABLE Student;
B. DELETE FROM Student;
C. REMOVE Student;
D. DROP DATABASE Student;
Show Answer
Answer: B. DELETE FROM Student;
Explanation: DELETE FROM Student; removes all records from the table while preserving its structure. In contrast, DROP TABLE removes the entire table.
Q61. Which SQL query displays students whose marks are greater than or equal to 75?
A. SELECT * FROM Student WHERE Marks >= 75;
B. SELECT * Student Marks >= 75;
C. SHOW Student WHERE Marks >= 75;
D. SELECT Student Marks >= 75;
Show Answer
Answer: A. SELECT * FROM Student WHERE Marks >= 75;
Explanation: The >= operator is used to retrieve records whose values are greater than or equal to the specified value.
Q62. Which SQL query displays employees whose salary is less than 30000?
A. SELECT * FROM Employee WHERE Salary < 30000;
B. SELECT Salary < 30000 FROM Employee;
C. SHOW Employee Salary < 30000;
D. DISPLAY Employee WHERE Salary < 30000;
Show Answer
Answer: A. SELECT * FROM Employee WHERE Salary < 30000;
Explanation: The < operator is used with the WHERE clause to filter records having values less than the specified value.
Q63. Which SQL query displays students who belong to the city 'Jaipur' OR 'Delhi'?
A. SELECT * FROM Student WHERE City='Jaipur' OR City='Delhi';
B. SELECT * FROM Student WHERE City='Jaipur' AND City='Delhi';
C. SELECT City FROM Student Jaipur Delhi;
D. SELECT * Student WHERE Jaipur OR Delhi;
Show Answer
Answer: A. SELECT * FROM Student WHERE City='Jaipur' OR City='Delhi';
Explanation: The OR operator returns records if any one of the specified conditions is true.
Q64. Which SQL query displays students whose marks are NOT between 40 and 60?
A. SELECT * FROM Student WHERE Marks NOT BETWEEN 40 AND 60;
B. SELECT * FROM Student WHERE Marks != 40 AND 60;
C. SELECT * FROM Student WHERE Marks OUTSIDE 40,60;
D. SELECT * FROM Student WHERE Marks EXCEPT 40 TO 60;
Show Answer
Answer: A. SELECT * FROM Student WHERE Marks NOT BETWEEN 40 AND 60;
Explanation: The NOT BETWEEN operator selects values outside the specified range.
Q65. Which SQL statement displays all records from the Employee table?
A. SELECT * FROM Employee;
B. SELECT Employee;
C. SHOW * Employee;
D. DISPLAY Employee;
Show Answer
Answer: A. SELECT * FROM Employee;
Explanation: The asterisk (*) represents all columns of the specified table.
Q66. Which SQL statement inserts a new employee into the Employee table?
A. INSERT INTO Employee VALUES (101,'Rahul',45000);
B. ADD Employee VALUES (101,'Rahul',45000);
C. CREATE Employee VALUES (101,'Rahul',45000);
D. UPDATE Employee VALUES (101,'Rahul',45000);
Show Answer
Answer: A. INSERT INTO Employee VALUES (101,'Rahul',45000);
Explanation: The INSERT INTO ... VALUES statement is used to insert a new row into a table.
Q67. Which SQL statement deletes employees whose department is 'HR'?
A. DELETE FROM Employee WHERE Department='HR';
B. DROP Employee WHERE Department='HR';
C. REMOVE Employee Department='HR';
D. DELETE Employee='HR';
Show Answer
Answer: A. DELETE FROM Employee WHERE Department='HR';
Explanation: The DELETE statement removes only those records that satisfy the specified condition.
Q68. Which SQL statement changes the city of RollNo 105 to 'Mumbai'?
A. UPDATE Student SET City='Mumbai' WHERE RollNo=105;
B. CHANGE Student City='Mumbai';
C. MODIFY Student City='Mumbai';
D. ALTER Student SET City='Mumbai';
Show Answer
Answer: A. UPDATE Student SET City='Mumbai' WHERE RollNo=105;
Explanation: The UPDATE statement modifies existing records using the SET and WHERE clauses.
Q69. Which SQL command is used to rename a table or modify its structure?
A. UPDATE TABLE
B. ALTER TABLE
C. MODIFY TABLE
D. CHANGE TABLE
Show Answer
Answer: B. ALTER TABLE
Explanation: The ALTER TABLE command is used to change the structure of an existing table, such as adding, deleting, or modifying columns.
Q70. Which SQL statement is correct to create a table named Student?
A. CREATE TABLE Student (RollNo INT, Name VARCHAR(30));
B. CREATE Student TABLE (RollNo INT, Name VARCHAR(30));
C. NEW TABLE Student (RollNo INT, Name VARCHAR(30));
D. MAKE TABLE Student (RollNo INT, Name VARCHAR(30));
Show Answer
Answer: A. CREATE TABLE Student (RollNo INT, Name VARCHAR(30));
Explanation: The correct syntax for creating a table is CREATE TABLE table_name (column definitions);.
Q71. Aman wants to display only the Name and City of all students from the Student table. Which SQL query should he use?
A. SELECT Name, City FROM Student;
B. SELECT * FROM Student;
C. SHOW Name, City Student;
D. DISPLAY Name, City FROM Student;
Show Answer
Answer: A. SELECT Name, City FROM Student;
Explanation: To retrieve specific columns, list their names after the SELECT keyword, separated by commas.
Q72. Riya wants to display students whose marks are greater than 90. Which SQL query is correct?
A. SELECT * FROM Student WHERE Marks > 90;
B. SELECT Student Marks > 90;
C. SHOW Student WHERE Marks > 90;
D. DISPLAY * Student Marks > 90;
Show Answer
Answer: A. SELECT * FROM Student WHERE Marks > 90;
Explanation: The WHERE clause is used to retrieve records satisfying a given condition.
Q73. A teacher wants to insert a new record into the Student table. Which SQL statement should be used?
A. INSERT INTO Student VALUES (201, 'Neha', 88);
B. CREATE Student VALUES (201, 'Neha', 88);
C. ADD Student VALUES (201, 'Neha', 88);
D. UPDATE Student VALUES (201, 'Neha', 88);
Show Answer
Answer: A. INSERT INTO Student VALUES (201, 'Neha', 88);
Explanation: The INSERT INTO ... VALUES statement is used to add a new record to a table.
Q74. Mohit wants to increase the salary of Employee ID 105 to 60,000. Which SQL statement should he use?
A. UPDATE Employee SET Salary = 60000 WHERE EmpID = 105;
B. CHANGE Employee Salary = 60000;
C. MODIFY Employee Salary = 60000;
D. ALTER Employee SET Salary = 60000;
Show Answer
Answer: A. UPDATE Employee SET Salary = 60000 WHERE EmpID = 105;
Explanation: The UPDATE statement modifies existing records using the SET clause and identifies records with the WHERE clause.
Q75. A database administrator wants to remove all records from the Employee table without deleting the table itself. Which SQL command should be used?
A. DROP TABLE Employee;
B. DELETE FROM Employee;
C. REMOVE Employee;
D. DROP DATABASE Employee;
Show Answer
Answer: B. DELETE FROM Employee;
Explanation: The DELETE statement removes records while keeping the table structure intact.
Q76. Priya wants to display students whose City value is missing. Which SQL query is correct?
A. SELECT * FROM Student WHERE City = NULL;
B. SELECT * FROM Student WHERE City IS NULL;
C. SELECT * FROM Student WHERE City == NULL;
D. SELECT * FROM Student WHERE City != NULL;
Show Answer
Answer: B. SELECT * FROM Student WHERE City IS NULL;
Explanation: The IS NULL operator checks whether a column contains NULL values.
Q77. Which SQL statement correctly creates a database named SchoolDB?
A. CREATE DATABASE SchoolDB;
B. NEW DATABASE SchoolDB;
C. MAKE DATABASE SchoolDB;
D. CREATE DB SchoolDB;
Show Answer
Answer: A. CREATE DATABASE SchoolDB;
Explanation: The correct syntax for creating a database is CREATE DATABASE database_name;.
Q78. A student wants to retrieve only those employees whose department is "Sales" and salary is greater than 40,000. Which SQL query is correct?
A. SELECT * FROM Employee WHERE Department='Sales' AND Salary > 40000;
B. SELECT * FROM Employee WHERE Department='Sales' OR Salary > 40000;
C. SELECT Employee Department='Sales' Salary > 40000;
D. SHOW Employee WHERE Department='Sales';
Show Answer
Answer: A. SELECT * FROM Employee WHERE Department='Sales' AND Salary > 40000;
Explanation: The AND operator returns records only when both conditions are true.
Q79. Which SQL query displays students whose marks lie between 70 and 90 (inclusive)?
A. SELECT * FROM Student WHERE Marks BETWEEN 70 AND 90;
B. SELECT * FROM Student WHERE Marks > 70 < 90;
C. SELECT * FROM Student WHERE Marks RANGE 70,90;
D. SELECT * FROM Student WHERE Marks IN 70 TO 90;
Show Answer
Answer: A. SELECT * FROM Student WHERE Marks BETWEEN 70 AND 90;
Explanation: The BETWEEN operator retrieves values within the specified range, including both boundary values.
Q80. Which SQL statement correctly deletes students whose marks are less than 33?
A. DELETE FROM Student WHERE Marks < 33;
B. DROP Student WHERE Marks < 33;
C. REMOVE Student Marks < 33;
D. DELETE Student Marks < 33;
Show Answer
Answer: A. DELETE FROM Student WHERE Marks < 33;
Explanation: The DELETE statement removes only those records that satisfy the condition specified in the WHERE clause.
Q81. Assertion (A): The SELECT statement is used to retrieve data from a table.
Reason (R): SELECT is a DQL command.
A. Both A and R are true, and R is the correct explanation of A.
B. Both A and R are true, but R is not the correct explanation of A.
C. A is true, but R is false.
D. A is false, but R is true.
Show Answer
Answer: A. Both A and R are true, and R is the correct explanation of A.
Explanation: The SELECT statement belongs to DQL (Data Query Language), whose purpose is to retrieve data from database tables.
Q82. Assertion (A): A PRIMARY KEY uniquely identifies each record in a table.
Reason (R): A PRIMARY KEY cannot contain duplicate or NULL values.
A. Both A and R are true, and R is the correct explanation of A.
B. Both A and R are true, but R is not the correct explanation of A.
C. A is true, but R is false.
D. A is false, but R is true.
Show Answer
Answer: A. Both A and R are true, and R is the correct explanation of A.
Explanation: Since duplicate and NULL values are not allowed, every PRIMARY KEY value uniquely identifies a record.
Q83. Assertion (A): The DELETE statement removes records from a table.
Reason (R): DELETE also removes the table structure.
A. Both A and R are true.
B. Both A and R are false.
C. A is true, but R is false.
D. A is false, but R is true.
Show Answer
Answer: C. A is true, but R is false.
Explanation: DELETE removes records only. The table structure remains unchanged. To remove the table itself, DROP TABLE is used.
Q84. Assertion (A): The BETWEEN operator includes both boundary values.
Reason (R): BETWEEN is used to select values within a specified range.
A. Both A and R are true, and R is the correct explanation of A.
B. Both A and R are true, but R is not the correct explanation of A.
C. A is true, but R is false.
D. A is false, but R is true.
Show Answer
Answer: A. Both A and R are true, and R is the correct explanation of A.
Explanation: The BETWEEN operator retrieves values from the starting value to the ending value, including both limits.
Q85. Which SQL statement correctly retrieves the Name and Marks of students scoring more than 80 marks?
A. SELECT Name, Marks FROM Student WHERE Marks > 80;
B. SELECT Name Marks Student WHERE 80;
C. SHOW Name, Marks FROM Student;
D. SELECT Student Name, Marks;
Show Answer
Answer: A. SELECT Name, Marks FROM Student WHERE Marks > 80;
Explanation: The SELECT statement retrieves specified columns, while the WHERE clause filters the required records.
Q86. Which of the following SQL statements is syntactically correct?
A. CREATE TABLE Student (RollNo INT, Name VARCHAR(30));
B. CREATE Student TABLE (RollNo INT);
C. TABLE CREATE Student (RollNo INT);
D. NEW TABLE Student (RollNo INT);
Show Answer
Answer: A. CREATE TABLE Student (RollNo INT, Name VARCHAR(30));
Explanation: The correct syntax for creating a table is CREATE TABLE table_name (...);.
Q87. Which SQL statement displays employees whose salary is between 40,000 and 60,000 and whose department is 'IT'?
A. SELECT * FROM Employee WHERE Salary BETWEEN 40000 AND 60000 AND Department='IT';
B. SELECT * FROM Employee WHERE Salary=40000 TO 60000;
C. SELECT Employee Salary BETWEEN 40000-60000;
D. SHOW Employee Department='IT';
Show Answer
Answer: A. SELECT * FROM Employee WHERE Salary BETWEEN 40000 AND 60000 AND Department='IT';
Explanation: The query correctly combines the BETWEEN and AND operators.
Q88. Which command should be used to add a new column named Email to the Student table?
A. ALTER TABLE Student ADD Email VARCHAR(50);
B. UPDATE TABLE Student ADD Email;
C. CREATE COLUMN Email;
D. INSERT COLUMN Email;
Show Answer
Answer: A. ALTER TABLE Student ADD Email VARCHAR(50);
Explanation: The ALTER TABLE ... ADD statement is used to add a new column to an existing table.
Q89. Which SQL query retrieves students whose phone numbers are available?
A. SELECT * FROM Student WHERE Phone IS NOT NULL;
B. SELECT * FROM Student WHERE Phone != NULL;
C. SELECT * FROM Student WHERE Phone = NOT NULL;
D. SELECT * FROM Student WHERE Phone <> NULL;
Show Answer
Answer: A. SELECT * FROM Student WHERE Phone IS NOT NULL;
Explanation: The IS NOT NULL operator retrieves records whose specified column contains a value.
Q90. Which of the following statements is correct?
A. DDL commands define the structure of database objects.
B. DML commands create databases.
C. DQL commands insert records.
D. DELETE is a DDL command.
Show Answer
Answer: A. DDL commands define the structure of database objects.
Explanation: DDL commands such as CREATE, ALTER, and DROP define or modify database structures. DML includes INSERT, UPDATE, and DELETE, while DQL includes SELECT.
Q91. Which SQL command is used to create a new database?
A. CREATE DATABASE
B. CREATE TABLE
C. NEW DATABASE
D. ADD DATABASE
Show Answer
Answer: A. CREATE DATABASE
Explanation: The CREATE DATABASE command is used to create a new database in MySQL.
Q92. Which SQL command is used to retrieve all columns from the Student table?
A. SELECT Student;
B. SELECT * FROM Student;
C. SHOW Student;
D. DISPLAY Student;
Show Answer
Answer: B. SELECT * FROM Student;
Explanation: The asterisk (*) represents all columns of the specified table.
Q93. Which SQL statement correctly deletes the Student table permanently?
A. DELETE TABLE Student;
B. DROP TABLE Student;
C. REMOVE TABLE Student;
D. DELETE FROM Student;
Show Answer
Answer: B. DROP TABLE Student;
Explanation: DROP TABLE permanently removes both the table structure and all its data.
Q94. Which SQL clause is used to specify conditions while retrieving records?
A. ORDER BY
B. WHERE
C. GROUP BY
D. HAVING
Show Answer
Answer: B. WHERE
Explanation: The WHERE clause filters records based on specified conditions.
Q95. Which SQL operator is used to combine two or more conditions where all conditions must be TRUE?
A. OR
B. NOT
C. BETWEEN
D. AND
Show Answer
Answer: D. AND
Explanation: The AND operator returns TRUE only when every specified condition is TRUE.
Q96. Which SQL statement correctly updates the city of RollNo 110 to 'Jaipur'?
A. UPDATE Student SET City='Jaipur' WHERE RollNo=110;
B. ALTER Student SET City='Jaipur';
C. MODIFY Student City='Jaipur';
D. CHANGE Student SET City='Jaipur';
Show Answer
Answer: A. UPDATE Student SET City='Jaipur' WHERE RollNo=110;
Explanation: The UPDATE statement modifies existing records, while the WHERE clause identifies which record should be updated.
Q97. Which of the following is not a DDL command?
A. CREATE
B. ALTER
C. DROP
D. INSERT
Show Answer
Answer: D. INSERT
Explanation: INSERT is a DML command used to add records. CREATE, ALTER, and DROP are DDL commands.
Q98. Which key uniquely identifies each record in a relational table?
A. Foreign Key
B. Alternate Key
C. Primary Key
D. Candidate Key
Show Answer
Answer: C. Primary Key
Explanation: A Primary Key uniquely identifies every record and cannot contain duplicate or NULL values.
Q99. Which SQL query displays students whose marks are greater than 50 but less than 80?
A. SELECT * FROM Student WHERE Marks > 50 AND Marks < 80;
B. SELECT * FROM Student WHERE Marks BETWEEN 50 TO 80;
C. SELECT Student Marks 50-80;
D. SHOW Student WHERE Marks > 50 < 80;
Show Answer
Answer: A. SELECT * FROM Student WHERE Marks > 50 AND Marks < 80;
Explanation: Multiple conditions can be combined using the AND operator.
Q100. Which of the following best describes a Database Management System (DBMS)?
A. A programming language used to develop software
B. A software package used to create, manage, and retrieve data efficiently
C. A web browser used to access websites
D. An operating system for computers
Show Answer
Answer: B. A software package used to create, manage, and retrieve data efficiently
Explanation: A Database Management System (DBMS) is software that helps users create, store, organize, retrieve, and manage data efficiently while ensuring data integrity and security.
? Quick Revision
- DBMS is software used to create and manage databases.
- A Primary Key uniquely identifies each record.
- CREATE, ALTER, and DROP are DDL commands.
- INSERT, UPDATE, and DELETE are DML commands.
- SELECT is a DQL command.
- WHERE filters records based on conditions.
- BETWEEN selects values within a specified range.
- IS NULL and IS NOT NULL are used to check NULL values.
- ALTER TABLE modifies the structure of an existing table.
- DROP TABLE removes the table permanently.
? Exam Tip
For CBSE examinations, students should practice writing SQL queries with the correct syntax. Pay special attention to the differences between DDL, DML, and DQL commands, understand the use of the WHERE, BETWEEN, AND, OR, IS NULL, and IS NOT NULL operators, and remember the syntax of CREATE, ALTER, INSERT, UPDATE, DELETE, and SELECT statements, as these are frequently tested in CBSE board examinations.