#deta warehouse quiz/ #ware test/ #deta warehouse quiz/#deta warehosing test/# dbms detawarehouse-quiz // sanjay sir /

 हम सभी लोग  जानते हैं कि इस टाइम पर ऑनलाइन परीक्षा बहुत कठिन परीक्षाओं में से एक है| इसलिए हम आप लोगो के लिये DBMS की बेहतर क्विज लेकर  आये है , जो कि बहुत ही अनुभवी अध्यापकों की दिशा निर्देश इस क्विज को बनाया गया है ।  यदि आप उस समय अधिक स्कोर प्राप्त करना चाहते हैं तो आपको D.B.M.S.  क्विज का डेली   प्रयास करना होता है | 

|  आप जो चाहतें वो पा  सकते  लेकिन उसके लिये संघर्ष करना पङता | | 

उठो जागो और संघर्ष करों तब तक मत रुको जब तक लक्ष्य की प्रप्ति न हो -

                                                                        स्वामी विवेकानन्द जी 

पढ़ाई के साथ में मस्ती भी जरुरी होती है तो इस लिए कुछ ऐसे जोक जो आप के मन को मस्त  कर दे ----

टीचर : भारत से विदेश जाने वाली पहली महिला कौन थी?
चंटू : सीता, श्रीलंका गई थी.
टीचर अभी भी बेहोश है!

टीचर बच्चों से :- कोई ऐसा वाक्य सुनाओ जिसमे
हिंदी, उर्दू, पंजाबी और अंग्रेजी का प्रयोग हो
संजू :- इश्क़ दी गली विच No Entry!
टीचर बेहोश। 

आप हमारे व्हाट्सएप पर जुड़ने के लिए इस लिंक👉https://chat.whatsapp.com/HSSdTk22q3m10GbCzW4ECV

हमारे टेलिग्राम पर जाने के लिए क्लिक करें👉

joinhttps://t.me/joinchat/SsML9EY2fVoyODg1

हमारे फेसबुक पर जाने के लिए इस लिंक पर क्लिक करें  

https://www.facebook.com/easystudy.study.5/

1. Which of the following features usually applies to data in a data warehouse?

A) Data are often deleted
B)Most applications consist of transactions
C) Data are rarely deleted
D)Relatively few records are processed by applications

ANSWER= (C)Data are rarely deleted

 

2. Which of the following statement is true?

A) The data warehouse consists of data marts and operational data
B)The data warehouse is used as a source for the operational data
C) The operational data are used as a source for the data warehouse
D)All of the above

ANSWER= (C)The operational data are used as a source for the data warehouse

 

3. The following is true of three-tier data warehouses:

A)Once created, the data marts will keep on being updated from the data warehouse at periodic times
B)Once created, the data marts will directly receive their new data from the operational databases
C)The data marts are different groups of tables in the data warehouse
D)A data mart becomes a data warehouse when it reaches a critical size

ANSWER= (A) Once created, the data marts will keep on being updated from the data warehouse at periodic times

 

4.The following technology is not well-suited for data mining:

A) Expert system technology
B)Data visualization
C)Technology limited to specific data types such as numeric data types
D)Parallel architecture

ANSWER= (C)Technology limited to specific data types such as numeric data types

 

5.What is true of the multidimensional model?

A) It typically requires less disk storage
B)It typically requires more disk storage
C)Typical business queries requiring aggregate functions take more time
D)Typical business queries requiring aggregate functions take more time

ANSWER= (B)It typically requires more disk storage

 

6.A data warehouse is which of the following?

A)Can be updated by end users
B)Contains numerous naming conventions and formats
C)Organized around important subject areas.
D)Contains only current data.

ANSWER= (C) Organized around important subject areas.

 

7.An operational system is which of the following?

A) A system that is used to run the business in real time and is based on historical data.
B) A system that is used to run the business in real time and is based on current data.
C)A system that is used to support decision making and is based on current data
D)A system that is used to support decision making and is based on historical data.

ANSWER= (B) A system that is used to run the business in real time and is based on current data

 

8.The generic two-level data warehouse architecture includes which of the following?

A) At least one data mart
B) Data that can extracted from numerous internal and external sources.
C) Near real-time updates
D)All of the above.

ANSWER= (B) Data that can extracted from numerous internal and external sources.

 

9.The extract process is which of the following?

A) Capturing all of the data contained in various operational systems
B) Capturing a subset of the data contained in various operational systems.
C) Capturing all of the data contained in various decision support systems
D)Capturing a subset of the data contained in various decision support systems .

ANSWER= (B) Capturing a subset of the data contained in various operational systems

 

10.Data scrubbing is which of the following?

A)A process to reject data from the data warehouse and to create the necessary indexes
B) A process to load the data in the data warehouse and to create the necessary indexes
C) A process to upgrade the quality of data after it is moved into a data warehouse
D)A process to upgrade the quality of data before it is moved into a data warehouse

ANSWER= (D) A process to upgrade the quality of data before it is moved into a data warehouse