98-364 Database Administration Fundamentals

Posted by:admin Posted on:Nov 26,2015

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

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft 98-364 Training at certkingdom.com


admin

No description.Please update your profile.