Database Concepts: Relational vs. Non-Relational, Tables, Rows, Fields, Primary/foreign Keys. IT-FUNDAMENTALS-ITF-CERTIFICATION Practice Questions (Page 6)

Questions 26–26

1. 26expert · hard

   A database administrator is designing a table to store customer accounts. They are considering using the customer's email address as the primary key instead of a separate numeric ID. What is the most significant potential problem with this approach?

   • AEmail addresses are not unique across different customers.
   • BEmail addresses can be changed by the user, which would require updating the primary key and all related foreign keys.
   • CEmail addresses are not indexed by default.
   • DEmail addresses are too long to be used as a primary key.
   Reveal Solution Discussion Select an answer first