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

What are the various oracle database objects?

1144

---

What is a dynamic performance view in oracle?

992

---

Is the After report trigger fired if the report execution fails ?

2915

---

State all possible different index configurations a table can possibly have?

1006

---

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1842

---

What is redo log?

1066

---

what happened to the global index when I truncate the data in one of the partition?

2022

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2461

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2144

---

How to login to the server without an instance?

1162

---

What is a static data dictionary in oracle?

1112

---

What do you mean by a tablespace?

1039

---

How to execute a stored procedure in oracle?

1091

---

How to download oracle database 10g xe?

1018

---

Can multiple columns be used in group by in oracle?

988

---