DA0-001 · Question #88
Consider the following dataset which contains information about houses that are for sale: Which of the following string manipulation commands will combine the address and region name columns to create
Sign in or unlock DA0-001 to reveal the answer and full explanation for question #88. The question stem and answer options stay visible for context.
Question
Consider the following dataset which contains information about houses that are for sale:
Which of the following string manipulation commands will combine the address and region name columns to create a full address? full_address------------------------- 85 Turner St, Northern Metropolitan 25 Bloomburg St, Northern Metropolitan 5 Charles St, Northern Metropolitan 40 Federation La, Northern Metropolitan 55a Park St, Northern Metropolitan
Exhibit
Options
- ASELECT CONCAT(address, ' , ' , regionname) AS full_address FROM melb LIMIT 5;
- BSELECT CONCAT(address, '-' , regionname) AS full_address FROM melb LIMIT 5;
- CSELECT CONCAT(regionname, ' , ' , address) AS full_address FROM melb LIMIT 5
- DSELECT CONCAT(regionname, '-' , address) AS full_address FROM melb LIMIT 5;
Unlock DA0-001 to see the answer
You've previewed enough free DA0-001 questions. Unlock DA0-001 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.