No user-defined locks are used in your database.Which three are true about Transaction Control Language (TCL)? (Choose t

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

No user-defined locks are used in your database.Which three are true about Transaction Control Language (TCL)? (Choose t

Post by answerhappygod »

No user-defined locks are used in your database.Which three are true about Transaction Control Language (TCL)? (Choose three.)

A. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes, releases its locks, and erases all its savepoints.
B. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not release its locks.
C. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not erase its savepoints.
D. ROLLBACK TO SAVEPOINT undoes the transaction's changes made since the named savepoint and then ends the transaction. E. COMMIT ends the transaction and makes all its changes permanent. F. COMMIT erases all the transaction's savepoints and releases its locks.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply