You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the
FirstName column. You execute the following statement: DELETE FROM Student What is the result?

You need to establish a set of permissions that you can routinely assign to new users. What should
you create?

Which database term is used to describe the process of applying a backup to a damaged or corrupt
database?

You need to disable User1’s access to view the data in the Customer table. Which statement should
you use?

Denormalization is performed in order to:

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?

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?

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

One difference between a function and a stored procedure is that a function:

Which keyword must be included in a create view statement?