1zo-051:10

Oracle11g SQL Fundamentals I:1ZO-051

There are four rows of data in the REGIONS table. Consider the following SQL statement:

SELECT '6 * 6' “Area” FROM REGIONS;

How many rows of results are returned and what value is returned by the Area column?

(Choose the best answer.)

A. 1 row returned, Area column contains value 36

B. 4 rows returned, Area column contains value 36 for all 4 rows

C. 1 row returned, Area column contains value 6 * 6

D. 4 rows returned, Area column contains value 6 * 6 for all 4 rows

E. A syntax error is returned.


A, B, C, and E are incorrect.

A returns one row instead of four and calculates the product 6 * 6.
The enclosing quote operators render 6 * 6 a character literal and not a numeric literal that can be calculated.

B correctly returns four rows but incorrectly evaluates the character literal as a numeric literal.

C incorrectly returns one row instead of four and E is incorrect, because the given SQL statement can be executed.

comments

click here to Post your comments and suggestions regarding this page.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License