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. concurrency control
  2. slock
  3. 3 tier
  4. OLAP-online analytical processing
  5. entities
  1. a - the analysis of business operations with the intentino of making timely and accurate analysis-based decisions
  2. b 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
  3. c -shared and read locks; with a slock in place, other slocks can be put on the same item, but no Xlocks
  4. d the process of managing simultaneous operations on the database without having them interfere with one another
  5. e is supperior for handling large scale internet and intranet applications

5 Multiple choice questions

  1. data manipulation language- is used to maintain and query a database
  2. is good for building departmental applications, such as decision support and groupware, however doesn't scale well
  3. the search for relationships and patterns that exist in large databases but are hidden in the vast amounts of data
  4. approach to data analysis sifts through the data in search of frequently occurring patterns and trends
  5. -removes privaledges, When a user's privileges are revoked, so are all those privileges which were passed on by this user.

5 True/False questions

  1. dirstributed requestsupports multiple data re3quests for data at multiple locations. each request is for data on a single server

          

  2. benefits of data warehouseensures that every row has a unique, non-null primary key.

          

  3. grant option-defines users privaledges

          

  4. grantData Definition language- used to define a database

          

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

          

Create Set