CUET Computer Science Mock Test Chapter 7 Database Concepts Set A

1. ___________________ maintains data about its students, along with their attendance record and guardian details.

2. Finding information from a huge volume of papers or deleting/modifying an entry is a difficult task in ____

3. Contents of a file can be ____________

4. Redundancy leads to excess storage use and may cause _____.

5. Limitations faced in file system can be overcome by storing the data in a ______ where data are logically related)

6. We know that tables in a database are linked or related through one or more common columns or fields. This common field is called _______

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

8. Which of the following is not the data constraint in DBMS?

9. Query is used to fetch data from __________

10. The most commonly used data model is _______.

11. A row in a table is also known as _________

12. ______ is a set of values from which an attribute can take a value in each row.

13. A special value ________ is used to represent values that are unknown to certain attributes.

14. The class teacher marks daily attendance of the students in the attendance register. The teacher records ‘P’ for present or ‘A’ for absent. If class strength is 50 and total working days in a month are 26, the teacher needs to write _________ records manually in the register every month.

15. Files are stored on the ______ of a computer system.

16. When same data is maintained in different places and do not match. This is called ________

17. DBMS stands for _____________

18. _________ maintains a single repository of data at a centralised location that can be used by multiple users at the same time.

19. _______ are used to ensure accuracy and reliability of data in the database.

20. A ___________ can be understood as a container to store data in a computer.