Online Access Free 98-364 Exam Questions

HOTSPOT
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

Correct Answer:

HOTSPOT
You have two database tables as defined below. The StateID column is unique in the State table. The AddressID column is unique in the Address table. The two tables are related by the StateID column.

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

Correct Answer:

You have the following table definition:
CREATE TABLE Road (RoadID INTEGER NOT NULL, Distance INTEGER NOT NULL)
The Road table contains the following data: You execute the following statement:

INSERT INTO Road VALUES (1234, 36)
What is the result?

• A.an error stating that duplicate IDs are not allowed
• B.a new row in the table
• C.an error stating that NULL values are not allowed
• D.a syntax error

Which two keys establish a relationship between two tables? (Choose two.)

• A.candidate
• B.local
• C.superkey
• D.primary
• E.foreign

You work at a coffee shop. They ask you to set up a website that stores charges on purchases.
You need to recommend a data type in a database table to run financial functions against the charged amounts.
Which data type should you recommend?

• A.Varchar
• B.Bit
• C.Binary
• D.Money