98-364

Review 235 98-364 practice questions with answer explanations and community insights.

Question 1

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

  1. View
  2. Function
  3. Index
  4. Stored procedure
  5. Trigger

Question 2

One reason to add an index is to:

  1. Decrease storage space.
  2. Increase database security.
  3. Improve performance of select statements.
  4. Improve performance of insert statements.

Question 3

You have a table that contains the following data. You break the table into the following two tables. This process is referred to as:

  1. defragmentation
  2. normalization
  3. fragmentation
  4. denormalization

Question 4

You have a table that contains the following data. Which database term is used to describe the relationship between ProductID and ProductCategory?

  1. Cohort
  2. Relationally dependent
  3. Deterministic
  4. Functionally dependent
  5. Compositional

Question 5

Which key uniquely identifies a row in a table?

  1. foreiqn
  2. primary
  3. local
  4. superkey
We are moving to a new platform

CertificationTest is being migrated. Some pages may be slow or briefly unavailable; everything will be back to normal within a few hours. If you run into any issue, email support@certificationtest.net.