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. 2 tier
  2. index
  3. data mining
  4. management tools
  5. DML
  1. a is good for building departmental applications, such as decision support and groupware, however doesn't scale well
  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 manipulation language- is used to maintain and query a database
  4. d an ______ helps you speed up retrieval. You should ____ a column if you use it frequently and easy access is desired
  5. e Extraction: Pulling data from existing systems.
    Transformation: Data must be standardized and follow consistent coding schemes.
    Cleaning: Removing errors, inconsistencies, or redundancies.
    Loading: Copying operational data in the data warehouse (archival, current, or ongoing).
    Scheduling: Refreshing the warehouse.
    Metadata: Data dictionary containing facts about the data in the warehouse.

5 Multiple choice questions

  1. 3-tier moves the application logic to the server, known as a ___-___ or thick-server architecture
  2. -defines users privaledges
  3. ensures that every row has a unique, non-null primary key.
  4. 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
  5. approach to data analysis sifts through the data in search of frequently occurring patterns and trends

5 True/False questions

  1. OLAP-online analytical processingmaintains 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. benefits of data warehouseensures that every row has a unique, non-null primary key.

          

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

          

  4. 1st normal forma 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

          

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

          

Create Set