Q. Which type of metadata is held in the catalog of the warehouse database system

View solution

Q. Which metadata consists of information in the enterprise that is not in classical form

View solution

Q. The number of fact table in star schema is

View solution

Q. Which one is not a Knowledge Discovery in Databases (KDD) process

View solution

Q. Total number of stages in KDD is

View solution

Q. In the data warehouse, which data have the greatest level of details stored

View solution

Q. In Transient data, after changes with the the records, the previous version of the records will be

View solution

Q. The process of upgrading the existing quality of data before it is moved into a data warehouse is known as

View solution

Q. Which one is true about a Fact Table

View solution

Q. A decision tree where the target variable takes a continuous value, usually numbers, are called

View solution

Q. Which one is a method of incremental conceptual clustering

View solution

Q. Data warehouse architecture is based on

View solution

Q. In OLAP cubes, data (measures) are categorized by

View solution

Q. Which type of database can be used for optimizing data warehousing and OLAP (online analytical processing)

View solution

Q. ODS stands for

View solution

Q. ________ is a subject-oriented, integrated,time-varying, nonvolatile collection of data in support of management decisions –making process.

View solution

Q. The full form of OLAP is

View solution

Q. What is the full form of OLTP

View solution

Q. The data is stored, retrieved and updated in

View solution

Q. State true or false : "An OLAP system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts."

View solution