Oracle
1Z0-071 · Question #15
View the Exhibit and examine the structure of the stores table. You want to display the name of the store along with the address, START_DATE, PROPERTV_PRICE, and the projected property price, which…
The correct answer is D. SELECT name, concat (address||','| |city| |', ', country) AS. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of the stores table. You want to display the name of the store along with the address, START_DATE, PROPERTV_PRICE, and the projected property price, which is 115% of the 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?
Options
- ASELECT name, concat (address| | ','| |city| |', ', country) AS
- BSELECT name, concat (address| | ','| |city| |', ', country) AS
- CSELECT name, address||','||city||','||country AS full_address,
- DSELECT name, concat (address||','| |city| |', ', country) AS
How the community answered
(25 responses)- A4% (1)
- B4% (1)
- C16% (4)
- D76% (19)
Community Discussion
No community discussion yet for this question.