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. data mining
  3. granularity of locks
  4. concurrency control
  5. 2 tier
  1. a -so the low level of granularity would be A field (attribute) A row A page A table The whole database.
  2. b is good for building departmental applications, such as decision support and groupware, however doesn't scale well
  3. c approach to data analysis is driven by a hypothesis about some relationship in the data
  4. d the search for relationships and patterns that exist in large databases but are hidden in the vast amounts of data
  5. e the process of managing simultaneous operations on the database without having them interfere with one another

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. an ______ helps you speed up retrieval. You should ____ a column if you use it frequently and easy access is desired
  3. -shared and read locks; with a slock in place, other slocks can be put on the same item, but no Xlocks
  4. ensures that every row has a unique, non-null primary key.
  5. approach to data analysis sifts through the data in search of frequently occurring patterns and trends

5 True/False questions

  1. grant option-defines users privaledges


  2. DMLData Definition language- used to define a database


  3. fat "thick" client3-tier moves the application logic to the server, known as a ___-___ or thick-server architecture


  4. Referential Integrityensures that every row has a unique, non-null primary key.


  5. DDLdata manipulation language- is used to maintain and query a database