Answer Posted / baburav zore

select max(sal) from employee where sal<(select sal from employee);

How many sql statements are used? Define them.

1039

---

What do you mean by dbms? What are its different types?

1018

---

What is string data type in sql?

1144

---

What is the use of desc in sql?

977

---

What is the default isolation level in sql server? : Transact sql

1024

---

Is sql low level language?

1021

---

How do you truncate?

907

---

What is the difference between the conventional and direct path loads? : aql loader

1400

---

What does cursor do in sql?

1025

---

Why do we need a foreign key?

1098

---

What is the limitation on the block size of pl/sql?

987

---

what are the differences among rownum, rank and dense_rank? : Sql dba

1040

---

What is sqlexception in java?

993

---

What is schema in sql?

949

---

How does stored procedure reduce network traffic?

1009

---