Exam 10: Managing Databases With SQL Server 2014

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.

Explain SQL Server indexes.

Briefly describe how a developer defines the type of locking behavior to be used with SQL Server.

In an SQL Server clustered index,the data are stored in the bottom level of the index and in the same order as the index.

SQL Server system function names start with the symbol ________.

When you use the Microsoft SQL Server Management Studio to run and rerun a set of SQL Server DBMS commands stored in a text file,the stored procedure must start with CREATE PROCEDURE.

A view may not be assigned to a(n)________.

With SQL Server,a clustered index has the data with,and in the same order as,the bottom level of the index.

The default cursor concurrency setting for a keyset cursor in SQL Server is ________.

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

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 automatically creates an index on primary key fields only.

Briefly explain the process for importing spreadsheet data into a SQL Server table,and indicate some of the pitfalls or potential problems.

SQL statements can be passed to SQL Server using the ________.

In SQL Server,locking behavior can be modified by providing locking hints in the WITH parameter of the FROM clause in SELECT statements.

Which of the following is the default transaction isolation level for SQL Server?

The language available in SQL Server that adds programming constructs to the SQL language is known as ________.

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

Which type(s)of index in SQL Server has/have a bottom level that does not contain data but has pointers to the data?

Data can be entered directly into a table in Enterprise Manager or via SQL INSERT statements submitted through the Microsoft SQL Server Management Studio.