IBM
C2090-558 · Question #26
Assuming the tables and columns mentioned below exist, which of the following SQL statements will return an error?
The correct answer is B. SELECT company, fname, lname, state FROM customer WHERE state = (SELECT state, zipcode. See the full explanation below for the reasoning.
Question
Assuming the tables and columns mentioned below exist, which of the following SQL statements will return an error?
Options
- AINSERT INTO orders
- BSELECT company, fname, lname, state FROM customer WHERE state = (SELECT state, zipcode
- CDELETE FROM stock
- DUPDATE customer SET (address, city, state, zip) = (SELECT address, city, state, zip
How the community answered
(43 responses)- A5% (2)
- B79% (34)
- C5% (2)
- D12% (5)
Community Discussion
No community discussion yet for this question.