Question types

Start with

Question limit

of 28 available terms

Advertisement Upgrade to remove ads
Print test

5 Written questions

5 Matching questions

  1. discovery
  2. 1st normal form
  3. data mining
  4. index
  5. verification
  1. a approach to data analysis is driven by a hypothesis about some relationship in the data
  2. b 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. c approach to data analysis sifts through the data in search of frequently occurring patterns and trends
  4. d an ______ helps you speed up retrieval. You should ____ a column if you use it frequently and easy access is desired
  5. e the search for relationships and patterns that exist in large databases but are hidden in the vast amounts of data

5 Multiple choice questions

  1. -so the low level of granularity would be A field (attribute) A row A page A table The whole database.
  2. -shared and read locks; with a slock in place, other slocks can be put on the same item, but no Xlocks
  3. ensures that every row has a unique, non-null primary key.
  4. the process of managing simultaneous operations on the database without having them interfere with one another
  5. - the analysis of business operations with the intentino of making timely and accurate analysis-based decisions

5 True/False questions

  1. Referential Integritymaintains 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 option-WITH GRANT OPTION permits a user to pass privileges to another user


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


  4. grantdata manipulation language- is used to maintain and query a database


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