Valid 70-461 Dumps shared by ExamDiscuss.com for Helping Passing 70-461 Exam! ExamDiscuss.com now offer the newest 70-461 exam dumps, the ExamDiscuss.com 70-461 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-461 dumps with Test Engine here:
Access 70-461 Dumps Premium Version
(252 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 4/126
A local bank uses a SQL Server database to manage accounts. You are developing a stored procedure that contains multiple Transact-SQL INSERT statements.
The stored procedure must use transaction management to handle errors.
You need to ensure that the stored procedure rolls back the entire transaction if a run-time occurs.
Which Transact-SQL statement should you add to the stored procedure?
The stored procedure must use transaction management to handle errors.
You need to ensure that the stored procedure rolls back the entire transaction if a run-time occurs.
Which Transact-SQL statement should you add to the stored procedure?
Correct Answer: D
Explanation/Reference:
Explanation:
SET XACT_ABORT specifies whether SQL Server automatically rolls back the current transaction when a Transact-SQL statement raises a run-time error.
When SET XACT_ABORT is ON, if a Transact-SQL statement raises a run-time error, the entire transaction is terminated and rolled back.
References: https://docs.microsoft.com/en-us/sql/t-sql/statements/set-xact-abort-transact-sql?view=sql- server-2017
Explanation:
SET XACT_ABORT specifies whether SQL Server automatically rolls back the current transaction when a Transact-SQL statement raises a run-time error.
When SET XACT_ABORT is ON, if a Transact-SQL statement raises a run-time error, the entire transaction is terminated and rolled back.
References: https://docs.microsoft.com/en-us/sql/t-sql/statements/set-xact-abort-transact-sql?view=sql- server-2017
- Question List (126q)
- Question 1: A table named Profits stores the total profit made each year...
- Question 2: You use Microsoft SQL Server to create a stored procedure as...
- Question 3: You administer a Microsoft SQL Server database that has Trus...
- Question 4: A local bank uses a SQL Server database to manage accounts. ...
- Question 5: DRAG DROP You use Microsoft SQL Server to develop a database...
- Question 6: You develop a Microsoft SQL Server database named ContosoDb....
- Question 7: SIMULATION You have a database that contains the tables as s...
- Question 8: DRAG DROP You use a Microsoft SQL Server database. You need ...
- Question 9: DRAG DROP You want to add a new GUID column named BookGUID t...
- Question 10: You administer a Microsoft SQL Server database. The database...
- Question 11: You create a table that has three columns named StudentCode,...
- Question 12: You administer a Microsoft SQL Server server. You plan to de...
- Question 13: You use Microsoft SQL Server to write code for a transaction...
- Question 14: You administer a Microsoft SQL Server database named Contoso...
- Question 15: You generate a daily report according to the following query...
- Question 16: You use Microsoft SQL Server to develop a database applicati...
- Question 17: Note: This question is part of a series of questions that us...
- Question 18: You create a table that has the StudentCode, SubjectCode, an...
- Question 19: SIMULATION You have an XML schema collection named Sales.Inv...
- Question 20: SIMULATION You have a database named SALES that stored the s...
- Question 21: You are a database developer for an application hosted on a ...
- Question 22: You administer a Microsoft SQL Server database named Contoso...
- Question 23: You administer a Microsoft SQL Server database named Contoso...
- Question 24: You are maintaining a SQL Server database that uses the defa...
- Question 25: You administer a Microsoft SQL Server database named Sales. ...
- Question 26: You are developing a database application by using Microsoft...
- Question 27: You use a contained database named ContosoDb within a domain...
- Question 28: SIMULATION You have a database that contains the tables as s...
- Question 29: You develop a Microsoft SQL Server database that contains a ...
- Question 30: SIMULATION You have a database named Sales that contains the...
- Question 31: You are a database developer of a Microsoft SQL Server datab...
- Question 32: You administer a Microsoft SQL Server instance that will sup...
- Question 33: You develop a Microsoft SQL Server database that contains a ...
- Question 34: Your database contains a table named Products that has colum...
- Question 35: SIMULATION You have a database named Sales that contains the...
- Question 36: DRAG DROP You use Microsoft SQL Server to develop a database...
- Question 37: You develop a Microsoft SQL Server database. You need to cre...
- Question 38: SIMULATION You have a database named Sales that contains the...
- Question 39: SIMULATION You have a view that was created by using the fol...
- Question 40: DRAG DROP You use Microsoft SQL Server to develop a database...
- Question 41: You develop a Microsoft SQL Server database. You create a vi...
- Question 42: SIMULATION You need to create a query that calculates the to...
- Question 43: You administer a Microsoft SQL Server database. The database...
- Question 44: SIMULATION You have a SQL database that contains a table nam...
- Question 45: A database named AdventureWorks contains two tables named Pr...
- Question 46: You develop a stored procedure for a wholesale glass manufac...
- Question 47: You use a Microsoft SQL Server database that contains a tabl...
- Question 48: You generate a daily report according to the following query...
- Question 49: You develop a Microsoft SQL Server database. You create a vi...
- Question 50: SIMULATION You have a data warehouse that contains the data ...
- Question 51: Note: This question is part of a series of questions that us...
- Question 52: You use Microsoft SQL Server to develop a database applicati...
- Question 53: You are a database developer of a Microsoft SQL Server datab...
- Question 54: You have a database that contains a table named Customer. Th...
- Question 55: DRAG DROP You need to create a query to execute a stored pro...
- Question 56: A table named Profits stores the total profit made each year...
- Question 57: You administer a Microsoft SQL Server database named Contoso...
- Question 58: You administer a Microsoft SQL Server database named Contoso...
- Question 59: You have three tables that contain data for dentists, psychi...
- Question 60: A table named Profits stores the total profit made each year...
- Question 61: Your application contains a stored procedure for each countr...
- Question 62: DRAG DROP You use Microsoft SQL Server to develop a database...
- Question 63: You use Microsoft SQL Server database to develop a shopping ...
- Question 64: You need to build a table structure for a stored procedure t...
- Question 65: You are a database developer of a Microsoft SQL Server datab...
- Question 66: You develop a Microsoft SQL Server database that has two tab...
- Question 67: You use Microsoft SQL Server to develop a database applicati...
- Question 68: You administer a Microsoft SQL Server database that supports...
- Question 69: You are developing a database that will contain price inform...
- Question 70: You develop three Microsoft SQL Server databases named Datab...
- Question 71: You create a table that has the StudentCode, SubjectCode, an...
- Question 72: You create a table that has the StudentCode, SubjectCode, an...
- Question 73: You are developing a database that will contain price inform...
- Question 74: You are working with a table that has an XML column that con...
- Question 75: You develop a Microsoft SQL Server database that contains a ...
- Question 76: You administer several Microsoft SQL Server database servers...
- Question 77: You administer a Microsoft SQL Server database named Contoso...
- Question 78: You are developing a database application by using Microsoft...
- Question 79: You administer a Microsoft SQL Server database. The database...
- Question 80: You administer a Microsoft SQL Server database that includes...
- Question 81: You are designing a table for a SQL Server database. The tab...
- Question 82: You use Microsoft SQL Server to develop a database applicati...
- Question 83: Your database contains tables named Products and ProductsPri...
- Question 84: SIMULATION You need to create a view named Sales.uv_Customer...
- Question 85: DRAG DROP You administer a Microsoft SQL Server database. Yo...
- Question 86: Your database contains a table named SalesOrders. The table ...
- Question 87: You have several SQL Server queries. You plan to optimize th...
- Question 88: You use Microsoft SQL Server to develop a database applicati...
- Question 89: You support a database structure shown in the exhibit. (Clic...
- Question 90: DRAG DROP You create a view based on the following statement...
- Question 91: You use Microsoft SQL Server to develop a database applicati...
- Question 92: You administer a Microsoft SQL Server database named Contoso...
- Question 93: SIMULATION You have an XML schema collection named Sales.Inv...
- Question 94: You are working with a table that has an XML column that con...
- Question 95: You have a vendor application that uses a scalar function. Y...
- Question 96: SIMULATION You have a database that contains the tables show...
- Question 97: You use Microsoft SQL Server 2012 database to develop a shop...
- Question 98: You administer a Microsoft SQL Server database that includes...
- Question 99: You use a Microsoft SQL Server database that contains a tabl...
- Question 100: You develop a database application for Microsoft SQL Server ...
- Question 101: You use a Microsoft SQL Server database. You want to create ...
- Question 102: The Agent table of a Microsoft SQL Server database contains ...
- Question 103: You are developing a database application by using Microsoft...
- Question 104: SIMULATION You need to create a table named OrderDetails on ...
- Question 105: You administer a Microsoft SQL Server database named Orders....
- Question 106: You administer a Microsoft SQL Server database that supports...
- Question 107: SIMULATION You create a table by using the following Transac...
- Question 108: DRAG DROP You maintain a SQL Server database that is used by...
- Question 109: SIMULATION You have a database that contains the tables as s...
- Question 110: You develop a Microsoft SQL Server database. The database is...
- Question 111: You create a table that has the StudentCode, SubjectCode, an...
- Question 112: You administer a Microsoft SQL Server database that has mult...
- Question 113: You create a table that has three columns named StudentCode,...
- Question 114: You develop a Microsoft SQL Server database that contains ta...
- Question 115: You use a Microsoft SQL Server database that contains a tabl...
- Question 116: You are developing a database application by using Microsoft...
- Question 117: You develop a Microsoft SQL Server server database that supp...
- Question 118: SIMULATION You have a database that contains the tables show...
- Question 119: You develop a Microsoft SQL Server database. The database co...
- Question 120: You administer a Microsoft SQL Server database that contains...
- Question 121: You plan to write a query for a new business report that wil...
- Question 122: You develop a Microsoft SQL Server database. You design a ta...
- Question 123: You have a Microsoft SQL Server database. The database conta...
- Question 124: DRAG DROP You create the following stored procedure. (Line n...
- Question 125: You use a Microsoft Azure SQL DataBase instance. The instanc...
- Question 126: You administer a Microsoft SQL Server database named Contoso...
