Answer Posted / parthasarathi

1)tables
2)views
3)sequences
4)synonyms
5)clusters
6)indexes
7)materialized views
8)procedures
9)functions
10)packages
11)triggers

Explain oracle’s system global area (sga).

617

---

What are the different types of failures that occur in Oracle database?

594

---

How can I get column names from a table in oracle?

531

---

What is the disadvantage of User defind function?

1833

---

Explain the difference between replace() and translate() functions in oracle?

571

---

---

What is an Oracle index?

1171

---

What happens if variable names collide with table/column names?

580

---

What are set operators?

644

---

How to invoke the original export import utilities?

503

---

why dont we assign not null constraint as table level constraint.

2250

---

How to rollback the current transaction in oracle?

536

---

Explain the use of online redo log files in oracle.

577

---

How to drop an existing view in oracle?

562

---

Where do we use decode and case statements?

555

---

Please explain drop constraint oracle?

623

---