QuestionQ27

Database Fundamentals

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

  • A
  • B
  • C
  • D
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!