NAME: ________________________

Question Types

Start With

Question Limit

of 28 available terms

Advertisement Upgrade to remove ads

5 Written Questions

5 Matching Questions

  1. 1st normal form
  2. grant
  3. data mining
  4. distributed transaction
  5. xlock
  1. a supports multiple data re3quests for data at multiple locations. each request is for data on a single server
  2. b a 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
  3. c -defines users privaledges
  4. d the search for relationships and patterns that exist in large databases but are hidden in the vast amounts of data
  5. e -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

5 Multiple Choice Questions

  1. approach to data analysis is driven by a hypothesis about some relationship in the data
  2. lower data redundancy, centralizes data, increased data accuracy and standardization, more consistent data.
  3. approach to data analysis sifts through the data in search of frequently occurring patterns and trends
  4. maintains the accuracy of the database. its application means that every foreign key in a table has an identical primary key in that soame table or another table
  5. an ______ helps you speed up retrieval. You should ____ a column if you use it frequently and easy access is desired

5 True/False Questions

  1. granularity of locks-WITH GRANT OPTION permits a user to pass privileges to another user


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


  3. 3 tieris good for building departmental applications, such as decision support and groupware, however doesn't scale well


  4. grant option-WITH GRANT OPTION permits a user to pass privileges to another user


  5. DMLdata manipulation language- is used to maintain and query a database


Create Set