Câu 34: 70-762: Developing SQL Databases
You run the following Transact-SQL statement: There are multiple unique OrderID values. Most of the UnitPrice values for the same OrderID are different. You need to create a single index seek query that does not use the following operators: ✑ Nested loop ✑ Sort ✑ Key lookupWhich Transact-SQL statement should you run?
Nội dung câu hỏi
You run the following Transact-SQL statement: There are multiple unique OrderID values. Most of the UnitPrice values for the same OrderID are different. You need to create a single index seek query that does not use the following operators: ✑ Nested loop ✑ Sort ✑ Key lookupWhich Transact-SQL statement should you run?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. CREATE INDEX IX_OrderLines_1 ON OrderLines (OrderID, UnitPrice) INCLUDE (Description, Quantity) — đáp án hiện tại
- B. CREATE INDEX IX_OrderLines_1 ON OrderLines (OrderID, UnitPrice) INCLUDE (Quantity)
- C. CREATE INDEX IX_OrderLines_1 ON OrderLines (OrderID, UnitPrice, Quantity)
- D. CREATE INDEX IX_OrderLines_1 ON OrderLines (UnitPrice, OrderID) INCLUDE (Description, Quantity)
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.