An application cancels a long-running statement inside an explicit transaction and leaves the session sleeping with open locks. Which setting can reduce the risk of this pattern during run-time errors by automatically aborting the transaction?
SET NOCOUNT ONSET XACT_ABORT ONSET ANSI_NULLS OFFSET QUOTED_IDENTIFIER OFFMore Secure, optimize, and deploy database solutions Questions
74 questions
Full Microsoft Certified: SQL AI Developer Associate Practice Test
All topics covered
All Microsoft Certified: SQL AI Developer Associate Questions
Browse by topic
Related Questions
A team builds a SQL database project from the command line. What is the default build artifact produ...
What is the main purpose of the target platform setting in a SQL database project's `.sqlproj` file?...
Which `SqlPackage` action incrementally updates an existing database so it matches the schema in a s...
An administrator opens Query Performance Insight for an Azure SQL Database, but Query Store is disab...
Which view should be checked first for near-real-time resource usage in Azure SQL Database over roug...
Educational Content — CertQnA practice questions are written against official exam objectives, covering the same domains tested on the real exam. All content is original and independent — not actual exam questions, not affiliated with any certification vendor. Learn more about our content policy
Discussion
Be the first to share your understanding of this concept
Sign in to join the discussion