how is the following query incorrect select from orders where orderid..., MS SQL Server 2005, Databases

MS SQL Server 2005

Test
- Model Test
Index

Question:How is the following query incorrect?
select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)

A In the sub-query, '*' should be used instead of 'OrderID' 
B The sub-query can return more than one row, so, '=' should be replaced with 'in' 
C The sub-query should not be in parenthesis 
D None of these

/76

+ AnswerB

+ Report

Descriptive on MS SQL Server 2005 Ebook

Total Preview: 560

Question:How is the following query incorrect? select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)

A In the sub-query, '*' should be used instead of 'OrderID'

B The sub-query can return more than one row, so, '=' should be replaced with 'in'

C The sub-query should not be in parenthesis

D None of these

B