Database Fundamentals Exam 98-364 Practice Questions (solved)

1
98-364
Database Fundamentals Exam 98-364 Demo Edition
2015 - 2016 Troy Tec, LTD All Rights Reserved
http//www.troytec.com
2
98-364

• QUESTION 1
• The terms "bitmap," "b-tree," and "hash" refer to
  which type of database structure?
• View
• Function
• Index
• Stored procedure
• Trigger
• Answer C
• QUESTION 2
• One reason to add an index is to
• Decrease storage space.

You break the table into the following two tables.
http//www.troytec.com
3
98-364

• This process is referred to as
• defragmentation
• normalization
• fragmentation
• 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 Product
  Category?
• Cohort
• Relationally dependent
• Deterministic
• Functionally dependent
• Compositional
• Answer D
• QUESTION 5
• Which key uniquely identifies a row in a table?
• foreiqn
• primary
• local

http//www.troytec.com
4
98-364
Answer B
http//www.troytec.com