Self-check 2
Part-I multiple Choice
1. What is the primary purpose of a database index?
A) To reduce storage space usage B) to enforce data integrity constraints
C) To maintain uniqueness of the indexed column(s) D)To create a backup of the database
2. Which type of lock is used for read operations , allowing multiple transactions to read a resource
simultaneously?
A) Exclusive Lock
B) Write Lock
C) Shared Lock
D) Read Lock
3. What is a data dictionary in the context of database management?
A) A dictionary containing words and their meanings
B) A collection of descriptions of data objects in a database
C) A tool for spell-checking in databases
D) A data backup file
Part-II Give short answer
1. Why is it crucial to regularly verify the integrity of database backups?
2. Briefly explain the importance of backup verification and retrieval in data management.
3. What are some key steps in monitoring and resizing storage resources in a database system?