# Q1

Document Sample

```					                                               4
POP QUIZ #1

1.    Which function should be used to
calculate the total of all values in a
column?
A.   Count
√    B.   Sum
C.   Max
D.   Min
E.   Total

1
4
POP QUIZ #1
2.   Based on the following table description, use
SQL to list the complete STUDENT table.
STUDENT[StudentID, FirstName, LastName, Street,
City, State, Zip]
A. SELECT all from Student;
B. LIST all STUDENT;

√ C. SELECT * FROM STUDENT;
D. SELECT LastName, FirstName, Street, City, State,
Zip From Student;
E. PRINT STUDENT table;

2
4
POP QUIZ #1
3.    Based on the following table description, use
SQL to show how many parts are in item class
HW.
PART[PartNum, Description, OnHand,
Class, Warehouse, Price]
A.   SELECT SUM(*) FROM PART WHERE Class=„HW‟;
√    B.   SELECT COUNT(*) FROM PART WHERE
Class=„HW‟;
C.   COUNT(PartNum) IN PART;
D.   SELECT Count(*) from Part WHERE Class=„HW‟
GROUP BY PartNum;
E.   SELECT COUNT(Class) FROM PART Where
Class=“HW”;

3
4
POP QUIZ #1
4.    In SQL you may specify the primary key
by entering a(n) ____ clause in an
ALTER TABLE command.
A.   INDEX KEY
B.   SURROGATE KEY
C.   CANDIDATE KEY
√    D.   PRIMARY KEY
E.   ALTERNATE KEY

4
4
POP QUIZ #1
5.    Which SQL rule would you be violating,
if you tried to delete a sales
representative who currently has
customers on file?
A.   Entity integrity
B.   List integrity
C.   Customer integrity
D.   Table integrity
√    E.   Referential integrity
5
6
Pop Quiz #2

1.      In a 1:1 binary relationship the foreign
key should be placed in ______
A.      Parent entity
B.      Child entity
C.      Both entities
D.      One or the other only
E.      None of the above

Concepts of Database Management, 6th Edition, Pratt & Adamski       6
6
Pop Quiz #2

2.      In a 1:N binary relationship the foreign
key should be placed in ______
A.      Parent entity
B.      Child entity
C.      Both entities
D.      One or the other only
E.      None of the above

Concepts of Database Management, 6th Edition, Pratt & Adamski       7
6
Pop Quiz #2

3.      In a N:M binary relationship the foreign
key should be placed in ______
A.      Parent entity
B.      Child entity
C.      Both entities
D.      One or the other only
E.      None of the above

Concepts of Database Management, 6th Edition, Pratt & Adamski       8
6
Pop Quiz #2
4.    In the diagram, the dashed line with the dot
implies that Employee is the _____
A.    Parent entity
B.    Child entity
C.    Both entities
D.    One or the other only
E.    None of the above

Concepts of Database Management, 6th Edition, Pratt & Adamski       9
6
Pop Quiz #2
a.                                   b.

c.                                   d.
5.      In the diagram above, the “d. arrow” (pointing
at a little circle next to a crowfoot) is pointing
to which type of symbol?
A.      Optional minimum cardinality
B.      Optional maximum cardinality
C.      Required minimum cardinality
D.      Required maximum cardinality
E.      None of the above

Concepts of Database Management, 6th Edition, Pratt & Adamski             10
Pop Quiz #3
1.    In Data Warehouse design, why is it beneficial
to move from the Relational model to the
Dimensional model?
C.   To be able to look at the micro-level transactions
D.   To be able to normalize our database
E.   To ensure transaction consistency
11
Pop Quiz #3

2.    How are Process Metrics related to
A.   Each metric centers around a business
process
B.   Each metric reveals how a process is
quantified
C.   Each metric reveals how a process is
measured
D.   All of the above
E.   None of the above
12
Pop Quiz #3

3.    Dimensions should:
A.   Be DEEP tables
B.   Be WIDE tables
C.   Be Fully normalized
D.   Have many rows

13
Pop Quiz #3

4.    Fact tables should:
A.   Be DEEP tables
B.   Be WIDE tables
C.   Be Fully normalized
D.   Have many attributes

14
Pop Quiz #3
5.    The Grain of a Star Schema refers to
A.   The number of attributes in the Fact Table
B.   The number of rows in the Fact Table
C.   The level of detail recorded in the Fact table
D.   The number of attributes in the Dimension
tables
E.   The number of rows in the Dimension tables

15
Pop Quiz #4

1.    In the DW context, ETS stands for:
A.   Extended Technical Support
B.   Extract, Transform, Store
C.   Electronic Telecommunication Services
D.   E-commerce Technical Standard

16
Pop Quiz #4

B.   High-level data that describe lower-level data
C.   Essential ingredients in the transformation of
raw data into knowledge
D.   The “keys” that allow us to handle the raw
data
E.   All of the above

17
Pop Quiz #4
3.    Does a DW need the meanings of all
reference codes that are used within the
accounting data?
A.   No. Codes in various systems are always
consistent and can be looked up at query time.
B.   No. An accurate history of metadata changes is
not needed in a DW.
C.   No. A common vocabulary must be
established.
D.   Yes. Codes in various systems may differ.
E.   Maybe. It depends on the particular business.
18
Pop Quiz #4

4.    What do Transformation Maps
contain?

A.   Extraction history
B.   Algorithms for summarization
C.   Data ownership
D.   Access patterns
E.   All of the above

19
Pop Quiz #4
5.    According to Denis Kozar, the list of
“seven deadly sins” of data warehouse
implementation includes:
A.   Thinking that “If you build it, they will come”
B.   No documentation of assumptions
C.   Not adopting an architectural framework
D.   Not learning from mistakes
E.   All of the above

20
Pop Quiz #5

1. Data Mining
A.   Is used to find new, hidden, or unexpected
patterns in data
B.   Is also called knowledge data discovery
(KDD)
C.   May include statistical analysis, neural or
fuzzy logic
D.   All of the above
E.   None of the above
21
Pop Quiz #5

2. Some Data Mining techniques include:
A.   Classification
B.   Association
C.   Sequencing
D.   Clustering
E.   All of the above

22
Pop Quiz #5

3. Association Analysis is also known
as:
A.   Affinity Analysis
B.   Classification Analysis
D.   Both (A) and (C)
E.   Both (A) and (B)

23
Pop Quiz #5

4. Web Mining
A.   Can suggest related links or recommend
new products to Web site visitors
B.   Asks visitors to fill out Online Surveys
C.   Encourages Web site visitors to post
messages on bulletin boards
D.   Is the habit of some Web site visitors to click
on various links randomly and continuously

24
Pop Quiz #5

5. An Association Rule example is:
A. IF Income > 60K THEN Reject Application
B. Beer IMPLIES Diapers
C. Income = \$20K + 12*SqFootage
D. IF SqFootage < 1,500 THEN Reject
Application
E. Both (A) and (D)

25
Pop Quiz #6
1. Why are Star Schemas so useful in Financial
Planning and Accounting Information
Systems?
A. Because accounting and financial planning
information systems are not too complex
B. Because Star Schemas can support day-to-day
financial transactions and accounting entries
C. Because business managers want to study
thousands or millions of transactions at a high
degree of summarization
D. Because highly normalized tables ensure data
consistency
E. Because highly normalized tables do not ensure
data consistency
26
Pop Quiz #6

2. Commitments:
A. Are considered by managers to be
B. Are not considered by managers to be
C. Are considered by accountants to be money
D. Require a related pre-existing payment
E. Are also known as disbursements
27
Pop Quiz #6

3. Why can the grain of the Budget Star
not be set at the budget line?
A. One account may draw from more than one
budgets
B. One budget line may draw from more than one
general ledger accounts
C. The budget star should have a higher degree of
summarization
D. It is impossible to relate a budget line to a specific
department
E. Budget facts relate to a specific month but budget
lines relate to an entire year
28
Pop Quiz #6

4. A drill-across report
A. Queries each fact table separately
B. Combines result sets from more than
one fact table
C. Uses two or more queries with identical
WHERE and GROUP BY clauses
D. All of the above
E. None of the above

29
Pop Quiz #6

5. The benefit of a drill-across report is that:
A. It focuses on one star schema only
B. It does not require more than one star
schemas
C. It minimizes response time, even though
it cannot ensure accurate results
D. It ensures accurate results, even though
it makes response time much longer
E. It ensures accurate results and
minimizes response time
30
Pop Quiz #7

1.    What are the guidelines for a Financial
Reporting DW?
A.   Its reports should be as reliable as the existing
financial system
B.   The sources for the Financial DW must be the
approved, audited official systems
C.   All changes and reversals in the financial system
must be reflected in the financial DW
D.   All of the above
E.   None of the above

31
Pop Quiz #7

2.    What happens if the strict guidelines for
Financial Reporting DW are not
observed?
A.   The DW cannot be used for financial or
managerial accounting purposes
B.   The DW can still be used for financial
accounting purposes
C.   The DW can still be used for managerial
accounting purposes
D.   The DW can still be used for financial and
managerial accounting purposes
32
Pop Quiz #7

3.    Which financial reports can be supported
by a financial reporting DW?
A.   Balance Sheets only
B.   Income Statements only
C.   Balance Sheets and Income Statements
only
D.   Cash Flow Statements only
E.   Balance Sheets, Income Statements, and
Cash Flow Statements
33
Pop Quiz #7

4.    What is the benefit of having a Balance
Sheet star schema that records facts at a
detailed general ledger transaction grain?
A.   It allows users to produce official Balance
Sheet statements that can be used in auditing
B.   It allows users to drill across the
dimensions and get detailed data for
internal analysis purposes
C.   It allows users to replace the existing financial
source system and still maintain all the data

34
Pop Quiz #7

5.    How do we produce fully additive
measures for the Income Statement fact
table?
A.   We record IS entries based on a transactional
model that records changes only
B.   We record IS entries by maintaining running
averages
C.   We have to drill across the other dimensions
D.   Income Statement entries are already

35
Pop Quiz #8

1.    The amount of new data generated in
the world in 2007 was approximately
A.   161 Terabytes
B.   185 Exabytes
C.   5 Exabytes
D.   161 Exabytes
E.   281 Exabytes

36
Pop Quiz #8

2.    Some of the alternative storage
techniques for data warehousing
include:
A.   Magnetic disk storage devices
B.   Near-line and secondary storage devices
C.   Tape storage devices
D.   CD ROMs
E.   All of the above

37
Pop Quiz #8

3.    There are some notable pitfalls in the
Data mining area. These include:
A.   Concerns for individual privacy
B.   Problems with data accuracy
C.   Organizations must be agile enough to
respond to data mining discoveries
D.   Data cleansing is very difficult, expensive
and time consuming
E.   All of the above
38
Pop Quiz #8

4.    “Signatures” are used for intrusion
detection by
A.   Searching for deviations from the norm.
B.   Recognizing known patterns
C.   Asking for someone to identify themselves
D.   Handwriting analysis alone
E.   None of the above

39
Pop Quiz #8

5.    Some Data Warehousing trends include:
A.   Increasing costs for data storage
B.   Decreasing computer performance
C.   Need for increasing numbers of highly
skilled analysts each year
D.   Fairly stable volumes of data to analyze
E.   None of the above

40

```
DOCUMENT INFO
Shared By:
Categories:
Stats:
 views: 31 posted: 6/18/2011 language: English pages: 40