QUESTION 1
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
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
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
QUESTION 4
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
QUESTION 5
Which key uniquely identifies a row in a table?
A. foreiqn
B. primary
C. local
D. superkey
Answer: B
Click here to view complete Q&A of 98-364 exam
Best Microsoft MCTS Certification, Microsoft 98-364 Training at certkingdom.com