Microsoft 98-364 - Database Fundamentals Exam
Page: 3 / 47
Total 235 questions
Question #11 (Topic: Single Topic)
Which keyword can be used in a create table statement?
A. ORDER BY
B. DISTINCT
C. GROUP BY
D. UNIQUE
Answer: D
Question #12 (Topic: Single Topic)
You need to store product quantities, and you want to minimize the amount of storage space that is used. Which data type should you use?
A. INTEGER
B. DOUBLE
C. COUNT
D. FLOAT
Answer: A
Question #13 (Topic: Single Topic)
Which statement will result in the creation of an index?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
Question #14 (Topic: Single Topic)
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?
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 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
Answer: B
Question #15 (Topic: Single Topic)
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?
Which data type should you use?
A. VARCHAR (3, 30)
B. CHAR (3, 30)
C. VARCHAR (30)
D. CHAR (30)
Answer: C
