Download Microsoft.98-364.BrainDumps.2019-03-20.80q.tqb
| Vendor: | Microsoft |
| Exam Code: | 98-364 |
| Exam Name: | Database Fundamentals |
| Date: | Mar 20, 2019 |
| File Size: | 1 MB |
Demo Questions
Question 1
The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
- View
- Function
- Index
- Stored procedure
- Trigger
Correct answer: C
Question 2
One reason to add an index is to:
- Decrease storage space.
- Increase database security.
- Improve performance of select statements.
- Improve performance of insert statements.
Correct 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:
- defragmentation
- normalization
- fragmentation
- denormalization
Correct answer: B
