PrepAway - Latest Free Exam Questions & Answers

Which two actions should you take? (Each correct answer presents part of the solution

You are developing an order-processing application that retrieves data from a Microsoft SQL Server database. The database contains a table named Customers and a table named Orders.

Customers has a primary key of CustomerID. Each row in Orders has a CustomerID that indicates
which customer placed the order.

Your application uses a DataSet object named ordersDataSet to capture customer and order information before it is applied to the database. The ordersDataSet object has two DataTable objects named Customers and Orders.

You want to ensure that a row cannot exist in the Orders DataTable object without a matching row existing in the Customers DataTable object.

Which two actions should you take? (Each correct answer presents part of the solution. Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
Create a foreign key constraint named ConstraintOrders that has Orders.CustomerID as the parent column and Customers.CustomerID as
the child column.

B.
Create a foreign key constraint named ConstraintCustomers that has Customers.CustomerID as the parent column and Orders.CustomerID
as the child column.

C.
Create a unique constraint named UniqueCustomers by using the Customers.CustomerID.

D.
Add ConstraintOrders to the Orders DataTable.

E.
Add ConstraintOrders to the Customers DataTable.

F.
Add ConstraintCustomers to the Orders DataTable.

G.
Add ConstraintCustomers to the Customers DataTable.

H.
Add UniqueCustomers to the Customers DataTable.


Leave a Reply