Answer Posted / saraswathi muthuraman

SQL> select * from emp_test order by sal desc;

1003 20010 11
1001 10000 11
1001 10000 11
1002 100 11
1004 99 11
1005 50 11
1006 25 11

SQL> select * from (select emp_no,dep_no,sal,rank() over
(order by sal desc) as rank_list from emp_test) where
rank_list =5;

1004 11 99 5

What is Set-at-a-time or Set-oriented?

908

---

What are the three levels of database architecture?

753

---

What is an Entity set?

921

---

What is a Phantom Deadlock?

990

---

What is DML Compiler?

999

---

What is 4NF?

914

---

What is "transparent DBMS"?

869

---

What is Fully Functional dependency?

966

---

How one call ddl statement using stored procedures in oracle?

803

---

What is Query evaluation engine?

953

---

What is end user data?

811

---

What are the the Advantages of DBMS?

848

---

What are the 3 levels of data abstraction?

848

---

State the different extensions for stored procedures?

814

---

Can we use commit inside the trigger? If not then how can we save the transaction made by the trigger?

852

---