Exam 10: A: Managing Databases With SQL Server 20012

One means of processing an SQL Server database is to create application code in a programming language and invoke SQL Server DBMS commands from that program.

Which of the following is a type of cursor concurrency that causes SQL Server to place an update lock on a row when the row is read?

Which of the following is not a transaction isolation level supported by SQL Server?

The SQL Server default when creating a new database is to create ________ for each database.

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

The column(s)that is/are the primary key in an SQL table are indicated by ________ when viewed graphically in Enterprise Manager.

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."

Which of the following is not a lock granularity supported by SQL Server?

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

In SQL Server,the full recovery model creates a log for every change to the database.

Which type of index in SQL Server is faster for data retrieval?

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

SQL Server security provides three modes of authentication.

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

In the Microsoft SQL Server Management Studio,the starting value for a field that has been set as an IDENTITY in SQL Server is set in the seed (StartingValue)property.

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

Briefly explain the different SQL Server recovery models.

Explain two ways of creating tables in SQL Server.

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

Which of the following is true of clustered indexes?