Question types

Start with

Question limit

of 28 available terms

Advertisement Upgrade to remove ads
Print test

5 Written questions

5 Matching questions

  1. data mining
  2. 2nd normal form
  3. 2 tier
  4. DDL
  5. 3rd normal form
  1. a a table that is in 1NF for which every non-PK column is fully functionally dependent on the PK
    In other words, the 2NF is violated when a non-PK column is a fact about part of the primary key
  2. b the search for relationships and patterns that exist in large databases but are hidden in the vast amounts of data
  3. c Data Definition language- used to define a database
  4. d is good for building departmental applications, such as decision support and groupware, however doesn't scale well
  5. e 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

5 Multiple choice questions

  1. 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
  2. the process of managing simultaneous operations on the database without having them interfere with one another
  3. 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. supports multiple requests at multiple sites, and each request can access data on multiple sites. most complicated
  5. 3-tier moves the application logic to the server, known as a ___-___ or thick-server architecture

5 True/False questions

  1. DMLdata manipulation language- is used to maintain and query a database


  2. xlock-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


  3. benefits of data warehouseensures that every row has a unique, non-null primary key.


  4. grant-defines users privaledges


  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


Create Set