Actualtests 98-364 Questions are updated and all 98-364 answers are verified by experts. Once you have completely prepared with our 98-364 exam prep kits you will be ready for the real 98-364 exam without a problem. We have Update Microsoft 98-364 dumps study guide. PASSED 98-364 First attempt! Here What I Did.

Q31. Which statement will result in the creation of an index?

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer: A 


Q32. Which permission does a user need in order to run a stored procedure? 

A. EXECUTE 

B. ALLOW 

C. CALL 

D. RUN 

Answer: A


Q33. A named group of SQL statements that can be executed in a database is called a: 

A. Subroutine 

B. Formula 

C. Stored procedure 

D. Method 

Answer: C 


Q34. You need to enable a new employee to authenticate to your database. 

Which command should you use? 

A. ALLOW USER 

B. CREATE USER 

C. ADD USER 

D. INSERT USER 

E. ALTER USER 

Answer: B


Q35. One reason to add an index is to: 

A. Decrease storage space. 

B. Increase database security. 

C. Improve performance of select statements. 

D. Improve performance of insert statements.

Answer: C 


Q36. HOTSPOT

You have two database tables as defined below. The StateID column is unique in the State table. The AddressID column is unique in the Address table. The two tables are related by the StateID column. 

Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point. 

Answer: 


Q37. You have a table that contains the following data. 

 

Which database term is used to describe the relationship between ProductID and ProductCategory? 

A. Cohort 

B. Relationally dependent 

C. Deterministic 

D. Functionally dependent 

E. Compositional 

Answer: D 


Q38. 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 


Q39. HOTSPOT

The following graphic shows the components of a SQL Server application. You access the SQL Server application through Internet Explorer.

Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point. 

Answer: 


Q40. HOTSPOT 

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point. 

Answer: 


Q41. DRAG DROP 

Your class project requires that you help a charity set up a website. 

The website collects information about volunteers. Each volunteer record must be uniquely identified. 

The following information is stored for each volunteer: 

Given name 

Surname 

Date of birth 

Phone number 

Photo 

You need to create a table to meet the requirements. 

Match the Structured Query Language SQL statements to the SQL query. 

Instructions: To answer, drag the appropriate SQL statement from the column on the left to its place in the SQL query on the right. Each SQL statement may be used once, more than once, or not at all. Each correct match is worth one point. 

Answer: 


Q42. Denormalization is performed in order to: 

A. Reduce redundancy. 

B. Eliminate repeating groups. 

C. Create smaller tables. 

D. Improve query performance. 

Answer: D 


Q43. 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 

Answer: A 


Q44. 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 A 

B. Option B 

C. Option C 

D. Option D 

Answer: A,C


Q45. The terms "bitmap," "b-tree," and "hash" refer to which type of database structure? 

A. View 

B. Function 

C. Index 

D. Stored procedure 

E. Trigger 

Answer: C