Answer Posted / nagireddy karri

select min(emp_sal) from (select (Emp_sal) from(select
Emp_sal from emp order by emp_sal desc) and rownum<=5)

What is Record-at-a-time?

837

---

What is the difference between layer and tier?

891

---

What is a business logic layer?

792

---

Explain about the difficulties faced by the database developer in implementing pre compiled statements?

720

---

What is a checkpoint and When does it occur?

774

---

What is one tier architecture?

767

---

Explain what are the restrictions that views have to follow? : sql server architect

826

---

Why fastload support to empty table?

1693

---

What is 5NF?

827

---

What is Data Model?

985

---

What are external procedures ? Why and when they are used?

847

---

Illustrate physical database architecture in brief? : sql server architect

760

---

Explain about the process which takes place to execute a stored routine?

748

---

What is the difference between a user defined function and a stored procedure?

866

---

Explain what are the database objects? : sql server architect

922

---