98-364 Microsoft Exam Questions and Free Practice Test

Question 13

On which database structure does an update statement operate?

A. Table

B. User

C. Trigger

D. Role

Correct Answer:A

Question 14

You need to delete a database table.
Which data definition language (DDL) keyword should you use?

A. ALTER

B. DELETE

C. DROP

D. TRUNCATE

Correct Answer:C

Question 15

Denormalization is performed in order to:

A. Reduce redundancy.

B. Eliminate repeating groups.

C. Create smaller tables.

D. Improve query performance.

Correct Answer:D

Question 16

Data in a database is stored in:

A. Tables

B. Queries

C. Data types

D. Stored procedures

Correct Answer:A

Question 17

You have the following table definition:
CREATE TABLE Road (RoadID INTEGER NOT NULL,
Distance INTEGER NOT NULL)
The Road table contains the following data:
98-364 dumps exhibit
You execute the following statement: INSERT INTO Road VALUES (1234, 36)
What is the result?

A. an error stating that NULL values are not allowed

B. a new row in the table

C. an error stating that duplicate IDs are not allowed

D. a syntax error

Correct Answer:B

Question 18

Which keyword must be included in a create view statement?

A. WHERE

B. ORDER BY

C. UPDATE

D. SELECT

Correct Answer:D

START 98-364 EXAM