Which action should you take?

You are a database developer on an instance of SQL Server 2008. You have an Employee table created with the following statement:
CREATE TABLE Employee (
EmpID int IDENTITY(1,1) PRIMARY KEY,
LastName varchar(35) NOT NULL,
FirstName varchar(25) NOT NULL,
HireDate datetime,
Salary money,
MgrID int);
The MgrID column will contain the EmpID associated with each employee’s manager. You want to create a self-referencing relationship to support this.
Which action should you take?
A. Create a DML trigger.
B. Create a FOREIGN KEY constraint on the EmpID column.
C. Create a FOREIGN KEY constraint on the MgrID column.
D. Create a CHECK constraint on the MgrID column.

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.