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.....)

How many data types are supported?

1136

---

What is the difference between PFILE and SPFILE in Oracle?

1108

---

How to convert characters to dates in oracle?

1149

---

How to use "in" parameter properly?

1118

---

List out the types of joins.

1237

---

What is a table index in oracle?

1185

---

What is integrity and what is constraint??Explain with example

2338

---

How to revoke create session privilege from a user in oracle?

1068

---

How to create a table interactively?

1164

---

how can we store any pdf file in oracle

2218

---

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2194

---

How to create a server parameter file?

1187

---

What is oracle host variable?

1130

---

What is a snapshot in oracle database?

1071

---

Explain the use of log option in exp command.

1183

---