Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
sale

Want to Unlock All Questions for this Exam?

Full Exam Access, Discussions, No Robots Checks

Microsoft 98-364 Exam Actual Questions

The questions for 98-364 were last updated on March 27, 2024.
  • Viewing page 1 out of 47 pages.
  • Viewing questions 1-5 out of 244 questions

Topic 1 - Single Topic

Question #1 Topic 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
Reveal Solution Hide Solution   Discussion   7

Correct Answer: C 🗳️

Question #2 Topic 1

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.
Reveal Solution Hide Solution   Discussion   3

Correct Answer: C 🗳️

Question #3 Topic 1

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
Reveal Solution Hide Solution   Discussion   2

Correct Answer: B 🗳️

Question #4 Topic 1

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
Reveal Solution Hide Solution   Discussion   2

Correct Answer: D 🗳️

Question #5 Topic 1

Which key uniquely identifies a row in a table?

  • A. foreiqn
  • B. primary
  • C. local
  • D. superkey
Reveal Solution Hide Solution   Discussion   2

Correct Answer: B 🗳️

Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...