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. verification
  2. DML
  3. index
  4. distributed transaction
  5. Referential Integrity
  1. a data manipulation language- is used to maintain and query a database
  2. b approach to data analysis is driven by a hypothesis about some relationship in the data
  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 supports multiple data re3quests for data at multiple locations. each request is for data on a single server
  5. e an ______ helps you speed up retrieval. You should ____ a column if you use it frequently and easy access is desired

5 Multiple choice questions

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

5 True/False questions

  1. revoke-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

          

  2. granularity of locks-so the low level of granularity would be A field (attribute) A row A page A table The whole database.

          

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

          

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

          

  5. benefits of data warehouselower data redundancy, centralizes data, increased data accuracy and standardization, more consistent data.

          

Create Set