QuestionQ27

VerifiedDatabase Fundamentals

A database administrator needs to delete inactive customers from a database. Which of the following statements should the administrator use?

Explanation

An explicit Transact-SQL transaction begins with BEGIN TRANSACTION and is completed with COMMIT (or ROLLBACK). Thus, the deletion of the customer with customer_ID = 20 is correctly performed and committed by the valid transaction statement.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!