Describe the definition of a transaction in sql, Database Management System

Assignment Help:

Describe the definition of a transaction in SQL

Ans: The SQL transaction starts implicitly. Transactions are finished by either Commit work that commits the transaction and starts a new one Rollback work that causes the transaction to abort.

If a program ends without either of these statements after that updates are either committed or rolled back and the selection is implementation dependent.

Related Discussions:- Describe the definition of a transaction in sql

What is predictive modelling, Problem: (a) Data mining is one of the b...

Problem: (a) Data mining is one of the best ways to analyse data and using software techniques, hidden and unexpected patterns and relationships in sets of data can be extrac

Attributes and tuple, Before we talk about the relational model in more det...

Before we talk about the relational model in more detail, let us first define some very basic terms used in this model. Tuple Every row in a table shows a record and is cal

Explain the structure of well formed formulae, Explain the structure of wel...

Explain the structure of well formed formulae in relational calculus. Ans: a. An atom is a formula b. If P1 is a formula, after that so are ¬P1 and (P1) c. If P1 and P2 a

Identify the critical activities, Consider a systems development project wi...

Consider a systems development project with the following data Activity Duration (weeks) Precedence Relationship 1. Software design

SQL, Ask Write the SQL code that will create the table structure for a tabl...

Ask Write the SQL code that will create the table structure for a table named EMP _1. This table is a subset of the EMPLOYEE table. The basic EMP_1 table structure is summarized in

Process of implementing system design in dynamic models, Process of impleme...

Process of implementing system design in dynamic models There are three essential approaches to implementing system design in dynamic models. These approaches are as below:

Give two profit of reuse of code, Give two profit of Reuse of Code. Re...

Give two profit of Reuse of Code. Reusing the implementation . Place existing class directly inside a new class. The new class can be made up of any number and type of the oth

Data Minnning, Can i get help with weka software

Can i get help with weka software

What is called query processing, What is called query processing? Query...

What is called query processing? Query processing refers to the range of activities included in extracting data from a database.

Explain disadvantages of a dbms, Question : (a) Database Management Sy...

Question : (a) Database Management Systems (DBMS) is the foundation of business intelligence. Explain the following concepts related to DBMS: (i) Entity Relationship Diagr

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages