Which Transact-SQL statement should you use?

You are a database developer of a Microsoft SQL Server database.
The database contains a table named Instructor that has the following definition:

You are designing a new table named Course that has the following definition:

You need to ensure that the InstructorId column in the Course table contains only values that exist in the InstructorID column of the Instructor table.
Which Transact-SQL statement should you use?
A.

B.

C.

D.

E.

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.