What Do You Know About Transaction Control Language?

10 Questions | Total Attempts: 182

SettingsSettingsSettings
Please wait...
What Do You Know About Transaction Control Language?

Transaction control language, or TCL, is a language used in managing different transactions occurring within a database. Transaction control commands are primarily used for managing changes affecting the SQL data. Take this quiz to find out more.


Questions and Answers
  • 1. 
    In which of the following events can a transaction event occur?
    • A. 

      When making payments

    • B. 

      Using credit cards

    • C. 

      Connecting to Oracle

    • D. 

      Account opening

  • 2. 
    What statement marks and save the current transaction points? 
    • A. 

      Save as

    • B. 

      Savepoint

    • C. 

      Save

    • D. 

      Commit

  • 3. 
    A transaction can be closed either by a commit or ____ statement?
    • A. 

      Rastar

    • B. 

      HTML

    • C. 

      Rollback

    • D. 

      Save as

  • 4. 
    Which of these transactions control statement makes all changes permanent? 
    • A. 

      SAVEPOINT

    • B. 

      COMMIT

    • C. 

      ROLLBACK

    • D. 

      All of the above

  • 5. 
    The use of certain forms of the COMMIT and ___ commands are restricted in PL/SQL.
    • A. 

      ROLLBACK

    • B. 

      SAVEPOINT

    • C. 

      SETTRANSACTION

    • D. 

      None

  • 6. 
    Transaction control language is a/an ___ command.
    • A. 

      HTML

    • B. 

      COBOL

    • C. 

      Java

    • D. 

      SQL

  • 7. 
    Which of these TCL commands save the work done?
    • A. 

      Save

    • B. 

      Commit

    • C. 

      Set

    • D. 

      None

  • 8. 
    Transaction control language manages changes made by...
    • A. 

      DCL

    • B. 

      DDL

    • C. 

      DML

    • D. 

      HTML

  • 9. 
    Once we commit, we cannot rollback.
    • A. 

      True

    • B. 

      False

    • C. 

      Particularly depends

    • D. 

      None

  • 10. 
    All of these are transaction control language statements except one.
    • A. 

      Save

    • B. 

      Commit

    • C. 

      Rollback

    • D. 

      Savepoint

Back to Top Back to top