Question

Which line in the following SQL statement raises an error?

1. SELECT name, title
2. FROM books NATURAL JOIN publisher
3. WHERE category = 'FITNESS'
4. OR
5. books.pubid=4;
A. line 1
B. line 2
C. line3
D. line 4
E. line 5

Answer 1

The error occurs at line 4 of the SQL statement due to the incorrect use of the OR keyword without a condition following it.

Step-by-step explanation:

The line in the SQL statement that raises an error is line 4. The reason for the error is that the OR keyword cannot be used without a condition following it. A valid SQL statement must have a condition after the OR keyword. Therefore, the correct portion of the statement using OR should have an additional condition, such as another WHERE clause condition.

For example, it might be revised like this: WHERE category = 'FITNESS' OR books.pubid = 4; This revision assumes that there is a column named category in the result of the natural join between books and publisher, and that books.pubid refers to a valid column in that result as well.