A Guide to SQL
A Guide to SQL
9th Edition
ISBN: 9781111527273
Author: Philip J. Pratt
Publisher: Course Technology Ptr
Question
Chapter 6, Problem 8RQ
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.

Blurred answer
Students have asked these similar questions
Use AverageIFS to calculate the average dollar amount of the paid in full transactions over $4,000 in J5.
how to give execute right for all store procedure in a database to AD account by creating role? please step by step script. #sqlserver #database
Create a simple transaction to Delete an employee having ID = 203 (e.g.) and commit the changes. Use employees table on SQL server?
Knowledge Booster
Recommended textbooks for you
  • A Guide to SQL
    Computer Science
    ISBN:9781111527273
    Author:Philip J. Pratt
    Publisher:Course Technology Ptr
    Oracle 12c: SQL
    Computer Science
    ISBN:9781305251038
    Author:Joan Casteel
    Publisher:Cengage Learning
  • A Guide to SQL
    Computer Science
    ISBN:9781111527273
    Author:Philip J. Pratt
    Publisher:Course Technology Ptr
    Oracle 12c: SQL
    Computer Science
    ISBN:9781305251038
    Author:Joan Casteel
    Publisher:Cengage Learning