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 SQL
2 Getting started with MySQL
3 Assessment Question - Login to MySQL Database
4 Assessment Question - Connecting to MySQL
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 Inline SELECT
28 Aggregate Functions
29 Grouping on Aggregate Functions
30 HAVING clause
31 Constraint Keys on Tables - Primary and Unique Key
32 Quiz Question - SQL Create simple table
33 Quiz Question - SQL Create table
34 Constraint Keys on Tables - Foreign Key
35 Prepare data for Questions
36 Quiz Question - SQL Select - Employees having "k" in name
37 Quiz Question - SQL Select - Employees Joined in Oct
38 Quiz Question - SQL Select - Monthwise employees induction
39 Quiz Question - SQL Select - Department City Wise Employees
40 Quiz Question - SQL Select - Employees Department for a salary strata
41 Quiz Question - SQL Select - Similar Employees
42 Quiz Question - SQL Select - Report
43 ALTER Command
44 Quiz Question - SQL Alter
45 Indexes
46 Quiz Question - SQL Create Index
47 Temporary Tables
48 Transactions in MySQL
49 Quiz Question - Facts Check
50 Database Export
51 Database Import
52 Quiz Question - Facts Check
53 Quiz Question - Facts Check
54 Quiz Question - Facts Check
55 Quiz Question - Facts Check
56 Quiz Question - Facts Check
57 ACID Properties in DBMS
58 Transaction Isolation Levels
59 Quiz Question - Facts Check
60 Quiz Question - Facts Check
61 Installing MySQL on your machine
62 Managing MySQL Database
63 SQL - Database Engine can be changed permanently ...
64 Default transaction isolation level
65 OS process of MySQL
66 SQL Tutorial - A user can shutdown the MySQL Server
67 Creating and dropping database
68 Getting database information
Loading comments...