NAME

Question types


Start with


Question limit

of 28 available terms

Advertisement
Print test

5 Written questions

5 Matching questions

  1. Referential Integrity
  2. concurrency control
  3. 2 tier
  4. revoke
  5. slock
  1. a -removes privaledges, When a user's privileges are revoked, so are all those privileges which were passed on by this user.
  2. b the process of managing simultaneous operations on the database without having them interfere with one another
  3. c 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
  4. d is good for building departmental applications, such as decision support and groupware, however doesn't scale well
  5. e -shared and read locks; with a slock in place, other slocks can be put on the same item, but no Xlocks

5 Multiple choice questions

  1. 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
  2. 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. data manipulation language- is used to maintain and query a database
  4. -WITH GRANT OPTION permits a user to pass privileges to another user
  5. 3-tier moves the application logic to the server, known as a ___-___ or thick-server architecture

5 True/False questions

  1. OLAP-online analytical processingmaintains 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

          

  2. grant-defines users privaledges

          

  3. DDLData Definition language- used to define a database

          

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

          

  5. distributed transactionsupports multiple requests at multiple sites, and each request can access data on multiple sites. most complicated