Answer Posted / srinu

SELECT * FROM EMP WHERE SAL=(SELECT MIN(SAL) FROM ( SELECT
DISTINCT(SAL) FROM EMP ORDER BY SAL DESC) WHERE ROWNUM<'&N');

ANS::

EMPNO ENAME JOB MGR HIREDATE SAL
COMM DEPTNO
------ ---------- --------- ---------- --------- ----------
---------- ----------
7566 JONES MANAGER 7839 02-APR-81 2975
20

SELECT * FROM EMP WHERE SAL=(SELECT MIN(SAL) FROM ( SELECT
SAL FROM EMP ORDER BY SAL DESC) WHERE ROWNUM<'&N');



EMPNO ENAME JOB MGR HIREDATE SAL
COMM DEPTNO
------ ---------- --------- ---------- --------- ----------
---------- ----------
7788 SCOTT ANALYST 7566 19-APR-87 3000
20
7902 FORD ANALYST 7566 03-DEC-81 3000
20

What is index and also explain types of indexing in dbms?

970

---

How does index hunting help in improving query performance?

942

---

What do you mean by DBMS?

977

---

Have you written applications to retrieve stored images in a table?

1021

---

What are indexes? Mention the differences between the clustered and non-clustered index?

965

---

What are the database skills?

961

---

What is entity and its types?

918

---

Is google a database?

1184

---

What are the ways to tune reporting services?

1001

---

write a query to retrieve the last day of next month in oracle.

934

---

What are data modelling tools?

915

---

Why is foreign key used?

833

---

When should you consider denormalization?

978

---

Write a query to create a duplicate table with and without data present?

857

---

Explain vdl (view definition language)?

1032

---