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);

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5680

---

How do I uninstall oracle client from windows?

1057

---

How to display employee records who gets more salary than the average salary in the department?

1126

---

How to drop a stored function?

1182

---

What is a snapshot in oracle database?

1072

---

Point out the difference between user tables and data dictionary?

1036

---

Explain the use of Merge statement in oracle 11g

1076

---

Explain how you would restore a database using RMAN to Point in Time?

2186

---

What are the various types of snapshots ?

1082

---

what are the advantages of running a database in archive log mode?

2254

---

What is flashback in Oracle?

1063

---

Write a syntax for update query in oracle?

1073

---

Why should I use oracle database?

1045

---

What operating systems are supported by oracle database 10g xe?

1085

---

How to call a stored function in oracle?

1064

---