WDDBA Exam: Database Monitoring and Administration

1. What set of properties is essential for database transactions, ensuring they are Atomic, Consistent, Isolated, and Durable?

A. SQL properties B. ACID properties C. DML properties D. ETL properties

2. What is the process of organizing databases to reduce redundancy and dependency by breaking down tables into smaller parts?

A. Data Integrity B. Concurrency Control C. Normalization D. Data Independence

3. What is the process of setting up the environment and configuring system parameters to ensure an optimized startup of a database?

A. System configuration for database startup B. Operating system installation C. Backup configuration D. Hardware installation

4. Which of the following is NOT a key consideration for system configuration during database startup?

A. Memory Allocation B. Storage Configuration C. Database Software Installation D. User Interface Design

5. What is a crucial aspect of monitoring for irregularities during database startup and operation, as described in the document?

A. Regularly checking database logs for error messages and warnings. B. Reviewing system parameters once a year. C. Conducting a complete system reboot every week. D. Creating new user accounts on a daily basis.

6. What is the primary purpose of developing and implementing automated monitoring scripts?

A. To perform security audits on the database. B. To perform periodic checks and report deviations from predefined thresholds. C. To automatically resolve all database issues. D. To backup the database automatically.

7. What is a data dictionary?

A. A set of programs used to access database data. B. A table that stores all the data of a database. C. A centralized repository that provides metadata about the data within a database. D. A tool for retrieving data from the database.

8. Which of the following is a type of information that a data dictionary may contain?

A. Actual values of the data B. Integrity constraint information C. The full history of data changes D. The most recent backup file location

9. According to the document, what is an advantage of a data dictionary?

A. It makes it simpler for new users to identify table structures and types. B. It speeds up the process of data retrieval for all queries. C. It automatically backs up the database in case of a system failure. D. It prevents unauthorized users from accessing the database.

10. What is the purpose of "Structure Verification"?

A. To create a new database schema. B. To document database changes over time. C. To audit who has accessed or updated schema objects. D. To ensure that the actual database structure matches the data dictionary.

11. Which type of integrity allows you to define specific business rules that don't fit into the other categories?

A. Entity integrity B. Referential integrity C. User defined integrity D. Domain integrity

12. Which integrity constraint states that all columns in a relational database are in a defined domain?

A. Entity integrity B. Domain integrity C. Referential integrity D. User-defined integrity

13. Which integrity constraint is concerned with the concept of primary keys, ensuring each has to be unique and not null?

A. Entity integrity B. Referential integrity C. Domain integrity D. User-defined integrity

14. What is a database index primarily used for?

A. To create a new table. B. To maintain the uniqueness of a column. C. To reduce the storage space of a table. D. To improve the speed of data retrieval operations.

15. According to the document, which type of column is a good candidate for an index?

A. A column with many of the same values. B. A column used frequently in WHERE clauses. C. A column in a small table with only a few blocks. D. A column that is rarely used for searching.

16. What is the SQL statement used to remove an index from a table?

A. `DELETE INDEX` B. `REMOVE INDEX` C. `DROP INDEX` D. `ALTER TABLE`

17. What is another name for a multiple-field key that uses multiple columns as a unique identifier for a record?

A. Composite key B. Foreign key C. Primary key D. Unique key

18. Which type of lock is used for read operations and allows multiple transactions to read a resource simultaneously?

A. Exclusive locks B. Shared locks C. Write locks D. Table locks

19. What is a situation where transactions are waiting indefinitely for each other to release locks, leading to a standstill?

A. Lock escalation B. Lock timeout C. Deadlock D. Concurrency control

20. What is the purpose of configuring a lock timeout in a database system?

A. To automatically release locks held by a transaction if they are not released within a specified time frame. B. To prevent all transactions from being blocked by a lock. C. To manually resolve deadlocks. D. To increase the number of simultaneous transactions.

21. What is a critical step in verifying the integrity of a database backup?

A. Creating a new backup immediately. B. Checking the file size of the backup file. C. Deleting the oldest backup files to free up space. D. Performing a trial restoration to a test environment.

22. If backups are automated, what should be done to verify their success?

A. Perform a trial restoration every day. B. Implement automated processes to check that backups are completed without errors and are consistent. C. Manually check the backup logs once a month. D. Rely on the automated system and assume it is working correctly.

23. What is the main purpose of monitoring data storage space and resizing it as needed?

A. To archive old data to a separate server. B. To ensure all data is compressed to save space. C. To ensure the ongoing viability and performance of a database system. D. To manually perform backups on a regular schedule.

24. What can be done to avoid frequent auto-growth events and potential performance bottlenecks?

A. Regularly check disk space usage. B. Pre-allocate space for database files based on growth projections. C. Implement auto-growth settings for all database files. D. Implement data archiving strategies.

25. What is a key component of the data update process per organizational guidelines?

A. Disabling all other user access to the database during the update. B. Conducting updates only during off-peak hours. C. Ensuring updates comply with all industry regulations. D. Implementing a formal change management process with required steps and approvals.

WDDBA Exam: Database Monitoring and Administration

Exam Results