Answer Posted / ela tiku

select max(sal) from emp

<<<assuming emp is the table name and sal is the column
name>>>

What is control file used for?

590

---

What are the attributes of the cursor?

541

---

How can you use check constraints for self referential integrity?

511

---

What are the restrictions in a oracle read only transaction?

554

---

What is the difference between I and G in Oracle?

590

---

---

What is a user account in oracle?

610

---

What is oracle data type?

544

---

Differentiate between function and procedure in oracle.

548

---

How to write a query with a left outer join in oracle?

593

---

How to login to the server without an instance?

610

---

What is sharded cluster?

510

---

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

591

---

What is rich query?

532

---

What is a synonym? What are its various types?

613

---

What is redo log?

615

---