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

what is SCALAR Queries?

2 Answers   ITC Infotech,

---

what is the difference between cluster and non cluster index? : Sql dba

0 Answers  

---

What is the usage of when clause in trigger?

0 Answers  

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

full outer join syntax

5 Answers  

---

---

What is query execution plan in sql?

0 Answers  

---

What are tables and fields?

0 Answers  

---

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

8 Answers   CGCI,

---

What are the disadvantages of not performing database normalization?

0 Answers  

---

Does a primary key have to be a number?

0 Answers  

---

What is the file extension for sql database?

0 Answers  

---

What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers   TCS,

---