Explain materialized views and how they are used.

Answer Posted / shyamal mondal

Materialized view is a database object which contains the result of a query. It is the local copy of data located remotely or are used to create summary table based on aggregation of table's data.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

where the dff data will be stored

1801


what is the link between suppliers and banks in ap module in oracle apps? And also query?

2013


What is auto invoicing? Explain : oracle accounts receivable

612


while creating requisitions i am unable to see the list of organisation can anyone help me out ?

1704


hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

1767






Explain how to close periods in ar. : oracle accounts receivable

705


How would you determine who has added a row to a table?

1792


What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

1592


What is db_recovery_file_dest in oracle? When do you need to set this value?

644


What is the use of lockboxes? : oracle accounts receivable

653


My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

1741


How would you determine what sessions are connected and what resources they are waiting for?

1612


what are the tools used for oracle 10g in real time.

1929


WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2388


Differentiate between transaction type and transaction source? : oracle accounts receivable

677