Answer Posted / santosh

select level,max(sal) from emp where level=3 connect by
prior sal>sal
group by level;

What is sql deadlock?

565

---

What are different types of indexes?

512

---

Why we use sql profiler?

562

---

What is a database? Explain

598

---

what is view? : Sql dba

558

---

---

what is data manipulation language? : Sql dba

531

---

What are inbuilt functions in sql?

602

---

How do you drop a trigger?

542

---

Explain polymorphism in pl/sql.

641

---

How do I write a cron which will run a sql query and mail the results to agroup?

527

---

What are few of the schema objects that are created using PL/SQL?

561

---

What are types of exception?

540

---

What is the usage of distinct keyword?

632

---

What is the use of index in sql?

561

---

What are local and global Indexes and where they are useful.

930

---