ExamTopics Logo
Mail Us[email protected]
Menu
Comptia Discussions
exam questions

Exam DS0-001 All Questions

View all questions & answers for the DS0-001 exam
Go to Exam

Exam DS0-001 topic 1 question 86 discussion

Actual exam question from CompTIA's DS0-001
Question #: 86
Topic #: 1
[All DS0-001 Questions]

A database administrator would like to extract a sales performance report from more than one database instance. Which of the following keywords should the database administrator use?

  • A. UNION ON
  • B. UNION AND
  • C. JOIN ON
  • D. WITH
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by steveng2001 at Dec. 22, 2024, 7:52 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
steveng2001
2 weeks, 6 days ago
Selected Answer: A
A. UNION ON Explanation: The UNION keyword is used to combine the results of two or more SELECT queries from different database instances or tables. It allows a database administrator to extract and merge data into a single report. The ON clause is typically used in conjunction with UNION to specify conditions when joining the results.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago