Class XII Informatics Practices Paper (Chapter Wise With Answer)

ADVANCED DATABASE TECHNOLOGIES

Q.1 What is data warehouse?
Ans. Data warehouse is an RDBMS that store and provides already transformed and summarized data. It integrates data throughput of an enterprise.

Q.2 What is data warehousing?
Ans. The process of developing and maintaining data warehouse is called data warehousing.

Q.3 What is Metadata?
Ans. The information that describes the model and definition of the sources data elements is called Metadata.

Q.4 What is data dictionary?
Ans. The Data Dictionary is a Database about data and database structures i.e. the metadata. The data dictionary is maintained as it is very useful in retrieval and transformation of data, when required.