Week 12/13

Question 1

Can packages be invoked, parameterized, or nested?

Answer 1

No

Question 2

Depending on the DB is used, they can be classified as ____ or ____

Answer 2

OLTP or OLAP

Question 3

What is a data warehouse?

Answer 3

A large storage of data gathered from a wide range of sources withina company, used to guide management decisions

Question 4

A large storage of data gathered from a wide range of sources within a company, used to guide management decisions

Answer 4

Data warehouse

Question 5

o Summarizes or highly focuses on a portion of firm’s data for specific use. Typically focuses on single subject or line of business

Answer 5

Data mart (subset of a Data warehouse)

Question 6

This is used to discover hidden patterns and relationships in large databases and establish rules to predict future behavior

Answer 6

Data Mining