Answer Posted / m.raghu

answer for 101th record

select * from emp where empno in( select decode
(rownum,&n,empno) from emp);

for 4th highest sal

select distinct sal from(select empno,dense_rank() over
(order by sal desc) rnk from emp) where rnk=&n;

for 5th highest sal give n value=5
for 1-10

select distinct sal from(select empno,dense_rank() over
(order by sal desc) rnk from emp) where rnk<=&n;

What are the properties of a transaction?

1117

---

What is pivot query?

1056

---

what is sp_pkeys? : Transact sql

1139

---

What is t sql used for?

1005

---

what is oltp (online transaction processing)? : Sql dba

1066

---

Why self join is used in sql?

963

---

Is it possible for a table to have more than one foreign key?

1017

---

What is sqlcommand?

1009

---

How do I create an index in word?

1010

---

What is snowflake sql?

1051

---

What is sql not null constraint?

1010

---

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1572

---

What is a parameter query?

1059

---

What does select top 1 do in sql?

1077

---

What is row_number () in sql?

964

---