70-433 · Question #107
70-433 Question #107: Real Exam Question with Answer & Explanation
The correct answer is C. BEGIN TRANSACTION Delete_Candidate WITH MARK. BEGIN { TRAN | TRANSACTION } [ { transaction_name | @tran_name_variable } [ WITH MARK [ 'description' ] ] WITH MARK [ 'description' ] - specifies that the transaction is marked in the log. description is a string that describes the mark. If WITH MARK is used, a transaction name m
Question
Options
- ABEGIN TRANSACTION
- BBEGIN TRANSACTION WITH MARK N'Deleting a Job Candidate';
- CBEGIN TRANSACTION Delete_Candidate WITH MARK
- DDECLARE @CandidateName varchar(50) = 'Delete_Candidate'
Explanation
BEGIN { TRAN | TRANSACTION } [ { transaction_name | @tran_name_variable } [ WITH MARK [ 'description' ] ] WITH MARK [ 'description' ] - specifies that the transaction is marked in the log. description is a string that describes the mark. If WITH MARK is used, a transaction name must be specified. When restoring a database to an earlier state, the marked transaction can be used in place of a date and time. The mark is placed in the transaction log only if the database is updated by the marked Transactions that do not modify data are not marked. BEGIN TRAN new_name WITH MARK can be nested within an already existing transaction that Upon doing so, new_name becomes the mark name for the transaction, despite the name that the transaction may already have been given.
Community Discussion
No community discussion yet for this question.