Microsoft Microsoft Certifications 98-364 Questions & Answers

• Question 91:

  The Product table contains the following data.

  

  You execute the following statement:

  SELECT COUNT(*)

  FROM Product WHERE Quantity > 18

  What is the value returned by this statement?

  A. 1

  B. 2

  C. 3

  D. 4

  Correct Answer: C

• Question 92:

  Which command should you use to remove a table from a database?

  A. REMOVE TABLE

  B. UPDATE TABLE

  C. DROP TABLE

  D. DELETE TABLE

  Correct Answer: C

• Question 93:

  You need to store the contact information for each student in your school database. You should store each student's information in a:

  A. Stored procedure

  B. Function

  C. Row

  D. Variable

  Correct Answer: C

• Question 94:

  Which category of SQL statements is used to add, remove, and modify database structures?

  A. Data access language (DAL)

  B. Data manipulation language (DML)

  C. Data control language (DCL)

  D. Data definition language (DDL)

  Correct Answer: D

• Question 95:

  A database contains two tables named Customer and Order.

  You execute the following statement:

  DELETE FROM Order

  WHERE CustomerID = 209

  What is the result?

  A. The first order for CustomerID 209 is deleted from the Order table.

  B. All orders for CustomerID 209 are deleted from the Order table, and CustomerID 209 is deleted from the Customer table.

  C. All orders for CustomerID 209 are deleted from the Order table.

  D. CustomerID 209 is deleted from the Customer table.

  Correct Answer: C

• Question 96:

  You have a table named Product. The Product table has columns for ProductDescription and ProductCategory.

  You need to change the ProductCategory value for all the spoons in the Product table to 43.

  Which statement should you use?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 97:

  You have a table that contains information about all students in your school.

  Which SQL keyword should you use to change a student's first name in the table?

  A. UPDATE

  B. CHANGE

  C. SELECT

  D. INSERT

  Correct Answer: A

• Question 98:

  You execute the following statement:

  SELECT EmployeeID, FirstName, DepartmentName FROM Employee, Department

  This type of operation is called a/an:

  A. Intersection

  B. Outer join

  C. Equi-join

  D. Cartesian product

  Correct Answer: D

• Question 99:

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

  A. MODIFY

  B. ALTER

  C. UPDATE

  D. INSERT

  E. CHANGE

  Correct Answer: B

• Question 100:

  You have the following table definition:

  CREATE TABLE Product

  (ID INTEGER PRIMARY KEY,

  Name VARCHAR(20),

  Quantity INTEGER)

  The Product table contains the following data.

  

  You execute the following statement:

  SELECT Name FROM Product WHERE Quantity IS NOT NULL

  How many rows are returned?

  A. 0

  B. 1

  C. 2

  D. 3

  E. 4

  Correct Answer: D