Quiz for Schema Design & Best Practices

Q1: What is a best practice for naming database columns?

A. Use spaces between words B. Use descriptive and consistent names C. Use special characters D. Use very short names like a, b

Q2: Which process helps reduce redundancy in schema design?

A. Denormalization B. Partitioning C. Indexing D. Normalization

Q3: What is the best practice for choosing data types in schema design?

A. Always use text B. Use the largest type possible C. Use the most appropriate and smallest data type D. Use only integers

Q4: Which of the following is a good practice for primary keys?

A. Use a meaningful string B. Use natural keys with spaces C. Use auto-incremented integers D. Do not define any key

Q5: Why should foreign key constraints be enforced in schema design?

A. They slow down the database B. They ensure referential integrity C. They remove the need for joins D. They duplicate data