98-364 Online Practice Questions and Answers

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

Hot Area:

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.

Hot Area:

You are structuring a table in a relational database.

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

Hot Area:

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

A. EXECUTE

B. ALLOW

C. CALL

D. RUN

You have a table named Product that contains the following data.

The PrcducrID column is the primary key. The CategoryID column is a foreign key to a separate table named Category.

You execute the following statement:

INSERT INTO Product

VALUES (3296, 'Table', 4444)

What is the result?

A. a foreign key constraint violation

B. a syntax error

C. a new row in the Product table

D. a primary key constraint violation

E. a new row in the Category table

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

The JOIN keyword combines the results of two queries and returns only rows that appear in both result sets.

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

C. ALL

D. UNION

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

You combine data from three tables into one table. The new table includes redundancy to optimize read performance.

The data in the new table has been denormalized.

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

C. Truncated

D. Indexed

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.

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

You have two tables named Cars and Color as defined below. The two tables are related by ColorId.

You run the following SQL statement: select:

How many rows does the SQL statement return?

A. 0

B. 2

C. 3

D. 6