Free Microsoft 98-364 Exam Dumps Questions & Answers

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

• A.  MODIFY
• B.  UPDATE
• C.  INSERT
• D.  CHANGE
• E.  ALTER

This question requires that you evaluate the underlined text to determine if it is correct.
Use the ALTER statement to add a new table in a database.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.

• A.  UPDATE
• B.  INSERT
• C.  No change is needed
• D.  CREATE

You need to list the name and price of each product, sorted by price from highest to lowest. Which statement should you use?

• A.  Option C
• B.  Option A
• C.  Option B
• D.  Option D

You have a database table that contains the following columns:

You must insert the following record into the table:

Which two Structured Query Language (SQL) statements can you use? (Choose two.)

• A.  Option C
• B.  Option A
• C.  Option B
• D.  Option D

What are three valid data manipulation language (DML) commands? (Choose three.)

• A.  UPDATE
• B.  OUTPUT
• C.  INSERT
• D.  DELETE
• E.  COMMIT