Exam 70-761 topic 1 question 105 discussion

" total number of deposit and loan accounts" is correct answer C (UNION ALL)

if a customer has 3 deposit accounts then the query <select custno from deposit > returns this custno 3 times, that means, you count the total number of records. I think, answer C) with union all statement is ok

C is absolutely correct

C is correct . custno and acctno are unique in both tables so we don't have to exclude distinct values for custno. that means we must use UNION ALL. Then we count rows in result set of Union All

None of them is correct.

select count(AcctNo) as TotalAccounts from tblDepositAcct UNION select count(AcctNo) as TotalAccounts from tblLoanAcct

We need total deposit and loan accounts.A single person can have multiple accounts. So in deposit table if Customer1 has 3 accounts, then all these accounts are going to be unique, the same accounts cannot exist in Loan table so option A is wrong it will return zero records. Coming to B again if Customer1 has 3 accounts in deposit table and 2 accounts in Loan table, for customer1 itself there are total 5 accounts but if you do Union on Custno you will get only 2 as the result which is wrong if we need total account numbers. Coming to C again if Customer1 has 3 accounts in Deposit table and 2 accounts in loan table that means in Deposit table there are 3 entries of Customer1 in deposit and 2 in Loan so union all will display all 5 because union all displays everything including dupes. Rest options are not relevant here. So the correct answer is C

C is correct, it counts all rows in tblDepositAcct and all rows in tblLoanAcct, each row has unique AcctNo CustNo is irrelavant because the question asks for unique AcctNo even some may belong to the same CustNo

its C for Sure. Tested

So, there are C and H answers are correct, agree with mattia_88 and Andi64 both are rights, and both query will return equivalent answers

A doesn't count accounts which present only in one table, C counts users, if we want to count all accounts (not only intersection), the correct answer might be H.

» deposit and loan accounts, meaning ACCOUNTS that are in the table deposit and the table accounts. Also, the question demands ACCOUNTS not Customers. So yes, A is the correct answer.

A is correct answer.