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. data mining
  2. 2 tier
  3. grant option
  4. DDL
  5. OLAP-online analytical processing
  1. a the search for relationships and patterns that exist in large databases but are hidden in the vast amounts of data
  2. b Data Definition language- used to define a database
  3. c is good for building departmental applications, such as decision support and groupware, however doesn't scale well
  4. d -WITH GRANT OPTION permits a user to pass privileges to another user
  5. e - the analysis of business operations with the intentino of making timely and accurate analysis-based decisions

5 Multiple choice questions

  1. ensures that every row has a unique, non-null primary key.
  2. approach to data analysis sifts through the data in search of frequently occurring patterns and trends
  3. -removes privaledges, When a user's privileges are revoked, so are all those privileges which were passed on by this user.
  4. 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
  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. entitiesis supperior for handling large scale internet and intranet applications

          

  2. fat "thick" clientthe client in the two-tier model of C\S is also called a ____ ____, because most of the processing runs on the client side

          

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

          

  4. thin-clientan ______ helps you speed up retrieval. You should ____ a column if you use it frequently and easy access is desired

          

  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