Table Column Properties Quiz

What you'll be asked

1. Which column property ensures that a specific column cannot contain a NULL value?
2. When designing a table, why is it recommended to use a surrogate key (e.g., an auto-incrementing integer) instead of a natural key (e.g., email address) as a Primary Key?
3. What is the primary purpose of the 'DEFAULT' column property in a relational database?
4. If you need to ensure that a 'DiscountPercentage' column in a 'Products' table always contains a value between 0 and 100, which constraint is most appropriate?
5. You are designing a high-performance database and need to choose a data type for a column storing a fixed-length string of exactly 10 characters that is frequently used in JOIN operations. Which is the most efficient choice?

Answers and explanations come after you submit.