File Info
| Exam | Querying Data with Transact-SQL |
| Number | 70-761 |
| File Name | Microsoft.70-761.Prep4Sure.2018-06-16.91q.tqb |
| Size | 13 MB |
| Posted | Jun 16, 2018 |
| Download | Microsoft.70-761.Prep4Sure.2018-06-16.91q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section. You will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You create a table named Customer by running the following Transact-SQL statement:
You must insert the following data into the Customer table:
You need to ensure that both records are inserted or neither record is inserted.
Solution: You run the following Transact-SQL statement:
Does the solution meet the goal?
- Yes
- No
Correct answer: B
Explanation:
As there are two separate INSERT INTO statements we cannot ensure that both or neither records are inserted. As there are two separate INSERT INTO statements we cannot ensure that both or neither records are inserted.
Question 2
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section. You will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You create a table named Customer by running the following Transact-SQL statement:
You must insert the following data into the Customer table:
You need to ensure that both records are inserted or neither record is inserted.
Solution: You run the following Transact-SQL statement:
Does the solution meet the goal?
- Yes
- No
Correct answer: B
Explanation:
As there are two separate INSERT INTO statements we cannot ensure that both or neither records are inserted. As there are two separate INSERT INTO statements we cannot ensure that both or neither records are inserted.
Question 3
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section. You will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You create a table named Customer by running the following Transact-SQL statement:
You must insert the following data into the Customer table:
You need to ensure that both records are inserted or neither record is inserted.
Solution: You run the following Transact-SQL statement:
Does the solution meet the goal?
- Yes
- No
Correct answer: A
Explanation:
With the INSERT INTO..VALUES statement we can insert both values with just one statement. This ensures that both records or neither is inserted. References:https://msdn.microsoft.com/en-us/library/ms174335.aspx With the INSERT INTO..VALUES statement we can insert both values with just one statement. This ensures that both records or neither is inserted.
References:https://msdn.microsoft.com/en-us/library/ms174335.aspx
