98-364

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

Question 21

You are writing an SQL statement to retrieve rows from a table. Which data manipulation language (DML) command should you use?

  1. READ
  2. SELECT
  3. OUTPUT
  4. GET

Question 22

Which constraint ensures a unique value in the ID column for each customer?

  1. DISTINCT
  2. FOREIGN KEY
  3. SEQUENTIAL
  4. PRIMARY KEY

Question 23

The component that holds information for a single entry in a table is called a:

  1. Data type
  2. Row
  3. Column
  4. View

Question 24

You execute the following statement: SELECT EmployeeID, FirstName, DepartmentName FROM Employee, Department - This type of operation is called a/an:

  1. Intersection
  2. Outer join
  3. Equi-join
  4. Cartesian product

Question 25

Which command should you use to add a column to an existing table?

  1. MODIFY
  2. ALTER
  3. UPDATE
  4. INSERT
  5. CHANGE