Microsoft 98-364 Exam Material | 98-364 Dumps PDF | Dumpspass4sure

SAMPLE QUESTIONS:

Question No. 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.

Answer: B

Question No. 2

This question requires that you evaluate the underlined text to determine if it is correct. Create a query that returns a set of table data by using the UPDATE statement.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. INSERT

C. REPLACE

D. SELECT

Answer: D

Question No. 3

This question requires that you evaluate the underlined text to determine if it is correct. A row holds information for a single record 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. Column

C. Data type

D. View

Answer: A

Question No. 4

You assign User1 a set of permissions that include the WITH GRANT OPTION. The WITH GRANT OPTION enables User1 to:

A. Request a log of permission use.

B. Delegate permissions to other users.

C. Create new database users.

D. View other users' permissions.

Answer: C

Question No. 5

You need to add rows to a database table. Which Structured Query Language (SQL) keyword should you use?

A. JOIN

B. INSERT

C. CREATE

D. UPDATE

Answer: A

FOR MORE INFORMATION 

VISIT NOW :

https://www.dumpspass4sure.com/microsoft/98-364-dumps.html