BuyFindarrow_forward

A Guide to SQL

9th Edition
Philip J. Pratt
Publisher: Course Technology Ptr
ISBN: 9781111527273
Chapter 6, Problem 8RQ
Textbook Problem
303 views

How do you use the COMMIT and ROLLBACK commands to support transactions?

Program Plan Intro

SQL:

  • SQL stands for “Structured Query Language”.
  • The current version of SQL is “ANSI SQL – 92”.
  • SQL is not a programming language. It is text-based and it is also called as data sublanguage.
    • In order to get SQL as a complete programming language, it should be included in scripting languages like Java, C#, and so on.
  • It contains constructs which are used to define and process database. They are executed using DBMS-supplied command prompt.
  • Some of the DBMS products provide GUI tools in order to perform tasks are as follows:
    • SQL Server
    • Oracle Database
    • MySQL

 Transaction Control Language (TCL):

  • These statements are used to control transactions. The commands of TCL are: Commit, Rollback, and Savepoint.

COMMIT:

The “commit” keyword is used to save the recently inserted columns in the table and current transaction.

  • It also makes permanent changes performed in the transaction.
  • It comes under the control transactions commands.

 ROLLBACK:

  • The “ROLLBACK” command can only be used to reverse transaction since last “ROLLBACK” or “COMMIT” command was supplied.
  • The “ROLLBACK TRANSACTION” is used to reverse update that have not already been saved to the database in the SQL server.

Explanation of Solution

 Use of “COMMIT” and “ROLLBACK” commands to support transaction:

  • Before going to start the updates for a transaction, commit any earlier updates by executing the “COMMIT” command and then complete the updates for the transaction...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Chapter 6 Solutions

A Guide to SQL
Show all chapter solutions
add
Ch. 6 - Which command and clause changes the...Ch. 6 - Which command deletes a table and all its data?Ch. 6 - Microsoft Access supports make-table queries. What...Ch. 6 - Use SOL to make the following changes to the TAL...Ch. 6 - Insert into the NONGAME table the item number,...Ch. 6 - In the NONGAME table, change the description of...Ch. 6 - In the NONGAME table, increase the price of each...Ch. 6 - Add the following item to the NONGAME table: item...Ch. 6 - Delete every item in the NONGAME table for which...Ch. 6 - In the NONGAME table, change the category for item...Ch. 6 - Add a column named ON_HAND_VALUE to the NONGAME...Ch. 6 - In the NONGAME table, increase the length of the...Ch. 6 - Remove the NONGAME table from the TAL Distributors...Ch. 6 - Use the Internet to find the SQL command to delete...Ch. 6 - Use SQL to make the following changes to the...Ch. 6 - Insert into the PADDLING table the trip ID, trip...Ch. 6 - For all trips located in Connecticut (CT),...Ch. 6 - Insert a new trip into the PADDLING table. The...Ch. 6 - Delete the trip in the PADDLING table with the...Ch. 6 - The distance for the Pontook Reservoir Tour trip...Ch. 6 - Add to the PADDLING table a new character column...Ch. 6 - Change the DIFFICULTY_LEVEL column in the PADDLING...Ch. 6 - Change the length of the SEASON column in the...Ch. 6 - Change the DIFFICULTY_LEVEL column in the PADDLING...Ch. 6 - Delete the PADDLING table from the database.Ch. 6 - Use the Internet to research another data type...Ch. 6 - Use SQL to make the following changes to the...Ch. 6 - Insert into the LARGE_CONDO table the location...Ch. 6 - Solmaris has increased the condo fee of each large...Ch. 6 - After increasing the condo fee of each large condo...Ch. 6 - Insert a row into the LARGE_CONDO table for a new...Ch. 6 - Delete all condos in the LARGE_CONDO table for...Ch. 6 - The condo in location 1 and unit 503 is in the...Ch. 6 - Add to the LARGE_CONDO table a new character...Ch. 6 - Change the OCCUPIED column in the LARGE_CONDO...Ch. 6 - Change the CONDO_FEE column in the LARGE_CONDO...Ch. 6 - Delete the LARGE_CONDO table from the database.Ch. 6 - Use the Internet to research another data type...

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
What is PCI DSS and why is it important for information security?

Principles of Information Security (MindTap Course List)

As we explained in Chapter 7, the air resistance to the motion of a vehicle is something important that enginee...

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

Describe the TVA worksheet. What is it used for?

Management Of Information Security

Solve Problem 8.2-2 by the ultimate strength method (use the tables in Part 7 of the Manual.)

Steel Design (Activate Learning with these NEW titles from Engineering!)

What are the three form factors for servers?

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

Why must the electrode holder be correctly sized?

Welding: Principles and Applications (MindTap Course List)