Database Administration (DataSys+) College-Level Quiz

1. What does CAP theorem state about distributed database systems?

Systems can guarantee all three: Consistency, Availability, Partition tolerance

Systems can only guarantee two of three: Consistency, Availability, Partition tolerance

Consistency is always sacrificed in distributed systems

Partition tolerance is impossible to achieve

2. Which of the following best describes data redundancy in databases?

Storing the same data in multiple locations intentionally

Having duplicate data due to poor design that reduces integrity

Creating backup copies of the entire database

Using multiple servers for load balancing

Submit

4. What is the primary function of database monitoring?

Track system performance and detect issues before they impact users

Prevent unauthorized access to the building

Record all employee activities

Limit the number of database connections

Submit

6. Which of the following is a common sign of poor database performance?

Frequent slow queries and high CPU usage

Too many users accessing the database

Database size exceeding 1 GB

Using multiple tables in queries

Submit

8. What is query optimization primarily concerned with?

Writing longer SQL statements

Minimizing execution time and resource consumption

Increasing the number of joins in queries

Storing more data in the database

9. Which backup method captures the entire database at a specific point in time?

Incremental backup

Differential backup

Full backup

Snapshot backup

Submit

11. What is the primary purpose of database normalization?

Eliminate data redundancy and improve data integrity

Increase query execution speed

Reduce storage capacity requirements

Simplify user interface design

Submit

13. Which of the following is a best practice for database security?

Store passwords in plain text for easy recovery

Use strong encryption and implement role-based access control

Allow all users full administrative privileges

Disable user authentication to improve performance

Submit

15. What is the primary role of a database administrator (DBA)?

Design user interfaces for applications

Manage, maintain, and optimize database systems and security

Write application code for end-users

Create marketing campaigns for software

16. Which isolation level prevents dirty reads but allows non-repeatable reads?

Read Uncommitted

Read Committed

Repeatable Read

Serializable

Submit

18. What is the primary advantage of implementing database indexing?

Reduces memory usage on the server

Accelerates data retrieval and query performance

Eliminates the need for backups

Automatically enforces data validation

Submit

20. Which of the following best describes ACID properties in database transactions?

Atomicity, Consistency, Isolation, Durability

Authentication, Confidentiality, Integrity, Disclosure

Availability, Concurrency, Integration, Deployment

Access, Compliance, Indexing, Distribution

DataSys+ Quiz: Can You Run the Database?

1. What does CAP theorem state about distributed database systems?

2.

What first name or nickname would you like us to use?

2. Which of the following best describes data redundancy in databases?

3. In database administration, ____ is the process of removing unused or outdated data.

4. What is the primary function of database monitoring?

5. A ____ constraint ensures that each row in a table has a unique identifier.

6. Which of the following is a common sign of poor database performance?

7. The process of copying data from a production database to a test environment is called ____.

8. What is query optimization primarily concerned with?

9. Which backup method captures the entire database at a specific point in time?

10. A ____ is a database object that stores a predefined query for quick access to data.

11. What is the primary purpose of database normalization?

12. The process of distributing data across multiple servers to improve availability is called ____.

13. Which of the following is a best practice for database security?

14. A ____ is a set of SQL statements that can be executed as a single unit.

15. What is the primary role of a database administrator (DBA)?

16. Which isolation level prevents dirty reads but allows non-repeatable reads?

17. In relational databases, a foreign key is used to ____ referential integrity between tables.

18. What is the primary advantage of implementing database indexing?

19. A database backup strategy that captures only changes since the last full backup is called a(n) ____ backup.

20. Which of the following best describes ACID properties in database transactions?