微软MCAD 70-310 实战百题
题目内容

You are developing a order-processing application that retrieves data from a Microsoft SQL Server database named Datal that contains a table named Customers and a table named Orders.Customer has a primary key of customerID. Each row in orders has a CustomerlD that indicates which customer placed the order.Your application uses a DataSet object named ordersDataSet to capture customer and order information before it applied to the database. The ordersDataSet object has two Data Table objects named Customers and Orders.You want to ensure that a row cannot exist in the Orders Data Table object without a matching row existing in the Customers Data Table object.Which two actions should you take? (Each correct answer presents part of the solution. Choose two)

2021-12-25

A.Create a foreign key constraint named constraintOrders that has Orders.CustomersID as the parent column and Customers. CustomerlD as the child column

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

C.Create a unique constraint named uniqueCustomers by using theCustomers.CustomerlD

D.Add ConstraintOrders tothe Orders Data Table

E.Add ConstraintOrders tothe Customer Data Table

G.Add ConstraintCustomers to the Customers Data Table

H.Add UniqueCustomers to the Customers Data Table

题目答案

试卷相关题目

最新试卷
热门试卷

长理培训客户端 资讯,试题,视频一手掌握

去 App Store 免费下载 iOS 客户端