Get 98-364 Dumps PDF - 98-364 Exam Dumps Study Material Dumps4download.com

Question NO : 9

You accept an IT internship at a local charity. The charity has two tables in their data model named Chapter and Language, as defined below:

You create a third table named ChapterLanguage to relate the Chapter table and the Language table.
You need to select columns from the Chapter and Language tables to create a composite primary key for the ChapterLanguage table. Which two columns should you select? (Choose two.)

A. ChapterId
B. LanguageId
C. Country
D. Region
E. City
F. LanguageName

Answer: A,E

Microsoft 98-364 Exam Update Demo - Dumps Dumps4download.com

Question NO : 8

A database contains two tables named Customer and Order.You execute the following statement:
DELETE FROM Order WHERE CustomerID = 209 What is the result?

A. The first order for CustomerID 209 is deleted from the Order table.
B. All orders for CustomerID 209 are deleted from the Order table, and CustomerID 209 is deleted from the Customer table.
C. All orders for CustomerID 209 are deleted from the Order table.
D. CustomerID 209 is deleted from the Customer table.

Answer: C

Download Free Microsoft 98-364 Test Questions And Answers PDF

Question No : 7

You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used. Which data type should you use?

A. VARCHAR (3, 30)
B. CHAR (3, 30)
C. VARCHAR (30)
D. CHAR (30)

Answer: C

Download Latest Free 98-364 Exam Dumps | Dumsp4Download

Question : 6

A database contains two tables named Customer and Order.You execute the following statement:
DELETE FROM Order WHERE CustomerID = 209 What is the result?

A. The first order for CustomerID 209 is deleted from the Order table.
B. All orders for CustomerID 209 are deleted from the Order table, and CustomerID 209 is
deleted from the Customer table.
C. All orders for CustomerID 209 are deleted from the Order table.
D. CustomerID 209 is deleted from the Customer table.

Answer: C

Free Microsoft Exam 98-364 Question

98-364 Dumps With Real Exam Question - Free 98-364 Study Material

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

98-364 Practice Test Exam

Latest 98-364 Exam Questions - Free 98-364 Full Training

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

Free 98-364 Actual Exam Dumps - 98-364 Practice Questions

Question No 3

Which key uniquely identifies a row in a table?

A. foreiqn
B. primary
C. local
D. superkey

Answer: B

Free Microsoft 98-364 Braindumps - Pass 98-364 Exam - Dumps4download

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

Free 98-364 Real Exam Questions - Free 98-364 Dumps PDF

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

98-364 Practice Test