Microsoft 98-364 - Database Fundamentals Exam
Page: 1 / 47
Total 235 questions
Question #1 (Topic: Single Topic)
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
Question #2 (Topic: Single Topic)
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
Question #3 (Topic: Single Topic)
You have a table that contains the following data.
You break the table into the following two tables.
This process is referred to as:
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
Question #4 (Topic: Single Topic)
You have a table that contains the following data.
Which database term is used to describe the relationship between ProductID and ProductCategory?
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
Question #5 (Topic: Single Topic)
Which key uniquely identifies a row in a table?
A. foreiqn
B. primary
C. local
D. superkey
Answer: B
