ExpertMedium1 markMultiple Choice
CPA · Question 30 · Area I: Information Systems
Which SQL command is used to combine rows from two or more tables based on a related column between them?
Which SQL command is used to combine rows from two or more tables based on a related column between them?
Answer options:
A.
MERGE
B.
JOIN
C.
LINK
D.
COMBINE
How to approach this question
Recall SQL syntax for multiple tables.
Full Answer
B.JOIN✓ Correct
JOIN
The JOIN clause (INNER JOIN, LEFT JOIN, etc.) is used to combine rows from two or more tables, based on a related column between them.
Common mistakes
Guessing non-SQL words like LINK or COMBINE.
Practice the full CPA ISC Practice Exam 5
82 questions · hints · full answers · grading
More questions from this exam
Q01A service organization provides a cloud-based payroll processing application to its user entities...MediumQ02An auditor is reviewing the shared responsibility model for a client using an Infrastructure as a...HardQ03A financial institution requires a cloud deployment model that offers the highest level of contro...MediumQ04During an IT audit, you observe that a company uses a 'Hybrid Cloud' architecture. Which scenario...MediumQ05Which component of IT architecture is primarily responsible for translating domain names (like ww...Easy