98-364 Study Guide - Real Exam Questions

Practice Our 98-364 Study Guide Exam Questions and Pass Your Exam Easily.

98-364 Study Guide

If you are looking for free 98-364 dumps than here we have some 98-364 question answers available.You can prepare from our Microsoft 98-364 exam questions practice test and prepare exam with this

You can prepare from these 98-364 exam questions or get help from 98-364 dumps for better preparation.

98-364 PDF Download:

Question: 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

Answer: C

Question: 2

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.

Answer: C

Question: 3

Which key uniquely identifies a row in a table?
A. foreiqn
B. primary
C. local
D. superkey

Answer: B

Question: 4
At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you
create a table named Customer and import data into the table. At 5:00 P.M. (1700 hours), your server
fails. You run a script to apply only the 3:00 P.M. backup to your database. What is the result of the script?
A. The Customer table no longer exists.
B. The Customer table is unaffected.
C. The Customer table exists but has no data.
D. The script fails.

Answer: A

Question: 5

In which situation do you need to perform a restore on a database?
A. when data becomes corrupted in the database
B. when you need to roll back a transaction
C. when you encounter an error in your application
D. when data needs to be deleted from the database

Answer: A

page 1 from 1