Interested to Buy Any Domain ? << Click Here >> for more details...
what is d diff between grant,commit,rollback n savepoint
- 1 Answers
- 8298 Views
- I also Faced
- E-Mail Answers
Answer / priya ramesh
grant - it is a statement of DCL (DATA CONTROL LANG)
granting previleges to the user
Commit,Rollback and savepoint are the statements of TCL (TRANSACTION CONTROL LANG)
Commit - Makes a permanent change to the data in the database
Rollback - The changes made in the data can be undone using roll back statement
savepoint - The point upto which the data can be commited while the rest of the datas can be rollbacked as necessary
| Is This Answer Correct ? | 3 Yes | 1 No |
How many databases can sql express handle?
What is normalization? How many normalization forms are there?
how to use like conditions? : Sql dba
Advantages and disadvantages of stored procedure?
What is procedure and function in sql?
What is the starting oracle error number?
What is the best free sql database?
What is Materialized View? In What Scenario we Use Materialized View?
What is the difference between in and between in sql?
What is the usage of sql functions?
What is the purpose of a sql?
What is where clause in sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
