Explain materialized views and how they are used

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

33. Explain materialized views and how they are used.

Materialized views are objects that are reduced sets of information that have been summarized, grouped, or aggregated from base tables. They are typically used in data warehouse or decision support systems.

(Continued on next question...)

Other Job Interview Questions

• Is it possible to split the print reviewer into more than one region?
• How can a button be used in a report to give a drill down facility?
• If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?
• What are the built-ins that are used for setting the LOV properties at runtime?
• Why is it preferable to create a fewer no. of queries in the data model?
• Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size?
• What cursor type do you use to retrieve multiple recordsets?
• Use the Add_group_row procedure to add a row to a static record group 1. true or false?
• What is a record group?
• What is a DBA?
• More...