Answer Posted / punit chauhan

select * from emp_record e1 where (3-1) = (select count ( distinct (e2.salary)) from emp_record e2 where e2.salary > e1.salary

How do I know if oracle client is installed on windows?

488

---

What is set verify off in oracle?

566

---

How to create additional tablespaces for an new database?

561

---

How to create an initialization parameter file?

535

---

How to run create database statement again?

613

---

---

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

542

---

What is a Garbage Collection? and what is full recursive Garbage collection?

2384

---

Please explain oracle data types with examples?

578

---

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

1814

---

How to drop an index in oracle?

596

---

What is flashback in Oracle?

575

---

What is the difference between hot backup and cold backup in oracle?

519

---

Explain about your project and its relation to the current job position you are applying to?

534

---

In the oracle version 9.3.0.5.0, what does each number shows?

737

---

Explain the use of tables option in exp command.

585

---