98-364 Online Practice Questions and Answers

The following illustration shows the structure of a clustered index in a single partition:

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

Hot Area:

HOTSPOT

You have a user that has server roles as defined below:

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

Hot Area:

At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you create a table named Customer and import data into the table. At 5:00 P.M. (1700 hours), your server fails. You run a script to apply only the

3:00 P.M. backup to your database.

What is the result of the script?

A. The Customer table no longer exists.

B. The Customer table is unaffected.

C. The Customer table exists but has no data.

D. The script fails.

You need to disable User1's access to view the data in the Customer table.

Which statement should you use?

A. Option A

B. Option B

C. Option C

D. Option D

You need to remove a view named EmployeeView from your database. Which statement should you use?

A. DELETE VIEW EmployeeView

B. DELETE EmployeeView

C. DROP EmployeeView

D. DROP VIEW EmployeeView

You need to list the name and price of each product, sorted by price from highest to lowest. Which statement should you use?

A. Option A

B. Option B

C. Option C

D. Option D

You need to insert two new products into the Product table. The first product is named Book and has an ID of 125. The second product is named Movie and has an ID of 126.

Which statement should you use?

A. Option A

B. Option B

C. Option C

D. Option D

You have a table that contains product IDs and product names.

You need to write an UPDATE statement to change the name of a specific product to glass.

What should you include in the update statement?

A. SET ProduetName = 'glass'

B. LET ProduetName = 'glass'

C. EXEC ProduetName = 'glass'

D. ASSIGN ProduetName = 'glass'

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

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

A key defines the amount of storage space that is allocated to a value in a column.

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

C. data type

D. validator