CUET Computer Science Mock Test Chapter 7 Database Concepts Set B

1. A _____ is a request to a database for obtaining information in a desired way.

2. Identify the limitations of DBMS.

3. In relational data model, tables are called _______________

4. Number of rows in a table is known as ______

5. “Loss of data, in case if attendance register is lost or damaged” This is limitation of _______

6. _____ becomes difficult to handle when number of files increases and volume of data also grows.

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

8. Real life application of DBMS is __________

9. A _____ is data about the data)

10. Suppose Atharv’s Guardian has changed his mobile number, his Guardian Phone number needs to be modified in GUARDIAN file. This is called _____ operation

11. Number of columns in a table is known as ______

12. Which of the following is an advantage of storing data in computerized systems?

13. _______ means same data are duplicated in different places (files).

14. Name a software that can be used to create and manage databases.

15. _______ is also called the visual or logical architecture as it tells us how the data are organised in a database.

16. After loading data, the state or snapshot of the database at any given time is the ___________.

17. ________ is the set of programs used by a DBMS to create database and handle various queries for data retrieval and manipulation.

18. In DBMS, we can retrieve and manipulate data through _______

19. A relation has 3 rows and 5 columns. What is the degree and cardinality of this relation?

20. Which of the following is limitation of a File System?