Q1

Document Sample
Q1 Powered By Docstoc
					                                               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?
     A.   To make it harder to answer business questions
          asked by managers
     B.   To make it easier to answer business questions
          asked by managers
     C.   To be able to look at the micro-level transactions
          that drive a business process
     D.   To be able to normalize our database
     E.   To ensure transaction consistency
                                                               11
              Pop Quiz #3

2.    How are Process Metrics related to
      Business Processes?
     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
     E.   E-business Technical Standard




                                                  16
               Pop Quiz #4

2.    What is Metadata?
     A.   Data about data
     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
  C.   Market Basket 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
     money already spent
  B. Are not considered by managers to be
     money already spent
  C. Are considered by accountants to be money
     already spent
  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
          additive


                                                          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