Dear Aspirants,
Welcome to the Professional Knowledge Section in Affairscloud.com. Here we are providing sample questions in DBMS. It will be useful for the IBPS SO IT officer. We have also included some important questions that are repeatedly asked in previous exams.
- ___________ is a centralized repository that stores data from multiple sources and transforms them into a common, multi dimensional model for efficient querying and analysis.
A. Data Selection
B. Data Cleaning
C. Data Integration
D. Data Warehouse
Answer
D. Data Warehouse - Who is known as the father of data warehousing?
A. Grace Hopper
B. Niklaus Wirth
C. James Gosling
D. William H.Imnon
Answer
D. William H.Imnon - __________ is a simple form of Data Warehouse that is focused on single subject.
A. Spread Mart
B. Data Mart
C. Both (A) and (B)
D. None of the Above
Answer
B. Data Mart - Which is/are the basic operation(S) in Online Analytical Processing (OLAP)?
A. Consolidation
B. Drill- down
C. Slicing and Dicing
D. All of the Above
Answer
D. All of the Above - _________ is a class of software programs capable of supporting large number of short online transactions?
A. OLAP
B. OLTP
C. Both (A) and (B)
D. None of the Above
Answer
B. OLTP - Which performs multidimensional analysis of business data and provides the capability for complex calculations, trend analysis and sophisticated data modeling?
A. OLAP
B. OLTP
C. Both (A) and (B)
D. None of the Above
Answer
A. OLAP - Which of the following is the simplest and less technical type of data warehouse?
A. Real Time Data Warehouse
B. Integrated Data Warehouse
C. Offline Data Warehouse
D. Offline operational Data Warehouse
Answer
D. Offline operational Data Warehouse - Which of the following Data Warehouse is updated from data in the operational systems on a regular basis?
A. Real Time Data Warehouse
B. Integrated Data Warehouse
C. Offline Data Warehouse
D. Offline operational Data Warehouse
Answer
C. Offline Data Warehouse - __________ is a data warehouse that can assemble data from different areas of business.
A. Real Time Data Warehouse
B. Integrated Data Warehouse
C. Offline Data Warehouse
D. Offline operational Data Warehouse
Answer
B. Integrated Data Warehouse - _________is updated for every transaction performed on the source data.
A. Real Time Data Warehouse
B. Integrated Data Warehouse
C. Offline Data Warehouse
D. Offline operational Data Warehouse
Answer
A. Real Time Data Warehouse
AffairsCloud Recommends Oliveboard Mock Test
AffairsCloud Ebook - Support Us to Grow
Govt Jobs by Category
Bank Jobs Notification
