You are building a stored procedure that will update data in a table named Table1 by using a complex query as the data source.
You need to ensure that the SELECT statement in the stored procedure meets the following requirements:
Data being processed must be usable in several statements in the stored procedure.

Data being processed must contain statistics.

What should you do?

• A.Update Table1 by using a common table expression (CTE).
• B.Insert the data into a temporary table, and then update Table1 from the temporary table.
• C.Place the SELECT statement in a derived table, and then update Table1 by using a JOIN to the derived table.
• D.Insert the data into a table variable, and then update Table1 from the table variable.

Comment: *

Name: *

Email: *

Verification: *

You have a database that tracks customer complaints.
The database contains a table named Complaints that includes the following columns:

You need to create a query that lists complaints about defective products. The report must include complaints where the exact phrase "defective product" occurs, as well as complaints where similar phrases occur.
Which Transact-SQL statement should you run?

• A.SELECT ComplaintID, ComplaintTranscript FROM Complaints
  WHERE CONTAINS(CustomerTranscript, 'defective')
  AND CONTAINS(CustomerTranscript, 'product')
• B.SELECT ComplaintID, CustomerTranscript FROM Complaints
  WHERE SOUNDEX('defective') = SOUNDEX('product')
• C.SELECT ComplaintID, CustomerTranscript FROM Complaints
  WHERE FREETEXT(CustomerTranscript, 'defective product')
• D.SELECT ComplaintID, Customer Transcript FROM Complaints
  WHERE CustomerTranscript like '%defective product%'

Comment: *

Name: *

Email: *

Verification: *

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 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 contain the following columns:

You need to run a query to find the total number of customers who have both deposit and loan accounts.
Which Transact-SQL statement should you run?
A:

B:

C:

D:

E:

F:

G:

H:

• A.Option A
• B.Option B
• C.Option C
• D.Option D
• E.Option E
• F.Option F
• G.Option E
• H.Option F
• I.Option G
• J.Option H

Comment: *

Name: *

Email: *

Verification: *

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 contain the following columns:

You need to determine the total number of customers who have only deposit accounts.
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

Comment: *

Name: *

Email: *

Verification: *

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 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 contain the following columns:

You need to run a query to find the total number of customers who have both deposit and loan accounts.
Which Transact-SQL statement should you run?

• A.SELECT COUNT(*)FROM (SELECT AcctNoFROM tblDepositAcctINTERSECTSELECT AcctNoFROM tblLoanAcct) R
• B.SELECT COUNT(*)FROM (SELECT CustNoFROM tblDepositAcctUNIONSELECT CustNoFROM tblLoanAcct) R
• C.SELECT COUNT(*)FROM (SELECT CustNoFROM tblDepositAcctUNION ALLSELECT CustNoFROM tblLoanAcct) R
• D.SELECT COUNT (DISTINCT D.CustNo)FROM tblDepositAcct D, tblLoanAcct LWHERE D.CustNo L.CustNo
• E.SELECT COUNT(DISTINCT L.CustNo)FROM tblDepositAcct DRIGHT JOIN tblLoanAcct L ON D.CustNo L.CustNoWHERE D.CustNo IS NULL
• F.SELECT COUNT(*)FROM (SELECT CustNoFROM tblDepositAcctEXCEPTSELECT CustNoFROM tblLoanAcct) R
• G.SELECT COUNT (DISTINCT COALESCE(D.CustNo, L.CustNo))FROM tblDepositAcct DFULL JOIN tblLoanAcct L ON D.CustNo = L.CustNoWHERE D.CustNo IS NULL OR L.CustNo IS NULL
• H.SELECT COUNT(*)FROM tblDepositAcct DFULL JOIN tblLoanAcct L ON D.CustNo = L.CustNo

Comment: *

Name: *

Email: *

Verification: *