ExamTopics Logo
Mail Us[email protected]
Menu
 

98-364 Actual Exam Questions

Last updated on Dec. 5, 2024.
Vendor:Microsoft
Exam Code:98-364
Exam Name:Database Fundamentals
Exam Questions:235
97% Passed the exam with this material
 

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 🗳️

file Viewing page 1 out of 47 pages.
Viewing questions 1-5 out of 235 questions
Next Questions
Browse atleast 50% to increase passing rate cup
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.
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago