Interested to Buy Any Domain ? << Click Here >> for more details...
what is d diff between grant,commit,rollback n savepoint
- 1 Answers
- 8361 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 normalization means?
What is implicit cursor in pl sql?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
how tsql statements can be written and submitted to the database engine? : Transact sql
State some properties of relational databases?
What does where 1 1 mean in sql?
What are two parts of package ?
How is sql used in oracle?
what is heap table? : Sql dba
What is a Mapplet?
What is scalar function?
Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index
-
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)
