NAME

Question Types


Start With


Question Limit

of 28 available terms

Advertisement Upgrade to remove ads

5 Written Questions

5 Matching Questions

  1. OLAP-online analytical processing
  2. data mining
  3. dirstributed request
  4. entities
  5. grant
  1. a supports multiple requests at multiple sites, and each request can access data on multiple sites. most complicated
  2. b -defines users privaledges
  3. c these are the basic building blocks of a data model. they are the things about which data should be stored, something we need to describe. its the same as a table
  4. d the search for relationships and patterns that exist in large databases but are hidden in the vast amounts of data
  5. e - the analysis of business operations with the intentino of making timely and accurate analysis-based decisions

5 Multiple Choice Questions

  1. a table that is in 2NF for which no non-PK column is transitively dependent on the PK
    In other words, the 3NF is violated when a non-PK column is a fact about another non-PK column
  2. is supperior for handling large scale internet and intranet applications
  3. is good for building departmental applications, such as decision support and groupware, however doesn't scale well
  4. -removes privaledges, When a user's privileges are revoked, so are all those privileges which were passed on by this user.
  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 control-WITH GRANT OPTION permits a user to pass privileges to another user

          

  2. slock-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. thin-clientapproach to data analysis sifts through the data in search of frequently occurring patterns and trends

          

  4. 1st normal forma table in which the intersection of each row and column contains one and only one value
    In other words, there should be no « multi-valued » attributes in a table

          

  5. xlock-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

          

Create Set