Free Microsoft 98-364 Exam Dumps Questions & Answers

You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers by using a database table named Volunteer.
The table has the following columns and rows:

When volunteer information changes, you must update the table.
You need to change Tia's name to Kimberly.
Which statement should you choose?

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

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

• A.  GET
• B.  READ
• C.  SELECT
• D.  OUTPUT

You have two tables named Salesperson and Sales.
You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesperson table.
Which database object should you add to the Sales table?

• A.  Nonclustered index
• B.  Foreign key
• C.  Clustered index
• D.  Primary key

What defines the amount of storage space that is allocated to a value in a column?

• A.  validator
• B.  key
• C.  data type
• D.  format

Which statement deletes the rows where the employee's phone number is not entered?

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