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?

1. C) To maintain uniqueness of the indexed column(s) ### 2. C) Shared Lock ### 3. B) A collection of descriptions of data objects in a database ### 1. It ensures backups are complete and restorable, preventing data loss. ### 2. Verification ensures data integrity; retrieval ensures quick restoration. ### 3. Monitor usage, analyze trends, set alerts, adjust allocation. Explanation 1. Determine the primary purpose of a database index The primary purpose of a database index is to improve the speed of data retrieval operations on a database table. 2. Identify the lock type for read operations A shared lock allows multiple transactions to read a resource simultaneously without interfering with each other. 3. Define a data dictionary in database management A data dictionary is a collection of descriptions of data objects or items in a database, providing metadata about the structure and organization of the data. 4. Explain the importance of verifying database backups Regular verification ensures that backups are complete, accurate, and can be restored successfully, preventing data loss. 5. Discuss backup verification and retrieval importance Backup verification ensures data integrity, while retrieval ensures that data can be restored quickly and efficiently when needed. 6. Outline key steps in monitoring and resizing storage resources Key steps include regularly checking storage usage, analyzing growth trends, setting alerts for thresholds, and adjusting storage allocation as needed.