Answer Posted / kiran

select max(empsal) from emp where rownum<=2

Differentiate between translate and replace?

625

---

What is the simplest tool to run commands on oracle servers?

511

---

What is index-organized table in Oracle?

570

---

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.

4257

---

What do you know about normalization? Explain in detail?

497

---

---

What is oracle server autotrace in oracle?

613

---

Can select statements be used on views in oracle?

590

---

What are the roles of dba?

611

---

What are the advantages of oracle 12c?

553

---

types of indexes and the rationale behind choosing a particular index for a situation.

1981

---

How to create a table index in oracle?

657

---

What is execute immediate in oracle?

546

---

Give the different types of rollback segments.

578

---

How many anonymous blocks can be defined?

584

---

What is clustered table in Oracle?

641

---