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?

You have a table named Customer. You need to add a new column named District. Which statement
should you use?

You need to remove a view named EmployeeView from your database.
Which statement should you use?