Answer Posted / sandeep

select max(sal) from emp where sal<(select max(sal) from emp);

What do you know about normalization? Explain in detail?

499

---

How to create additional tablespaces for an new database?

570

---

What is the difference between translate and replace in oracle?

648

---

How to start your 10g xe server?

594

---

Use of an integrity constraint is better to validate data. Explain

543

---

---

What is oracle thin client?

533

---

State any two functions of oracle?

632

---

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1875

---

candidate key is subset of super key but not vice-verse explain

1577

---

What is dual table oracle?

527

---

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

1825

---

How to use an explicit cursor without open statements?

614

---

How to execute the package in oracle?

570

---

How to use subqueries with the exists operator in oracle?

606

---

What do you understand by a database object?

584

---