Materialised view is a snopshot/Copy of data(where data can come out of s

What is a materialised view?

Question Posted / velmurugan uk

Answer Posted / velmurugan uk

Materialised view is a snopshot/Copy of data(where data can
come out of select query) which can be refresed over a
period of time.

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the use of aggregate functions in oracle?

978

How can we find out the duplicate values in an oracle table?

992

Is truncate autocommit in oracle?

1016

What is Virtual Private Database in Oracle?

1014

How can we create the complete backup of data in the oracle.

2088

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1869

Explain a synonym?

969

What is BBED in Oracle?

1086

What are the uses of Database Trigger ?

1620

What are a cluster and non-cluster index?

954

In which language oracle has been developed?

1013

How to add a new column to an existing table in oracle?

1068

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2208

Differentiate between function and procedure in oracle.

1017

Explain the difference between a procedure and a function? What do you understand by those terms?

1017