NAME

Question types


Start with


Question limit

of 28 available terms

Advertisement Upgrade to remove ads
Print test

5 Written questions

5 Matching questions

  1. grant option
  2. data mining
  3. OLAP-online analytical processing
  4. management tools
  5. granularity of locks
  1. a - the analysis of business operations with the intentino of making timely and accurate analysis-based decisions
  2. b the search for relationships and patterns that exist in large databases but are hidden in the vast amounts of data
  3. c -WITH GRANT OPTION permits a user to pass privileges to another user
  4. d -so the low level of granularity would be A field (attribute) A row A page A table The whole database.
  5. e Extraction: Pulling data from existing systems.
    Transformation: Data must be standardized and follow consistent coding schemes.
    Cleaning: Removing errors, inconsistencies, or redundancies.
    Loading: Copying operational data in the data warehouse (archival, current, or ongoing).
    Scheduling: Refreshing the warehouse.
    Metadata: Data dictionary containing facts about the data in the warehouse.

5 Multiple choice questions

  1. Data Definition language- used to define a database
  2. -no other transaction can issure either a slock or xlock on that item. before a transaction can write to a database item, it must be granted Xlock on that item
  3. -defines users privaledges
  4. -shared and read locks; with a slock in place, other slocks can be put on the same item, but no Xlocks
  5. the client in the two-tier model of C\S is also called a ____ ____, because most of the processing runs on the client side

5 True/False questions

  1. concurrency controlthe process of managing simultaneous operations on the database without having them interfere with one another

          

  2. 2 tieris supperior for handling large scale internet and intranet applications

          

  3. verificationapproach to data analysis is driven by a hypothesis about some relationship in the data

          

  4. 3rd normal forma table that is in 1NF for which every non-PK column is fully functionally dependent on the PK
    In other words, the 2NF is violated when a non-PK column is a fact about part of the primary key

          

  5. 2nd normal forma table that is in 1NF for which every non-PK column is fully functionally dependent on the PK
    In other words, the 2NF is violated when a non-PK column is a fact about part of the primary key

          

Create Set