Quiz-summary
0 of 10 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
Information
Are you able to resolve today’s SQL quiz?
This week’s test has a difficulty level of: MODERATE
Quiz subject: Introduction to transactions
If you are not familiar with all the concepts, you can get documented from here: https://www.sqlbythebook.com/2015/11/19/transactions-introduction/
Good luck!
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 10 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- Answered
- Review
-
Question 1 of 10
1. Question
A transaction is a single unit of work. If something inside the transaction goes wrong, nothing else is committed anymore.
Correct
Incorrect
-
Question 2 of 10
2. Question
An user can be in control of the system transactions, but only if he has full administrative permissions on the server.
Correct
Incorrect
-
Question 3 of 10
3. Question
Which of the following are key terms in the context of a transaction?
Correct
Incorrect
-
Question 4 of 10
4. Question
Which of the following T-SQL commands are correct in the context of a transaction?
Correct
Incorrect
-
Question 5 of 10
5. Question
Which of the following are the properties of a transaction?
Correct
Incorrect
-
Question 6 of 10
6. Question
Which of the following is the correct definition for @@TRANCOUNT?
Correct
Incorrect
-
Question 7 of 10
7. Question
Which of the following are possible values for XACT_STATE() function?
Correct
Incorrect
-
Question 8 of 10
8. Question
Which of the following is used to enforce the durability of a transaction in SQL Server?
Correct
Incorrect
-
Question 9 of 10
9. Question
Which of the following is used to enforce the isolation of a transaction in SQL Server?
Correct
Incorrect
-
Question 10 of 10
10. Question
Which of the following is used to enforce the consistency of a transaction in SQL Server?
Correct
Incorrect