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

You need to ensure that the CustomerId column in the Orders table contains only values that exist in the CustomerId column of the Customer table. Which Transact-SQL statement should you use?

Question

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

You need to ensure that the CustomerId column in the Orders table contains only values that exist in the CustomerId column of the Customer table. Which Transact-SQL statement should you use?

Accepted Answer

A. ALTER TABLE Orders

Answer

B. ALTER TABLE Customer

Answer

C. ALTER TABLE Orders

Answer

D. ALTER TABLE Customer

Answer

E. ALTER TABLE Orders

You are a database developer of a Microsoft SQL Server 2012 database. The database contains a table named Customers that has the following definition: You need to ensure that the CustomerId column…

Question

Exhibit

Options

How the community answered

Community Discussion