98-364

98-364 practice questions, page 3 of 10, with answer review and explanations.

Question 11

Which keyword can be used in a create table statement?

  1. ORDER BY
  2. DISTINCT
  3. GROUP BY
  4. UNIQUE

Question 12

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?

  1. INTEGER
  2. DOUBLE
  3. COUNT
  4. FLOAT

Question 13

Which statement will result in the creation of an index?

  1. Option A
  2. Option B
  3. Option C
  4. Option D

Question 14

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?

  1. an error stating that NULL values are not allowed
  2. a new row in the table
  3. an error stating that duplicate IDs are not allowed
  4. a syntax error

Question 15

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?

  1. VARCHAR (3, 30)
  2. CHAR (3, 30)
  3. VARCHAR (30)
  4. CHAR (30)