Home > Databases > Quizzes > CBSE Class 11 Database Concepts Practice Test
CBSE Class 11 Database Concepts Practice Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 50% • Most missed: “The relation EMPLOYEE has four attributes out of which EMPID and EMP_PHONE alway…”

A database is a collection of DATA/INFORMATION that is organized so that it can be easily accessed, managed and updated.

In a Database, Data is organized into rows, columns and tables, and it is indexed to make it easier to find relevant information.

The syntax to create a database in Class 11: 
create table – command to create a table.
tablename – provide the tablename which you are going to create.
column specification – column specification accepts columnname then datatype and size and contraint name.

CBSE Class 11 Database Concepts Practice Test
Time left 00:00
25 Questions

1. Finding information from a huge volume of papers or deleting/modifying an entry is a difficult task in ____
2. Which of the following is limitation of a File System?
3. Which of the following is most suitable primary key in table “STUDENT”?
4. “Loss of data, in case if attendance register is lost or damaged” This is limitation of _______
5. Those field which can act as a primary key is called _____
6. Number of rows in a table is known as ______
7. Out of one or more candidate keys, the attribute chosen by the database designer to uniquely identify the tuples in a relation is called the _____ of that relation.
8. Which of the following is an advantage of storing data in computerized systems?
9. ______ represents the design or structure of a database.
10. In DBMS, we can retrieve and manipulate data through _______
11. ______ becomes difficult to handle when number of files increases and volume of data also grows.
12. A _____ is a request to a database for obtaining information in a desired way.
13. Meta data is also known as ___________
14. Real life application of DBMS is __________
15. Each column name in a table should be unique.
16. If the structure of a file is changed, all the existing application programs accessing that file also need to be change. Otherwise, the programs may not work correctly. This is called __________
17. Primary key consisting of more than one attribute is called _________.
18. A ___________ can be understood as a container to store data in a computer.
19. Contents of a file can be ____________
20. Data in a file system are accessed through ___________.
21. Sometimes we put certain restrictions or limitations on the type of data that can be inserted in one or more columns of a table. These restriction is called ____________
22. A Foreign Key is an attribute whose value is derived from the _________ of another relation
23. Name a software that can be used to create and manage databases.
24. After loading data, the state or snapshot of the database at any given time is the ___________.
25. The relation EMPLOYEE has four attributes out of which EMPID and EMP_PHONE are the candidates for Primary Key. The database designer choose EMP_ID as primary key then the remaining candidate key (EMP_PHONE) is called _________

⚡ 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.