Microsoft 98-364 Microsoft Database Fundamentals Exam Practice Test

Page: 1 / 14
Total 130 questions

Question 1

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?



Answer : B

Question 2

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.



Answer : D

Question 3

You need to rename a column in a database table.

Which data definition language (DDL) statement should you use?



Answer : A

Question 4

This question requires that you evaluate the underlined text to determine if it is correct.

Use indexing to create, remove, or change database objects.

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.



Answer : C

Question 5

You need to add rows to a database table.

Which Structured Query Language (SQL) keyword should you use?



Answer : A

Page:    1 / 14   
Total 130 questions