0
Rolls back security settings to the previously configured settings.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
Which command will delete all data from a table and will not write to the rollback segment?
Truncate since it is DDL command
What is the command to retrieve deleted data from any table in SQL?
rollback command can retrieve deleted data from a table, provided commit has not been performed after deleting the data. both rollback and commit are transaction control statements.
Use of commit and rollback in oracle?
In Oracle, you can insert rows, update rows or delete rows from tables, but the changes are only current to your session. That means that if you insert a row in a table, no other users will be able to see it until you enter a COMMIT command. If you should enter or delete information by mistake, you have the chance to undo your changes by using the ROLLBACK command. The ROLLBACK will undo changes to data since the last COMMIT was executed.
What is the difference between drop and truncate in dbms?
even though both these commands are related to the structure of the table...,we can regain the data when we use use drop command by use of rollback command but its not possible in the case of truncate command.
When did Special Purpose Command end?
Special Purpose Command ended in 2009.
When was Special Purpose Command created?
Special Purpose Command was created in 2002.
What is the meaning of rollback?
Rollback is lowering the price to an earlier price for an item.
What is the purpose of the AS command in SQL?
If you are in search of learning the purpose of the AS command in SQL, there are a few resources that are available to you. One resource that can explain the purpose of the AS command in SQL is Wikipedia.
When was Rollback - novel - created?
Rollback - novel - was created in 2007-04.
How many pages does Rollback - novel - have?
Rollback - novel - has 320 pages.
What is the difference between rollback and savepoint in sql with examples?
Rollback:This is used for undoing the work done in the current transaction. This command also releases the locks if any hold by the current transaction. The command used in SQL for this is simply:ROLLBACK;Savepoint:This is used for identifying a point in the transaction to which a programmer can later roll back. That is it is possible for the programmer to divide a big transaction into subsections each having a savepoint defined in it. The command used in SQL for this is simply:SAVEPOINT savepointname;For example:UPDATE…..DELETE….SAVEPOINT e1;INSERT….UPDATE….SAVEPOINT e2;……It is also possible to define savepoint and rollback together so that programmer can achieve rollback of part o a transaction. Say for instance in the aboveROLLBACK TO SAVEPOINT e2;This results in the rollback of all statements after savepoint e2Commit:This is used to end the transaction and make the changes permanent. When commit is performed all save points are erased and transaction locks are released. In other words commit ends a transaction and marks the beginning of a new transaction. The command used in SQL for this is simply:COMMIT;
What is the purpose of version control?
It allows developers to update a program and keep track of the changes. It also allows them to rollback to a previous version if bad code was introduced.
