98-364 Database Administration Fundamentals

---

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