contestada

The PRODUCT table contains this column: PRICE NUMBER(7,2)
Evaluate this statement:
SELECT NVL(10 / price, '0')
FROM PRODUCT;
What would happen if the PRICE column contains null values?
A. A value of 0 would be displayed. (*)
B. The statement would fail because values cannot be divided by 0.
C. The statement would fail because values cannot be divided by null.
D. A value of 10 would be displayed.

Respuesta :

MrRoyal

SQL queries are used to return results from a database table or multiple tables.

If the PRICE column contains null values, then (b) the statement would fail because values cannot be divided by 0.

The query is given as: SELECT NVL(10 / price, '0')  FROM PRODUCT

From the query, the query is to first divide 10 by the value of the PRICE column.

If the PRICE column contains 0, then it means that price = 0

A division by 0 is not possible.

So, the query would fail

Hence, the true statement is (b)

Read more about SQL queries at:

https://brainly.com/question/15049854

Otras preguntas