Data Warehouse Testing MCQs
Data Warehousing Testing MCQs : This section focuses on "Testing" of Data Warehousing. These Multiple Choice Questions (mcq) should be practiced to improve the Data Warehousing skills required for various interviews (campus interviews, walk-in interviews, company interviews), placements, entrance exams and other competitive examinations.
1. How many basic levels of testing performed on a data warehouse?
A. 2
B. 3
C. 4
D. 5
View Answer
Ans : B
Explanation: There are three basic levels of testing performed on a data warehouse : Unit testing, Integration testing, System testing
2. ____________ is very important for data warehouse systems to make them work correctly and efficiently.
A. Security
B. Backup
C. Testing
D. Tuning
View Answer
Ans : C
Explanation: Testing is very important for data warehouse systems to make them work correctly and efficiently.
3. Unit test is performed by the ?
A. client
B. developer
C. Both A and B
D. testing team
View Answer
Ans : B
Explanation: This test is performed by the developer
4. In which testing, the whole data warehouse application is tested together?
A. Unit Testing
B. Integration Testing
C. Regression Testing
D. System Testing
View Answer
Ans : D
Explanation: In system testing, the whole data warehouse application is tested together.
5. System testing is performed by the testing team.
A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
View Answer
Ans : A
Explanation: True, System testing is performed by the testing team.
6. Which of scenarios need testing?
A. Media failure
B. Loss or damage of table space or data file
C. Loss or damage of redo log file
D. Instance failure
View Answer
Ans : D
Explanation: Testing the backup recovery strategy is extremely important. For all of the above scenarios testing needed.
7. __________ also needs to be tested to identify I/O bottlenecks.
A. Security
B. Scheduler
C. Disk configuration
D. Management Tools
View Answer
Ans : C
Explanation: Disk configuration also needs to be tested to identify I/O bottlenecks. The test should be performed with multiple times with different settings
8. Which term is used to define testing?
A. Finding broken code
B. A stage of all projects
C. Evaluating deliverable to find errors
D. All of the above
View Answer
Ans : C
Explanation: Evaluating deliverable to find errors is used to define testing.
9. A separate security document is required for security testing.
A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
View Answer
Ans : A
Explanation: True, A separate security document is required for security testing. This document contains a list of disallowed operations and devising tests for each.
10. The purpose of system testing is to check whether the entire system works correctly together or not.
A. Yes
B. No
C. Can be true or false
D. Can not say
View Answer
Ans : A
Explanation: True, The purpose of system testing is to check whether the entire system works correctly together or not.
Discussion