You have a table named Product that contains one million rows.
You need to search for product information in the Product table by using the product's unique ID.
What will make this type of search more efficient?

Correct Answer:D

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

Correct Answer:B

DRAG DROP
You have two database tables as defined below. The first table contains information about students. The second table contains information about courses. The two tables are related by CourseID.

Match the CourseName to the StudentName.
Instructions: To answer, drag the appropriate CourseName from the column on the left to its StudentName on the right. Each CourseName may be used once, more than once, or not at all. Each correct match is worth one point.

Solution:


Does this meet the goal?

Correct Answer:A

You need to retrieve data from two related database tables based on a column that exists in both tables.
Which command should you use in a query?

Correct Answer:B

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

Solution:


Does this meet the goal?

Correct Answer:A

You work at a restaurant and they ask you to help them with a data issue. They provide you with the following recipe data:

You need to normalize the data to third normal form.
How many tables should you create?

Correct Answer:C