Answer Posted / shalini

A table is a collection of data in the form of rows and
columns.
Whereas a View is a virtual table in which data comes from
one or more base tables and is stored as a result of a
predefined query for further use.
Uses of Views:
1.used to improve performance as they are the results of
predefined/complex queries which can be used in other
queries.
2.To provide security by granting permissions to certain
group of people only on the views rather than all the
tables database .ie. hiding sensitive data.
3.To hide complexity of data by showing only the relevant
data need to show to a user rather than confusing a uaser
by showing all the information

How to assign a tablespace to a users in oracle?

989

---

What is a data lock in oracle?

1015

---

What is ordinary table in oracle?

1071

---

What is partitioned table in Oracle?

1102

---

Differentiate between post-database commit and post-form commit?

978

---

How to invoke the original export import utilities?

972

---

Name the three major set of files on disk that compose a database in Oracle?

1062

---

How do I spool in oracle?

937

---

Explain what are synonyms used for?

978

---

What are the ways tablespaces can be managed and how do they differ?

2267

---

How to empty your oracle recycle bin?

979

---

How to connect asp pages to oracle servers?

1002

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2257

---

Explain oracle instance.

1101

---

How do I call oracle stored procedures that take no parameters?

1017

---