Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
What do the COMMIT and ROLLBACK statements in Oracle SQL do?
Home
Oracle
What do the COMMIT and ROLLBACK statements in Oracle SQL do?
0
votes
asked
Jan 21
in
Oracle
by
rajeshsharma
What do the COMMIT and ROLLBACK statements in Oracle SQL do?
rollback-statement
commit0statement
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Jan 21
by
rajeshsharma
The COMMIT statement saves all the changes made in a transaction to the database, making them permanent. The ROLLBACK statement undoes the changes in the transaction and reverts the database to its pre-transaction state.
Related questions
0
votes
Q: Write an Oracle SQL query to get the date and time of the last 10 logins for a specific user.
asked
Jan 21
in
Oracle
by
rajeshsharma
oraclesqlquery
0
votes
Q: How would you explain database roles and privileges in Oracle SQL security?
asked
Jan 21
in
Oracle
by
rajeshsharma
privileges-roles
oraclesqlsecurity
0
votes
Q: Differentiate between the WHERE clause and the HAVING clause in Oracle SQL.
asked
Jan 21
in
Oracle
by
rajeshsharma
havingclause
0
votes
Q: Explain the difference between RANK and DENSE_RANK functions in Oracle SQL.
asked
Jan 21
in
Oracle
by
rajeshsharma
dense_rank
+1
vote
Q: ORACLE SQL MCQ Questions and Answers
asked
Feb 19, 2023
in
Oracle
by
GeorgeBell
oracle
sql
mcq
questions
and
answers
0
votes
Q: Write an Oracle SQL query to ensure only users with the manager role can insert rows into the performance_reviews table.
asked
Jan 23
in
Oracle
by
SakshiSharma
oraclesqlquery
0
votes
Q: Write an Oracle SQL query to find the five most common names in the Employee table.
asked
Jan 23
in
Oracle
by
SakshiSharma
oracle-query
0
votes
Q: Write an Oracle SQL query to find the names of employees not assigned to any project.
asked
Jan 23
in
Oracle
by
SakshiSharma
oracle-sql
0
votes
Q: Write an Oracle SQL query to find employees who earn more than their managers.
asked
Jan 21
in
Oracle
by
rajeshsharma
oraclesqlquery
0
votes
Q: Write an Oracle SQL query to find the average salary of employees within each department.
asked
Jan 21
in
Oracle
by
rajeshsharma
oraclesqlquery
...