nerdexam
Microsoft

98-364 · Question #100

98-364 Question #100: Real Exam Question with Answer & Explanation

Sign in or unlock 98-364 to reveal the answer and full explanation for question #100. The question stem and answer options stay visible for context.

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.

Unlock 98-364 to see the answer

You've previewed enough free 98-364 questions. Unlock 98-364 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 98-364 Practice