Can we perform rollback after commit command in SQL | SoftwaretestingbyMKT | SQL interview questions

To join my upcoming courses/classes please fill below form

Join this channel to get access to perks:

Like, share and subscribe to the channel.
API Testing Playlist

Core Java Playlist

Selenium Playlist

Manual testing Playlist

Watch my other videos too,
Inheritance in Java video

Single level inheritance video

Multi Level Inheritance in Java video

Hierarchical Level Inheritance in Java video

Hybrid Level Inheritance in Java video

Method Overloading in Java video

This calling statement in Java or this() video

Constructor Overloading in Java video

Constructor in Java video

Static and Non Static Variables in Java video

How to Create an Object in Java & Handing non Static method video

Multiple static methods inside a single Class | How to deal it?

Methods in Java | What exactly is public static void main(String[] args)

Types of Variables in Java | Local,Global & Final Variables

Variable and Datatype in Java

Easy way to run a program in Java | First program in Java

Class and Object in java

50 Keywords in Java

Tokens in Java

How Java internally works?| Compilation & Interpretation

Introduction to Java | History of Java |Features of Java
Derived model in software development life cycle video link

Prototype model in software development life cycle video link

Spiral model in software development life cycle video link

Verification and Validation in software development life cycle video

Hybrid model in software development life cycle video video

Waterfall model in software development video link

Software development life cycle video link

What is manual testing, it's advantages and disadvantages video link

What is Software testing video link

I work in the IT industry as a Senior Software QA Engineer in Bangalore, India and I have worked on mobile applications, web applications, and API testing.
The main reason behind this channel is to educate people about software testing so that it will helpful for them to choose the right career and also to prepare for their interviews.

Adding my blog link

Adding my personal mail Id:

Adding my Quora profile link here:

Adding my Twitter account here,
or
Facebook Page:

Join us on Telegram today,
SoftwaretestingbyMKT
For the latest update on software jobs and to discuss each and everything about Software Testing also get an opportunity to get on an audio/video call with me directly to you.
I make videos on daily basics and also help student all over the world for FREE. If my videos are helpful in anyway help "SoftwaretestingbyMKT" reach billions by supporting
OR

[rahulgoyal]

It is better if you give answer in comment section instead of pin.
this will save our time🙏

[naveenp]

COMMIT permanently saves the changes made by the current transaction. ROLLBACK undo the changes made by the current transaction. 2. The transaction can not undo changes after COMMIT execution

[rupamsingh]

The Answer is No.
Rollback is simply UNDO process to the DML query.
COMMIT is saving the changes to server DB which is the final db where you can not manipulate.
After Commit you can not rollback this commit command is the final

[vijaykounsalye]

No, once a commit command is executed in SQL, the changes made to the database become permanent and cannot be rolled back. The commit command finalizes the transaction and makes the changes permanent. If you need to undo changes after a commit, you would need to manually reverse them using appropriate SQL statements or restore the database from a backup if available.

[sachindukre]

Yes, we can rollback, but before commit we use bigin transition used then commit

[poojapanchgade]

No we cannot rollback after commit because commit save permently in the database nd rollback undo the statement.

[KingRish]

Yes, but only with prerequisite of SET AUTOCOMMIT= False.

[sunilpanda]

No, after commit the data parmanent store in the data base .So if we hit rollback the transaction not canceled. ...

[swapnilchougule]

yes. insert, commit, savepoint, rollback.

[payalthakur]

For DML command we can able to perform rollback command, but for DDL we don't have functionality to for rollback

[rdskitchen]

Only Admin can roll back a committed comand.

[crazyvideos]

.The changes which we have made after commit can be rollback but the changes which we have made before commit cannot be roll back.

[m.s.k]

We can do but no changes done on table

[punithankarthi]

Commit-permenatly save

Rollback-change Or undo query statement

[katamdevaranagavani]

No, after commit can't perform rollback because commit going to permenent database

[kethavaththirupathi]

No commit performs permanently delete data selected.

[princesinha]

No it can't be performed. Once committed rollback won't undo.

[GovindahariGovindahari]

First use the commit and after use the rollback

[harik]

Yes, there is a dirty way to do this

If checkpoint is not done,
you can trick SQL server to ignore changes made by the transaction

But it is not as simple as running a roll back command

And it might affect changes made by earlier transactions as well

[thrishalufitha]

By using rollback command.. before u commit