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. index
  3. granularity of locks
  4. concurrency control
  5. 3 tier
  1. a the process of managing simultaneous operations on the database without having them interfere with one another
  2. b -WITH GRANT OPTION permits a user to pass privileges to another user
  3. c is supperior for handling large scale internet and intranet applications
  4. d -so the low level of granularity would be A field (attribute) A row A page A table The whole database.
  5. e an ______ helps you speed up retrieval. You should ____ a column if you use it frequently and easy access is desired

5 Multiple choice questions

  1. 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.
  2. -defines users privaledges
  3. approach to data analysis sifts through the data in search of frequently occurring patterns and trends
  4. 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. the search for relationships and patterns that exist in large databases but are hidden in the vast amounts of data

5 True/False questions

  1. xlock-shared and read locks; with a slock in place, other slocks can be put on the same item, but no Xlocks

          

  2. 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

          

  3. DDLdata manipulation language- is used to maintain and query a database

          

  4. 1st 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. 2 tieris good for building departmental applications, such as decision support and groupware, however doesn't scale well