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

how can we destroy the cookie? : Sql dba

1 Answers  

---

Name some usages of database trigger?

1 Answers  

---

How can you tell the difference between an index and a view?

1 Answers  

---

How do sql databases work?

1 Answers  

---

What is the difference between DELETE and TRUNCATE?

15 Answers   Johns Hopkins University, Tech Mahindra,

---

Is it mandatory for the primary key to be given a value when a new record is inserted?

1 Answers  

---

Where is sql database stored?

1 Answers  

---

Can triggers stop a dml statement from executing on a table?

1 Answers  

---

What is sql*loader?

1 Answers  

---

How many times can we commit in a loop?

1 Answers  

---

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

---

What is a trigger in sql?

1 Answers  

---