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 need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used.

Which data type should you use?

A. VARCHAR (3, 30)

B. CHAR (3, 30)

C. VARCHAR (30)

D. CHAR (30)

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

Which two elements are required to define a column? (Choose two.)

A. A name

B. A key

C. An index

D. A data type

Which type of index changes the order in which the data is stored in a table?

A. non-sequential

B. sequential

C. non-clustered

D. clustered

Which statement should you use to remove a foreign key?

A. ALTER TABLE

B. DELETE TABLE

C. DELETE FOREIGN KEY

D. ALTER FOREIGN KEY

You need to combine the results of two queries into a single result that contains all of the rows from both queries. Which Structured Query Language (SQL) statement should you use?

A. TRUNCATE

B. JOIN

C. EXCEPT

D. UNION

While attending college, you accept an IT internship at a local charity. The charity needs to report on data that is related and exists in two tables.

You need to establish a relationship between the data that is in the two tables.

Which constraint should you define?

A. Foreign key

B. Index key

C. Link key

D. Default key

You work for a small auto trading company. You need to remove a car from the company database. Information about the car is stored in the following tables.

All of the car's parts are custom made, so they each have a row in every table. Cascading deletes are not enabled but referential integrity is. From which table must you first make your deletion?

A. Make

B. Model

C. Engine

D. ModelEngine

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

The UNION 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. JOIN