Database MCQ - English
- Introduction to Database
- The Relational Model and Normalization
- Data Modeling with ER Model
- SQL for Database Construction
- Managing Multiuser Databases
- SQL Server 2000
- XML and ADO.NET
- Database Processing for BIS
- The Database Development Process
- ER Model and Business Rules
- Physical Database Design
- The Client Server Database
- Data Warehousing
- Distributed Databases
- Object Oriented Database
- Introduction to SQL
- Database Design Using Normalization
- Data Models into Database Designs
- Database Redesign
- Managing Databases with Oracle
- ODBC, OLE DB, ADO, and ASP
- JDBC, Java Server Pages, and MySQL
- The Database Environment
- Modeling Data in the Organization
- Logical Database Design
- Advanced SQL
- The Internet Database Environment
- Data and Database Administration
- Object Oriented Data Modeling
Data Warehousing MCQ Questions and Answers
Home | Database | Data WarehousingIn this section we provide lots of objective question of Data Warehousing in Database Management System.
1) Data scrubbing is which of the following?
A process to reject data from the data warehouse and to create the necessary indexes![]()
A process to load the data in the data warehouse and to create the necessary indexes![]()
A process to upgrade the quality of data after it is moved into a data warehouse![]()
A process to upgrade the quality of data before it is moved into a data warehouse![]()
Answer : D Discuss
2) The @active data warehouse architecture includes which of the following?
At least one data mart![]()
Data that can extracted from numerous internal and external sources![]()
Near real-time updates![]()
All of the above.![]()
Answer : D Discuss
3) A goal of data mining includes which of the following?
To explain some observed event or condition![]()
To confirm that data exists![]()
To analyze data for expected relationships![]()
To create a new data warehouse![]()
Answer : A Discuss
4) An operational system is which of the following?
A system that is used to run the business in real time and is based on historical data.![]()
A system that is used to run the business in real time and is based on current data.![]()
A system that is used to support decision making and is based on current data.![]()
A system that is used to support decision making and is based on historical data.![]()
Answer : B Discuss
5) A data warehouse is which of the following?
Can be updated by end users.![]()
Contains numerous naming conventions and formats.![]()
Organized around important subject areas.![]()
Contains only current data.![]()
Answer : C Discuss
6) A snowflake schema is which of the following types of tables?
7) The generic two-level data warehouse architecture includes which of the following?
At least one data mart![]()
Data that can extracted from numerous internal and external sources![]()
Near real-time updates![]()
All of the above.![]()
Answer : B Discuss
8) Fact tables are which of the following?
Completely denoralized![]()
Partially denoralized![]()
Completely normalized![]()
Partially normalized![]()
Answer : C Discuss
9) Data transformation includes which of the following?
A process to change data from a detailed level to a summary level![]()
A process to change data from a summary level to a detailed level![]()
Joining data from one source into various sources of data![]()
Separating data from one source into various sources of data![]()
Answer : A Discuss
10) Reconciled data is which of the following?
Data stored in the various operational systems throughout the organization.![]()
Current data intended to be the single source for all decision support systems.![]()
Data stored in one operational system in the organization.![]()
Data that has been selected and formatted for end-user support applications.![]()
Answer : B Discuss