1z0-071 Exam - Question 2

Question

Examine the description of the PRODUCTS table:Which three queries use valid expressions? (Choose three. ).

Examice · Accepted Answer

The three queries that use valid expressions are: 1. SELECT product_id, (unit_price * 0.15 / (4.75 + 552.25)) FROM products; This query is valid because it uses a mathematical expression involving unit_price, which is of type NUMBER. 2. SELECT product_id, (expiry_date - delivery_date) * 2 FROM products; This query is valid because it calculates the difference between two dates, which yields a NUMBER representing the number of days between them. This result can then be multiplied by 2. 3. SELECT product_id, unit_price, unit_price + surcharge FROM products; This query is valid assuming that the VARCHAR2 column surcharge contains numeric values. Oracle SQL implicitly converts VARCHAR2 to NUMBER in such cases, making the addition valid.

dumpsvibe · Answer

B and C are right but F is a tricky one

GunduzHuseynli · Answer

BCE should be correct answer cause number+varchar in this case imspossible

gabolka · Answer

you cant multiply date, BCF correct if varchar2 is number

MZEnuovazelanda · Answer

IT is correct BCF because in the Datatype Varchar2 there may be a number. Oracle makes it an implicit cast and uses it as a number

fantastic_side_eye · Answer

BCF 
The three queries that use valid expressions are:

B. SELECT product_id, (unit_price * 0.15 / (4.75 + 552.25)) FROM products;

C. SELECT product_id, (expiry_date - delivery_date) * 2 FROM products;

F. SELECT product_id, unit_price, unit_price + surcharge FROM products;

Explanation:

A. This query is invalid because the alias "S" is not defined anywhere in the query.

B. This query is valid. It calculates a value based on the unit price of each product using a mathematical expression.

C. This query is valid. It calculates the difference between the expiry date and delivery date for each product and multiplies it by 2.

D. This query is invalid because the alias "discount" is not defined anywhere in the query.

E. This query is invalid because you cannot multiply a date value by a number.

F. This query is valid. It selects the product ID, unit price, and the sum of the unit price and surcharge for each product.

jm9999 · Answer

Seems like a sketchy question, have to assume surcharge contains only numerical characters in the string for F

Averagenoob · Answer

bce should be

Indhumathishan · Answer

why is D incorrect?

Nelita · Answer

B-C-F IS CORRECT IF the varchar-column has stored number.

zouve · Answer

select '2'+3 from dual;

it produces the SUM correctly so F is correct

Lee_jong_suk · Answer

BCF is correct answer
Please note:
date+date is not allowed

holdfaststrongly · Answer

Is "-discount" in AD supposed to be an alias for the column?

TMerlo · Answer

It´s not a right decision plus a NUMBER with VARCHAR2 fields.

tom2992 · Answer

A and D wrong cause they have invalid identifier "Discount".
E wrong cause date can't multiple with number.

alelejaja · Answer

B and C clearly correct.
F is tricky. It can be correct only if the column Surcharge contains numeric characters defined as varchar2

1z0-071 Exam - Question 2

Discussion