Home > Download > SMU - Question Paper
> BCA > BC0058
Data Warehousing And Data Mining
This is the collection of
Sikkim Manipal University (SMU) question and answers for Data Warehousing And Data Mining. It will help
to prepare your examination. All question paper are
classified as per semester, subject code and question type of Part A, Part B and Part C with
multiple
choice options
as same as actual examination. SMU question papers includes
year 2025, 2024, 2023 Sem I, II, III, IV, V, VI examinations
of all subjects.
SMU question test set of old,
last and previous year are updated
regularly and it is absolutely free to use. Question paper includes Visual basic 6, VB.Net, C#, ASP.Net,
Web, Oracle, Database, SQL, Software Engineering, C, C++, OOPS, MBA, MCA, BSC IT I have requested
you kindly send me the question paper of Data Warehousing And Data Mining, SMU - Bachelor of Computer Application.
Course Name
BCA (Bachelor of Computer Application)
Subject Code BC0058 (Data Warehousing And Data Mining)
Get Questions
PART - A
PART - B
PART - C
Subject : Data Warehousing And Data Mining
BC0058 : PART - B
| Q. 1 | Which of the following information must be
present in the metadata of a data warehouse?
1. The structure of the data
2. The algorithm used for summarization
3. The mapping from the operational
environment to the data warehouse |
| | A) | 1 and 2 |
| B) | 1, 2 and 3 | | C) | 2 and 3 | | D) | 1 and 3 | | | | | Q. 2 | Table and index creation are the common
SQL statements used for
i) creating data
ii) extracting data
iii) transforming data
iv) optimizing data |
| | A) | i) and ii) |
| B) | ii) and iii) | | C) | iii) and iv) | | D) | i) and iii) | | | | | Q. 3 | Which of the following statements are true
regarding information data?
1. It is summarized operational data
2. It is frequently updated from the operational
systems
3. It is optimized for business support
application
4. It is |
| | A) | 1, 2 and 4 |
| B) | 1 and 3 | | C) | 2, 3 and 4 | | D) | 1, 2 and 3 | | | | | Q. 4 | Which of the following statement(s) are
true?
i) Bitmaps are inappropriate for heavy OLTP
systems
ii) Updating a bitmapped index involves more
overheads
iii) Bitmaps are appropriate for heavy OLTP
systems
iv) Updating a bit |
| | A) | i) and iv) |
| B) | i) and ii) | | C) | ii) and iii) | | D) | Only i) | | | | | Q. 5 | Identify the correct sequence of steps in the
Sandwich Paradigm
1. Revise the strategies as necessary
2. Build a prototype mini-data warehouse with
most of the features envisaged for the final
product
3. Build the final warehouse < |
| | A) | 2, 4, 3, 1 |
| B) | 1, 2, 3, 4 | | C) | 4, 2, 1, 3 | | D) | 3, 2, 1, 4 | | | |
Click here to get
Data Warehousing And Data Mining (BC0058)
New Question
Home > Download > SMU - Question Paper
> BCA > BC0058