98-364 · Question #100
You work as a Database Designer for Tritech Inc. You are designing a table named Info. The table contains the following attributes: - Login and Password - Name - ContactNumber - Address Each new…
The correct answer is A. The value of the primary key cannot be NULL. B. The value of the primary key must be persistent. C. The natural key contains highly sensitive data. D. The value of the primary key must be unique. See the full explanation below for the reasoning.
Question
You work as a Database Designer for Tritech Inc. You are designing a table named Info. The table contains the following attributes:
- Login and Password
- Name
- ContactNumber
- Address
Each new employee joining the company is assigned an E-mail Login and Password. This E-mail Login and Password is used by each employee to access his account on the company's Web site. The value of both the attributes should be unique and cannot be NULL. You design an artificial key EmpID in the Info table to serve as a primary key. Which of the following factors lead you to define an artificial key for use as a primary key in the Info table? Each correct answer represents a part of the solution. Choose all that apply.
Options
- AThe value of the primary key cannot be NULL.
- BThe value of the primary key must be persistent.
- CThe natural key contains highly sensitive data.
- DThe value of the primary key must be unique.
How the community answered
(32 responses)- A100% (32)
Community Discussion
No community discussion yet for this question.