Answer / mkumar.it

Snapshots and Materialized view are used interchangibly as
both are almost same. However, materialized view is having
additional feature of query rewrite which is not in snapsot.

In this feature, suppose you made any materialized view
using some aggrigate function and you query base table from
sql using same aggrigate funtion, the query will execute on
the materialized view instead of querying base table
provided you have query rewrite priviledge.

Answer / its me...

A materialized view is a database object that contains the
results of a query. The FROM clause of the query can name
tables, views, and other materialized views. Collectively
these objects are called master tables .
materialized views allow you to maintain copies of remote
data on your local node.
You can select data from a materialized view as you would
from a table or view.

How are the index updates?

1 Answers  

---

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

0 Answers   iFlex,

---

interview questions with answer for cts

0 Answers   Cognizant,

---

What are the types of trigger in oracle?

0 Answers  

---

How to resolve the ORA-39133 error in Oracle?

0 Answers  

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

---

What is E-R diagram ?

2 Answers   CGI, Keane India Ltd,

---

Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL

1 Answers  

---

how to retrieve daily sal from emp table in oracle 10g

2 Answers   Infosys,

---

Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?

2 Answers  

---

How to shutdown your 10g xe server from command line?

0 Answers  

---

what's query optimization and without use of IN AND Exist can we get another way data from query

0 Answers  

---