Answer Posted / sandesha

Schema is a collection of database objects. A schema is
owned by a database user and has the same name as that
user. Schema objects are logical structures created by
users to contain, or reference, their data. Schema objects
include structures like tables, views, and indexes.
=============================
2nd:schema is collection of objects
(table,view,procedure,function.....)

Explain an index?

1088

---

Give the different types of rollback segments.

977

---

Explain the difference between sap and oracle?

971

---

What is a private synonym?

1524

---

What is PL/SQL ?

1896

---

What is a dynamic performance view in oracle?

948

---

What is the use of oracle?

980

---

How to use "while" statements in oracle?

1227

---

How to write date and time literals in oracle?

944

---

How to sort output in descending order in oracle?

983

---

How do I find the database name in oracle?

977

---

What is set verify off in oracle?

1027

---

What is the database name in oracle?

967

---

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

997

---

Please explain oracle left join with an example?

955

---