Interested to Buy Any Domain ? << Click Here >> for more details...
what is d diff between grant,commit,rollback n savepoint
- 1 Answers
- 8271 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 |
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
how do you know if your mysql server is alive? : Sql dba
What is sql key?
Why do we need databases?
Why stored procedures are faster than query?
How do you concatenate in sql?
Give the structure of the procedure ?
What are inner and outer joins examples of both?
what is error ora-03113: end-of-file on communication channel?
How many types of triggers are there in pl sql?
How do you pronounce sql?
What is cursor in pl sql with examples?
-
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)
