Exam 10: Managing Databases With SQL Server 2008 R2

Stored procedures and triggers in SQL Server may become confused while executing stored procedures and triggers when SQL Server special words such as TRANSACTION appear as table or other names,even if they are enclosed in square brackets [ ].

In SQL Server,a interactive backup makes a copy of the changes that have been made since the last time a backup of the entire database was made.

Briefly explain the different SQL Server recovery models.

When viewing a table in the GUI tools table design window in SQL Server,the notation that should supply the values for a surrogate key is that the Identity property of that column is set to "Yes."

SQL Server supports AFTER and INSTEAD OF triggers,but not BEFORE triggers.

SQL Server supports three types of indexes: clustered,unclustered,and random.

The recommended SQL Server security is Windows-only security.

SQL Statements can be submitted to SQL Server from the Microsoft SQL Server Management Studio.

Which type of backup in SQL Server will create a backup of the entire database?

SQL Server system functions start with the symbol ________.

With SQL Server,the clustered index is faster for data retrieval.

In SQL Server,a differential backup makes a copy of the entire database.

When using SQL Server,developers place explicit locks.

The default cursor concurrency for a dynamic cursor in SQL Server is optimistic.

When recovering a database in SQL Server,it is possible to process the log to a particular point in time or to a transaction mark.

In SQL Server,insert and update triggers store old values in a pseudotable named deleted.

Discuss the Microsoft PowerShell utility.

What is the SQL CLR?

Which of the following is true about indexes in SQL Server?

Which of the following is a type of recovery model supported in SQL Server in which all database changes are logged?