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.)

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.)
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.

How To Pass 98-364 Exam?

FULL Printable PDF and Software. VALID exam to help you PASS.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.