Microsoft 98-364 - Database Fundamentals Exam

Page:    1 / 47   
Total 235 questions

The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?

  • A. View
  • B. Function
  • C. Index
  • D. Stored procedure
  • E. Trigger


Answer : C

One reason to add an index is to:

  • A. Decrease storage space.
  • B. Increase database security.
  • C. Improve performance of select statements.
  • D. Improve performance of insert statements.


Answer : C

You have a table that contains the following data.


You break the table into the following two tables.

This process is referred to as:

  • A. defragmentation
  • B. normalization
  • C. fragmentation
  • D. denormalization


Answer : B

You have a table that contains the following data.


Which database term is used to describe the relationship between ProductID and ProductCategory?

  • A. Cohort
  • B. Relationally dependent
  • C. Deterministic
  • D. Functionally dependent
  • E. Compositional


Answer : D

Which key uniquely identifies a row in a table?

  • A. foreiqn
  • B. primary
  • C. local
  • D. superkey


Answer : B

Page:    1 / 47   
Total 235 questions