IndiaBIX
IndiaBIX
Start typing & press "Enter" or "ESC" to close
  • Home
  • Jobs
  • Results
  • Current Affairs
  • GK
  • Online Test
  • HR Interview
  • BLOG

Database Processing for BIS - General Questions (2)

  • Home
  • Computer Science & Engineering
  • Database Questions and Answers
  • Database Processing for BIS - General Questions
9. 

We have been given access to the company's operational data, and have been asked to produce a report. We discover that some of the data we need are in an SQL server database while other needed data are in a separate Oracle database. This is an example of ________ .

A. dirty data
B. inconsistent data
C. non-integrated data
D. a "wrong format" problem

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

View Answer Discuss Workspace Report

10. 

Business Intelligence (BI) reporting analyses can be performed using ________ .

A. standard SQL only
B. extensions to SQL only
C. OLAP only
D. both standard SQL and extensions to SQL

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

View Answer Discuss Workspace Report

11. 

Which of the following is not a component of a data warehouse?

A. Data extraction/cleaning/preparation programs
B. Data warehouse data
C. Data metadata
D. None of the above are data warehouse components.

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

View Answer Discuss Workspace Report

12. 

Business Intelligence (BI) reporting systems cannot do which of the following operations?

A. Filter data
B. Group data
C. Modify data
D. Both filter and group data

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

View Answer Discuss Workspace Report

13. 

We have Market Basket data for 1,000 rental transactions at a Video Store. There are for videos for rent -- Video A, Video B, Video C and Video D. The probability that both Video C and Video D are rented at the same time is known as ________ .

A. the basic probability
B. support
C. lift
D. confidence

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

View Answer Discuss Workspace Report

14. 

The "F" in RFM analysis stands for ________ .

A. frequently
B. freshness
C. fast food
D. fantasy

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

View Answer Discuss Workspace Report

15. 

RFM analysis uses customers' purchasing patterns to ________ .

A. record transactions
B. analyze and rank customers
C. predict future sales using regression techniques
D. perform OLAP

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.
View Answer Discuss Workspace Report

16. 

A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?

A. Push
B. Pull
C. RFM
D. OLAP

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.
View Answer Discuss Workspace Report

  • 1
  • 2
  • 3

Questions & Answers

Aptitude Chemical Engineering Civil Engineering Computer Science & Engineering Current Affairs Data Interpretation Electrical & Electronics Engineering Electronics & Communication Engineering General Knowledge Logical Reasoning Mechanical Engineering Non Verbal Reasoning Verbal Ability Verbal Reasoning

Interviews

HR Interview

Jobs

Sarkari Jobs

Results

Rojgar ResultSarkari Result

Admission

Admission 2023

Admit Card

Admit Card 2023

Answer Key

Answer Key 2023
copyright
Privacy Policy
© 2026 IndiaBIX. All Rights Reserved.

Report