what is d diff between grant,commit,rollback n savepoint
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 sql basics?
What are different clauses used in sql?
What are sql functions? Describe the different types of sql functions?
Sql technical questions
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
What is primary key secondary key alternate key candidate key?
What is sql partition function?
I need a function for a train ticket reservation please answer it thanks in advance
What is insert command in sql?
While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?
What schema means?
What is procedure explain with program?
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)