SQL -Structured Query Language - SQL Database - Drop Database Quiz

Fact tables are which of the following?

• 1]

  Completely demoralized

• 2]

  Completely normalized

• 3]

  Partially demoralized

• 4]

  Partially normalized

A snowflake schema is which of the following types of tables?

• 1]

  Fact

• 2]

  Dimension

• 3]

  Helper

• 4]

  All of the above

A goal of data mining includes which of the following?

• 1]

  To explain some observed event or condition

• 2]

  To confirm that data exists

• 3]

  To analyze data for expected relationships

• 4]

  To create a new data warehouse

Primitive operations common to all record management systems include

• 1]

  Print

• 2]

  Sort

• 3]

  Look-up

• 4]

  All of the above

Each of the data files has a ______ that describe the way the data is stored in the file

• 1]

  File structure

• 2]

  Records

• 3]

  Database

• 4]

  Fields

After you ______ a record, many data management environments require you to issue a command to save the changes you made

• 1]

  Delete

• 2]

  Update

• 3]

  Sort key

• 4]

  Index

Sort/report generators

• 1]

  are faster than index/report generators

• 2]

  require more disk space than index/report generators

• 3]

  do not need to sort before generating a report

• 4]

  both (a) and (b)

An-owner-member set in the CODASYL specifications may have

• 1]

  only one owner but many owner occurrences

• 2]

  only one member but many member occurrences

• 3]

  more than one member but only one occurrence per member

• 4]

  All of the above

Which of the following hardware components is the most important to the operation of a database management system?

• 1]

  high-resolution video display

• 2]

  printer

• 3]

  high speed, large-capacity disk

• 4]

  plotter