Answer Posted / ssk

1. DENSE_RANK is an Analytical Function which doesn't leave
gaps between the records. Coming to Rank function it leaves
gaps between the records.

Eg:

(RANK) (DENSE_RANK)

Sno Marks Ranks Sno Marks Ranks
----- ----- ----- ----- ----- -----
1 100 1 1 100 1
2 100 1 2 100 1
3 200 3 3 200 2
4 300 4 4 300 3
5 300 4 5 300 3
6 400 6 6 400 4

2. Substr will displays the text from position to TO position.
Instr returns the position of the character.

Eg: SELECT SUBSTR('ORACLE',2,4) FROM DUAL;
O/P : RAC

SELECT INSTR('ORACLE IS A DATABASE','A',1,2) from dual;
O/P : 11

3. PSEUDO Column : A column which is not an actual column in
the table. Eg : ROWNUM,ROWID,SYSDATE,USER,UID..

What is a trace file and how is it created in oracle?

1002

---

What is the usage of synonyms?

1096

---

 How to use an oracle sequence generator in a mapping?

1035

---

What is save point in oracle database?

1264

---

Give syntax for SQL and ORACLE joins.

1069

---

What is oracle datasource?

945

---

what is the difference between data migration and production migration.

2299

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1962

---

What is meant by an index?

1079

---

What is the difference between a primary key & a unique key?

1059

---

How to check your oracle database 10g xe installation?

956

---

How to create a stored function in oracle?

1063

---

List out the difference between commit, rollback, and savepoint?

1005

---

What is varray?

1073

---

How many categories of data types in oracle?

992

---