The throw keyword is used to perform which two actions? (Choose two.)

Which three phrases are advantages of connection pooling? (Choose three.)

HOTSPOT
You have the following flowchart:

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

You are creating a database for a student directory. The Students table contains the
following fields:

Which statement will retrieve only the first name, last name, and telephone number for every
student listed in the directory?

This question requires that you evaluate the underlined text to determine if it is correct.
The benefit of using a transaction when updating multiple tables is that the update cannot
fail.
Select the correct answer if the underlined text does not make the statement correct. Select
“No change is needed” if the underlined text makes the statement correct.

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

What are two advantages of normalization in a database? (Choose two)

This question requires that you evaluate the underlined text to determine if it is correct.
Unit testing is the final set of tests that must be completed before a feature or product can be
considered finished.
Select the correct answer if the underlined text does not make the statement correct. Select
“No change is needed” if the underlined text makes the statement correct.

HOTSPOT

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

You need to create a stored procedure that passes in a person’s name and age.
Which statement should you use to create the stored procedure?