98-364 Free Practice Test

In SQL, an insert statement is used to add a:

1. A. User to a database.
2. B. Row of data to a table.
3. C. Table to a database.
4. D. Column to a table definition.

Correct Answer: B

This question requires that you evaluate the underlined text to determine if it is correct. Use the ALTER statement to add a new table in a database.
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.

1. A. No change is needed
2. B. UPDATE
3. C. INSERT
4. D. CREATE

Correct Answer: D

One reason to create a stored procedure is to:

1. A. Improve performance.
2. B. Minimize storage space.
3. C. Bypass case sensitivity requirements.
4. D. Give the user control of the query logic.

Correct Answer: A