Answer Posted / baburav zore

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

What is the use of nvl function?

624

---

what is not null constraint? : Sql dba

555

---

What is record in pl sql?

599

---

What is rollback?

590

---

What is raid? How does it help storage of databases?

607

---

---

What is the non-clustered index in sql?

594

---

What is structural independence and why is it important?

551

---

Can you rollback after commit?

532

---

What are stored procedures used for?

537

---

Why truncate is faster than delete?

567

---

How to make a copy values from one column to another in sql?

582

---

Where is pl sql used?

521

---

How can I delete duplicate rows?

567

---

What do you mean by query optimization?

552

---

what are the performance and scalability characteristics of mysql? : Sql dba

534

---