36 questions for “Transactions & ACID”

Found in 1 field. Select a question to see its full answer.

Matching topics

SQL Server Transactions & ACID 7

Information Technology

36 questions in 2 technologies

#QuestionTechnologyTopicLevel
1What does ACID stand for, and what does each letter represent in the context of database transactions? SQL Server › Transactions & ACIDSQL ServerTransactions & ACIDBeginner
2How do long running transactions negatively impact overall system performance, and what strategies help avoid this problem? SQL Server › Transactions & ACIDSQL ServerTransactions & ACIDAdvanced
3What is a transaction in SQL Server, and why is grouping multiple statements into one important? SQL Server › Transactions & ACIDSQL ServerTransactions & ACIDBeginner
4How do you use a SAVE TRANSACTION savepoint within a larger transaction to allow partial rollback of just a portion of the work? SQL Server › Transactions & ACIDSQL ServerTransactions & ACIDIntermediate
5What is the difference between an implicit and an explicit transaction in SQL Server? SQL Server › Transactions & ACIDSQL ServerTransactions & ACIDIntermediate
6How do you check whether a transaction is currently active and view its properties within a session? SQL Server › Transactions & ACIDSQL ServerTransactions & ACIDIntermediate
7How would you design a distributed transaction that needs to span operations across two different database servers, and what additional complexity does this introduce? SQL Server › Transactions & ACIDSQL ServerTransactions & ACIDAdvanced
8What are the three main types of backups in SQL Server, and what does each one capture? SQL Server › Backup & RecoverySQL ServerBackup & RecoveryBeginner
9How do you restore a SQL Server database from a full backup file? SQL Server › Backup & RecoverySQL ServerBackup & RecoveryBeginner
10How does a TRY CATCH block work in SQL Server, and why is it useful? SQL Server › Error Handling with TRY CATCHSQL ServerError Handling with TRY CATCHBeginner
Show all 36 questions in Information Technology