affiliate marketing Interview Qns: DCL
Showing posts with label DCL. Show all posts
Showing posts with label DCL. Show all posts

Monday, October 25, 2010

DCL is Data Control Language statements. Some examples:

  • COMMIT - save work done
  • SAVEPOINT - identify a point in a transaction to which you can later roll back
  • ROLLBACK - restore database to original since the last COMMIT
  • SET TRANSACTION - Change transaction options like what rollback segment to use