Database Schema Change Request Quiz

1. In database design, what does ACID stand for?

Access, Consistency, Integrity, Durability

Atomicity, Consistency, Isolation, Durability

Accuracy, Confidentiality, Integration, Distribution

Aggregate, Compile, Index, Distribute

Submit

3. True or False: Partitioning a large table by date is a schema design strategy that improves query performance.

True

False

4. Which tool or process helps data analysts validate schema changes before production deployment?

Development and staging environment testing

Peer code review only

SQL syntax checking

Backup restoration

Submit

6. When analyzing schema change impact, which metric is most critical to assess?

Column name length

Query execution time and resource utilization

Number of rows in the table

Database administrator preferences

7. True or False: A data analyst can unilaterally modify production schemas without approval.

True

False

8. What is the purpose of a rollback plan in a schema change request?

To document the history of all schema versions

To provide a procedure to revert changes if something fails

To calculate the cost of the schema change

To track who approved the change

Submit

10. Which approach minimizes downtime when altering a large production table?

Immediate ALTER TABLE during business hours

Online schema change or shadow table technique

Manual data copy without using DDL statements

Dropping and recreating the entire table

11. True or False: A schema change that adds a NOT NULL constraint requires all existing rows to have a value for that column.

True

False

12. Which normal form eliminates partial dependencies by ensuring non-key attributes depend on the entire primary key?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

Submit

14. Which constraint ensures that all entries in a column are unique and not null?

CHECK constraint

UNIQUE constraint

PRIMARY KEY constraint

DEFAULT constraint

15. What is the primary purpose of a staging table when making schema changes?

To store backup copies of original data

To allow incremental data validation and transformation before applying changes

To replace the original table permanently

To reduce database storage requirements

Submit

17. Which of the following best describes a foreign key constraint in schema design?

A unique identifier for each row in a table

A reference to the primary key of another table that maintains referential integrity

An index that speeds up JOIN operations

A column that stores derived data

18. True or False: Denormalization always improves database query performance.

True

False

Submit

20. When requesting a schema change, which document should outline the business justification and expected impact?

Change Request Form or Change Management Document

SQL script only

Email to the database administrator

Project charter

21. A data analyst wants to add a new column to a large production table. What is the primary concern?

The column name must follow naming conventions

Downtime and performance impact on existing queries

The data type must be VARCHAR

All existing records must have data in the new column immediately

Data Analyst Requesting a Database Schema Change Quiz

1. In database design, what does ACID stand for?

2.

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

2. A data analyst needs to add a column with default values to an existing table. The best approach is to request a schema change that includes ____.

3. True or False: Partitioning a large table by date is a schema design strategy that improves query performance.

4. Which tool or process helps data analysts validate schema changes before production deployment?

5. A schema change that removes a column used by legacy applications is most risky because it may cause ____.

6. When analyzing schema change impact, which metric is most critical to assess?

7. True or False: A data analyst can unilaterally modify production schemas without approval.

8. What is the purpose of a rollback plan in a schema change request?

9. A data analyst wants to split a wide table into two related tables to improve query performance. This process is called ____.

10. Which approach minimizes downtime when altering a large production table?

11. True or False: A schema change that adds a NOT NULL constraint requires all existing rows to have a value for that column.

12. Which normal form eliminates partial dependencies by ensuring non-key attributes depend on the entire primary key?

13. A data analyst discovers that a frequently queried column is not indexed. The recommended action is to request ____.

14. Which constraint ensures that all entries in a column are unique and not null?

15. What is the primary purpose of a staging table when making schema changes?

16. Before implementing a schema change in production, a data analyst should ____.

17. Which of the following best describes a foreign key constraint in schema design?

18. True or False: Denormalization always improves database query performance.

19. A composite index on columns (customer_id, order_date) is most useful for queries that filter on ____.

20. When requesting a schema change, which document should outline the business justification and expected impact?

21. A data analyst wants to add a new column to a large production table. What is the primary concern?