Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

Question : 10 of 50

Marks: +1, -0

View the exhibit and examine the structure of the STORES table.

The stores displayed must have START DATE in the range of 36 months starting from 01-Jan-2000 and above. Which SQL statement would get the desired output?

SELECT name, contact (address| | ','| |city| |', ', country) AS full_address,start_date,property_price, property_price*115/100FROM storesWHERE MONTHS_BETWEEN (start_date, '01-JAN-2000') <=36;
SELECT name, concat (address| | ','| |city| |', ', country) AS full_address, start_date, property_price, property_price*115/100 FROM stores WHERE TO_NUMBER(start_date-TO_DATE('01-JAN-2000','DD-MON-RRRR')) <=36;
. SELECT name, address||', '||city||', '||country AS full_address, start_date, property_price, property_price*115/100 FROM stores WHERE MONTHS_BETWEEN(start_date,TO_DATE('01-JAN-2000','DD-MON-RRRR')) <=36;
SELECT name, concat (address||','| |city| |', ', country) AS full_address, start_date, property_price, property_price*115/100 FROM stores WHERE MONTHS_BETWEEN (start_date, TO_DATE('01-JAN-2000','DD-MON-RRRR')) <=36;

Validate

Go to Question:

Prev Question

Next Question