Interested to Buy Any Domain ? << Click Here >> for more details...
what is d diff between grant,commit,rollback n savepoint
- 1 Answers
- 8451 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 |
What is the sql query to display the current date?
What is constant in pl sql?
What are the PL/SQL Statements used in cursor processing ?
what is a database lock ? : Sql dba
Why do we use partitions in sql?
What are the built in functions of sql?
Define tables and fields in a database
What is sql prepared statement?
Can we have exception part in trigger ?
What do you mean by dbms? What are its different types?
How do I enable sql encryption?
Whis is not false in primary key?
-
Oracle (3253) - 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)
