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)

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

A. User to a database.

B. Row of data to a table.

C. Table to a database.

D. Column to a table definition.

You are writing a select statement to find every product whose name contains a specific character. Which keyword should you use in your where clause?

A. FIND

B. BETWEEN

C. INCLUDES

D. LIKE

You need to store the contact information for each student in your school database. You should store each student's information in a:

A. Stored procedure

B. Function

C. Row

D. Variable

You have a Customer table and an Order table. You join the Customer table with the Order table by using the CusromerID column.

The results include: All customers and their orders Customers who have no orders

Which type of join do these results represent?

A. Complete join

B. Partial join

C. Inner join

D. Outer join

Which two keys establish a relationship between two tables? (Choose two.)

A. candidate

B. foreign

C. superkey

D. local

E. primary

You have a table that contains product IDs and product names.

You need to write an UPDATE statement to change the name of a specific product to glass.

What should you include in the update statement?

A. SET ProduetName = 'glass'

B. LET ProduetName = 'glass'

C. EXEC ProduetName = 'glass'

D. ASSIGN ProduetName = 'glass'

You have a table of products with fields for ProductID, Name, and Price.

You need to write an UPDATE statement that sets the value in the InStock field to Yes for a specific ProductID.

Which clause should you use in your update statement?

A. THAT

B. WHERE

C. GROUP BY

D. HAVING

You develop a database to store data about textbooks. The data must be stored to process at a later time. Which database object should you use to store the data?

A. View

B. Table

C. Function

D. Stored procedure

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

First normal form requires that a database excludes repeating groups.

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. Composite keys

C. Duplicate rows

D. Foreign keys