Online 98-364 Practice TestMore Microsoft Products >

Free Microsoft 98-364 Exam Dumps Questions

Microsoft 98-364: Microsoft Database Fundamentals

- Get instant access to 98-364 practice exam questions

- Get ready to pass the Microsoft Database Fundamentals exam right now using our Microsoft 98-364 exam package, which includes Microsoft 98-364 practice test plus an Microsoft 98-364 Exam Simulator.

- The best online 98-364 exam study material and preparation tool is here.

4.5

(3285 ratings)

Question 1

One difference between a function and a stored procedure is that a function:

A. Must be called from a trigger.

B. Must return a value.

C. Cannot contain a transaction.

D. Cannot accept parameters.

Correct Answer:B

Question 2

Which statement should you use to remove a foreign key?

A. ALTER TABLE

B. DELETE TABLE

C. DELETE FOREIGN KEY

D. ALTER FOREIGN KEY

Correct Answer:A

Question 3

You execute a statement inside a transaction to delete 100 rows from a table. The transaction fails after only 40 rows are deleted.
What is the result in the database?

A. The table will be corrupted.

B. Forty (40) rows will be deleted from the table.

C. The transaction will restart.

D. No rows will be deleted from the table.

Correct Answer:D

Question 4

Your class project requires that you help a charity to create a website that registers volunteers.
The website must store the following data about the volunteers:
✑ Given name
✑ Surname
✑ Telephone number
✑ Email address
You need to recommend a correct way to store the data. What do you recommend?

A. Create a table that contains columns that are named given name, surname, phone number, and email.

B. Create a table that contains rows that are named given name, surname, phone number, and email.

C. Create a view that contains columns that are named given name surname, phone number, and email.

D. Create a view that contains rows that are named given name surname, phone number, and email

Correct Answer:A

Question 5

This question requires that you evaluate the underlined text to determine if it is correct. Use the ALLOW SELECT command to give a user permission to read the data in a table.
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. No change is needed

B. GRANT SELECT

C. LET HEAD

D. PERMIT READ

Correct Answer:B

Question 6

Which statement creates a composite key?
98-364 dumps exhibit

A. Option A

B. Option B

C. Option C

D. Option D

Correct Answer:D

START 98-364 EXAM