Based upon the contents of the BOOKS table, which line of the following SQL statement contains an error? 1. SELECT title, pubid, cost, retail 2. FROM books 3. WHERE (pubid, cost) 4. (SELECT pubid, cost) 5. FROM books 6. WHERE pubid = 3);

1
105 Views
All levels

lualen5493

High School

Based upon the contents of the BOOKS table, which line of the following SQL statement contains an error?
1. SELECT title, pubid, cost, retail
2. FROM books
3. WHERE (pubid, cost)
4. (SELECT pubid, cost)
5. FROM books
6. WHERE pubid = 3);

Leave an answer

Our People Answers

0

(Based on todays review)

codiepienagoya

Verified answer

Answer:
The answer is "Option 4"
Explanation:
In the given question line 4 is incorrect because it uses the select command, which selects "pubid and cost" that is already defined inline 3. This statement selects one or more a collection of records from the tables. It also recovers more row across any table that server and correct choices can be described as follows:
In the given choices, except line 3 all were correct because first, it selects column names from the table "book".
After selecting column names it and defines condition were pubid value is 3.
- 0
- 0
- Reply
- Report