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. slock
  2. entity integrity
  3. dirstributed request
  4. granularity of locks
  5. DML
  1. a data manipulation language- is used to maintain and query a database
  2. b supports multiple requests at multiple sites, and each request can access data on multiple sites. most complicated
  3. c -so the low level of granularity would be A field (attribute) A row A page A table The whole database.
  4. d -shared and read locks; with a slock in place, other slocks can be put on the same item, but no Xlocks
  5. e ensures that every row has a unique, non-null primary key.

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. -removes privaledges, When a user's privileges are revoked, so are all those privileges which were passed on by this user.
  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. verificationapproach to data analysis is driven by a hypothesis about some relationship in the data

          

  2. grant-defines users privaledges

          

  3. 2 tieris supperior for handling large scale internet and intranet applications

          

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

          

  5. 2nd normal forma 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

          

Create Set