Answer Posted / ananth

this is for 2nd highest sal in sql server database

select * from emp where sal=(select max(sal) from emp where
sal<(select max(sal) from emp))

How many types of synonyms in Oracle?

585

---

What is an oracle transaction?

573

---

How many types of tables are there in oracle?

572

---

Explain do view contain data?

574

---

how may join possible between (requisition with purchase order)

1691

---

---

Explain drop constraint oracle?

582

---

How to resolve name conflicts between variables and columns?

559

---

What are the attributes of cursor?

578

---

What is the difference between translate and replace in oracle?

638

---

How can you use check constraints for self referential integrity?

513

---

How to change system global area (sga) in oracle?

560

---

Explain integrity constraint?

636

---

What is using clause and give example?

577

---

What is MTTR advisor in Oracle?

598

---

What is the usage of analyze command in oracle?

602

---