Login using Social Account
Login using your credentials
What are the valid ways of performing a transaction in MySQL?
Each statement is always a transaction in itself.
A transaction can be started with 'start transaction' when autocommit = 0.
Transaction is always open when autocommit = 0 until committed or rollbacked.
Each statement is always a transaction in itself when a new session of MySQL is started.
A transaction can be started with 'start transaction' when autocommit = 1.
Taking you to the next exercise in seconds...
Stay here Next Exercise
Want to create exercises like this yourself? Click here.
Note - Having trouble with the assessment engine? Follow the steps listed here
1 Introduction to DataBases
2 Introduction to SQL
3 Getting started with MySQL
4 Connecting to MySQL through Jupyter Notebook
5 Introduction to Database Systems
6 Can Data be ported to another database?
7 What is SQL?
8 MySQL Database Terminology
9 Unique keys vs Primary keys
10 Examples of RDBMS
11 MySQL from Developers' Perspective
12 MySQL Data Types
13 MySQL Data Types ... continued
14 MySQL Data Types ... continued
15 Creating and Dropping a table
16 Inserting data into a table
17 Assessment Question - SQL Insert
18 Selecting data from a table
19 Filtering - WHERE clause
20 Updating data in a table
21 Deleting data from a table
22 Sorting the query results
23 Joins - Selecting from multiple tables
24 Self-Joins
25 Outer Joins
26 Subquery
27 Inner SELECT
28 Inline SELECT
29 Aggregate Functions
30 Grouping on Aggregate Functions
31 HAVING clause
32 Constraint Keys on Tables - Primary and Unique Key
33 Quiz Question - SQL Create simple table
34 Quiz Question - SQL Create table
35 Constraint Keys on Tables - Foreign Key
36 Prepare data for Questions
37 Quiz Question - SQL Select - Employees having "k" in name
38 Quiz Question - SQL Select - Employees Joined in Oct
39 Quiz Question - SQL Select - Monthwise employees induction
40 Quiz Question - SQL Select - Department City Wise Employees
41 Quiz Question - SQL Select - Employees Department for a salary strata
42 Quiz Question - SQL Select - Similar Employees
43 Quiz Question - SQL Select - Report
44 ALTER Command
45 Quiz Question - SQL Alter
46 Indexes
47 Quiz Question - SQL Create Index
48 Transactions in MySQL
49 Quiz Question - Facts Check
50 Temporary Tables
51 ACID Properties in DBMS
52 Transaction Isolation Levels
53 Quiz Question - Facts Check
54 Quiz Question - Facts Check
55 Installing MySQL on your machine
56 Managing MySQL Database
57 SQL - Database Engine can be changed permanently ...
58 Default transaction isolation level
59 OS process of MySQL
60 SQL Tutorial - A user can shutdown the MySQL Server
61 Getting database information
Loading comments...