1. Home
  2. Discussions
  3. CompTIA
  4. CompTIA Data+
  5. DA0-001 Discussions
  6. DA0-001 Exam Topic 2 Question 17 Discussion

CompTIA Data+ Certification Exam DA0-001 Question # 17 Topic 2 Discussion

 CompTIA Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

CompTIA Data+ Certification Exam DA0-001 Question # 17 Topic 2 Discussion

DA0-001 Exam Topic 2 Question 17 Discussion:
Question #: 17
Topic #: 2

Consider the following dataset which contains information about houses that are for sale:

DA0-001 Question 17

Which of the following string manipulation commands will combine the address and region namecolumns 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
A.

SELECT CONCAT(address, ' , ' , regionname) AS full_address FROM melb LIMIT 5;

B.

SELECT CONCAT(address, '-' , regionname) AS full_address FROM melb LIMIT 5;

C.

SELECT CONCAT(regionname, ' , ' , address) AS full_address FROM melb LIMIT 5

D.

SELECT CONCAT(regionname, '-' , address) AS full_address FROM melb LIMIT 5;

Get Premium DA0-001 Questions
Actual exam question for CompTIA DA0-001 exam by Axel5232 at Aug 3, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next