ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

20 / 120

Question 20:

View the exhibit and examine the structure of the STORES table. 
image
You must display the NAME of stores along with the ADDRESS, START_DATE, PROPERTY_PRICE, and the projected property price, which is 115% of property price. 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? 

Answer options:

A. SELECT name, concat (address| | `,`| |city| |`, `, country) AS full_address, start_date, property_price, property_price*115/100 FROM stores WHERE MONTHS_BETWEEN (start_date, `01-JAN-2000`) <=36;
B. 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;
C. 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;
D. 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;