You have a table that contains the following data.

You break the table into the following two tables.

This process is referred to as:

You have a table that contains the following data.

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

Which key uniquely identifies a row in a table?

Which statement creates a composite key?

At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you
create a table named Customer and import data into the table. At 5:00 P.M. (1700 hours), your
server fails.
You run a script to apply only the 3:00 P.M. backup to your database. What is the result of the
script?

In which situation do you need to perform a restore on a database?

Which command should you use to give a user permission to read the data in a table?

You need to enable a new employee to authenticate to your database.
Which command should you use?

Which keyword can be used in a create table statement?

You need to store product quantities, and you want to minimize the amount of storage space that is
used. Which data type should you use?