Home > Databases > Quizzes > CBSE Class 11 Introduction to SQL Practice Test
CBSE Class 11 Introduction to SQL Practice Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 25% • Most missed: “Write a command to remove primary key of table EMP.”

SQL is an abbreviation for the term Structure Query Language. It is a type of database query language (DQL) that is primarily used for storing data and managing it in the Relational DBMS. This language was the first commercial language introduced for the Relational model of the database by E.

Basically, SQL is a language that is used to manage data that's held in a relational database management system. It uses tables to both manipulate and retrieve information from databases for analysis.

CBSE Class 11 Introduction to SQL Practice Test
Time left 00:00
25 Questions

1. Which of the following is not correct about data type in MySQL?
2. In case we want to rename any column while displaying the output, we can do so by using ______________ in the query.
3. Identify the odd one out in reference to data type in MySQL.
4. Char(n) Specifies character type data of length n where n could be any value from ________.
5. SQL is a case sensitive language.
6. Write a command to remove primary key of table EMP.
7. ________ command that lists names of all the tables within a database.
8. The following query is returning an error. Identify the correct query from the following.
Select salary from emp where name = NULL;
9. What is the cardinality of a table which has ‘N’ columns and ‘M’ tuples in a table?
10. Which of the following command is used to open the database that we want to use?
11. What is the purpose of following query?
ALTER TABLE table_name DROP PRIMARY KEY;
12. Which of the following types of values should be enclosed in single quotes while inserting into table?
13. Which command is used to add an attribute to an existing table.
14. Can we have a CHAR or VARCHAR data type for contact number (mobile, landline)?
15. Write a command to create a database named ‘stock’ in MySQL.
16. What is composite primary key?
17. What is the purpose of following command?
Show tables;
18. We can use ______ statement to remove a database permanently from the system.
19. It is mandatory to define constraint for each attribute of a table.
20. Amit has written the following query in MySQL to insert a record in table ‘Student’ which has degree 6. Read this query carefully and tell that how many NULL values will be inserted in this record?
Insert into student(Rolno, Name, Class, Section) Values (1, NULL, ‘X’, ‘A’);
21. Write a command to delete table ‘Stock’ permanently.
22. Suppose we need to change the size of attribute NAME from VARCHAR(30) to VARCHAR(40) of the SCHOOL table. The MySQL statement will be
23. What is the degree of a table which has ‘N’ columns and ‘M’ tuples in a table?
24. Can we insert two records with the same roll number? Identify the most appropriate option from the following.
25. _______ statement is used to create a database and its tables.

⚡ Recently practiced quizzes in this topic
Live quiz activity
DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers Database Fundamentals Transact-SQL (T-SQL) Practice Test PostgreSQL Fundamentals Test SQL Server Vocab Redis Practice Test (NoSQL) DBMS Basics Practice Test: Indexing and Hashing Database Management System (DBMS) Practice Test: All Topics SQL Fundamentals Test SQL MCQs
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.