Online Access Free 98-364 Practice Test

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.CustomerID 209 is deleted from the Customer 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.The first order for CustomerID 209 is deleted from the Order table.

First normal form requires that a database excludes:

• A.Repeating groups
• B.Foreign keys
• C.Duplicate rows
• D.Composite keys

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.CHAR (3, 30)
• B.VARCHAR (3, 30)
• C.VARCHAR (30)
• D.CHAR (30)

You need to combine the results of two queries into a single result that contains all of the rows from both queries.
Which Structured Query Language (SQL) statement should you use?

• A.UNION
• B.TRUNCATE
• C.EXCEPT
• D.JOIN

HOTSPOT
You have the following table:

Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.

Correct Answer: