CET_TARDE - MTA Database - E_backup_permissions

This question requires that you evaluate the underlined text to determine if it is correct. Use the ALLOW SELECT command to give a user permission to read the data in a table. 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:

You have a user that has server roles as defined below:

The following illustration shows backup strategies that use the simple recovery model and the full recovery model:

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

The following graphic shows the components of a SQL Server application. You access the SQL Server application through Internet Explorer.

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

You assign User1 a set of permissions that include the WITH GRANT OPTION. The WITH GRANT OPTION enables User1 to:

A named group of SQL statements that can be executed in a database is called a:

A named group of SQL statements that can be executed in a database is called a:

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?

One reason to create a stored procedure is to:

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

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

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

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?

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.