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 the difference between a procedure and a function?

1175

---

How to display employee records who gets more salary than the average salary in the department?

1067

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2125

---

Explain the use of Merge statement in oracle 11g

1029

---

Is there a combination of "like" and "in" in sql?

1066

---

How many categories of data types in oracle?

1029

---

ABOUT IDENTITY?

2062

---

what are bitmap indexes? How does they work?

2259

---

What are the differences between primary key and unique key?

1010

---

What is procedure overloading in oracle?

1062

---

What is bind variable in oracle 11g?

1039

---

Explain implicit cursor.

1036

---

What is BBED in Oracle?

1156

---

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2265

---

what is the dual table in oracle?

993

---