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