ExamDumpster

98-364

Database Fundamentals practice test

95 Microsoft 98-364 practice questions with explanations, in study, timed and flashcard modes. 12 sample questions are free.

Full access

$99

  • All 95 questions, with explanations
  • Study, timed and flashcard modes
  • Progress saved, resume any time
Try the free samples first
Microsoft logo
Questions
95
Free samples
12
Versions
1
Updated
Jan 2026

Exam simulator

Practice 98-364 in the simulator.

Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.

At a glance

98-364, by the numbers.

Official specifications published by Microsoft.

Open the full exam guide

Exam guide

Everything about 98-364.

98-364 ยท Microsoft

What is 98-364?

Students took 98-364 to show they understood how relational databases store and query data. It was part of the Microsoft Technology Associate (MTA) program until that program was retired in June 2022. The ideas it tested still apply to SQL Server and other relational databases. Normalization means splitting data into related tables so each fact is stored only once. For example, you may write a SELECT query that joins two tables on a shared key. This practice test covers core concepts, tables and views, changing data, keys and indexes, and backups.

What you'll practise

  • Explain how relational databases store data in tables, and the difference between DML and DDL.
  • Create tables, views, stored procedures and functions with the right data types.
  • Select, insert, update and delete data with SQL.
  • Normalize tables and use primary, foreign and composite keys and indexes.
  • Describe database security, backups and restores.

Requirements

  • Recommended: some hands-on practice with a relational database such as SQL Server.

Who it's for

  • Students learning how databases work.
  • New developers, analysts and support staff who need basic SQL.

Three ways to practise

Study mode

Work through the bank at your own pace with the answer and explanation one tap away. Flag questions, add notes, bookmark the hard ones.

Open in the simulator

Timed mode

A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.

Open in the simulator

Flashcards

Question on the front, answer on the back. Good for the last week before the exam.

Open in the simulator

98-364 questions, answered