Answer / 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

Answer / siva kumar

select rownum,empno,ename,sal from(select * from emp order by
sal desc)group by rownum,empno,ename,sal having rownum='&n'

Answer / xxx

SELECT * FROM EMP WHERE N=(SELECT COUNT(DISTINCT SAL) FROM EMP
WHERE SAL>=e.SAL);

Answer / welcomeashwin

SELECT * FROM HR.EMPLOYEES EMP1
WHERE &N=(
SELECT COUNT(DISTINCT(SALARY))
FROM HR.EMPLOYEES EMP2
WHERE EMP1.SALARY<=EMP2.SALARY
);

Explain the terms ‘record’, ‘field’ and ‘table’ in terms of database.

0 Answers  

---

Are Constraints exported through Export command?

1 Answers  

---

What do you mean by e-r model & object-oriented model?

0 Answers  

---

What is metadata and why should I use it?

0 Answers  

---

How the status of the Rollback segment can be viewed ?

1 Answers  

---

What is mean by dbms?

0 Answers  

---

What are ACID properties?

11 Answers   Amazon, Cap Gemini,

---

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

0 Answers   IBM,

---

What do you mean by fill factor concept with respect to indexes?

0 Answers  

---

What is procedure in dbms?

0 Answers  

---

What are the main features of a database?

0 Answers  

---

What are the 4 main objects of a database?

0 Answers  

---