Answer Posted / selvaraj anna university coe

In ORACLE 10g,

SELECT * FROM employee x WHERE 3 = (SELECT COUNT(DISTINCT
salary)
FROM employee y WHERE x.salary <= y.salary);

What is an oracle cursor variable?

603

---

what is a Nested Loop join?

1560

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

3816

---

What are the different types of database objects?

516

---

How to lock and unlock a user account in oracle?

606

---

---

What is transaction control statement and how many types of transaction control statement in Oracle?

558

---

Explain user account with reference to oracle.

524

---

Difference between open_form and call_form in oracle.

668

---

What are temporal data types in oracle?

587

---

What language does oracle use?

587

---

What is PL/SQL ?

1103

---

How translate command is different from replace?

542

---

What is redo log?

616

---

What are the differences between date and timestamp in oracle?

547

---

What is the difference between alert log file and tarce file ?

1627

---