You have a database table that stores information about school attendance. You have a data set that is defined as follows:

You have the following requirements:

StudentName must consist of a string of characters.

GradeLevel must be only a whole number.

DaysAbsent can have one number after the decimal.

Match the data types to the column names.

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

Select and Place:

You have a table that contains the following data.

Which database term is used to describe the relationship between ProductID and ProductCategory?

A. Cohort

B. Relationally dependent

C. Deterministic

D. Functionally dependent

E. Compositional

Which permission does a user need in order to run a stored procedure?

A. EXECUTE

B. ALLOW

C. CALL

D. RUN

The component that holds information for a single entry in a table is called a:

A. Data type

B. Row

C. Column D. View

Denormalization is performed in order to:

A. Reduce redundancy.

B. Eliminate repeating groups.

C. Create smaller tables.

D. Improve query performance.

You have a table named Product that contains the following data.

The PrcducrID column is the primary key. The CategoryID column is a foreign key to a separate table named Category.

You execute the following statement:

INSERT INTO Product

VALUES (3296, 'Table', 4444)

What is the result?

A. a foreign key constraint violation

B. a syntax error

C. a new row in the Product table

D. a primary key constraint violation

E. a new row in the Category table

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

A. candidate

B. foreign

C. superkey

D. local

E. primary

Which statement deletes the rows where the employee's phone number is not entered?

A. Option A

B. Option B

C. Option C

D. Option D

On which database structure does an insert statement operate?

A. Role

B. Trigger

C. User

D. Stored procedure

E. Table

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