PdfPrep.com

Which Transact-SQL statement should you run?

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

You have a database for a banking system. The database has two tables named tblDepositAcct and tblLoanAcct that store deposit and loan accounts, respectively. Both tables include the following columns:

You need to determine the total number of different customers who have at least one account.

Which Transact-SQL statement should you run?

A . Option A
B . Option B
C . Option C
D . Option D
E . Option E
F . Option F
G . Option G
H . Option H

Answer: A

Exit mobile version