Question 1

To use an SQL Server reserved word as a user identifier,it must be enclosed in square brackets [ ].

Accepted Answer

A) True 
 B)False  True

Question 2

The name TRANSACTION is so special to SQL Server that no stored procedures will work on a table with that name.

Accepted Answer

A) True 
 B)False  True

Question 3

SQL Server AFTER triggers may be used with insert and update actions,but not delete actions.

Accepted Answer

A) True 
 B)False  False

Question 4

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

Accepted Answer

A)  PL/SQL
B)  SQLP
C)  C++
D)  INTERACT-SQL
E)  TRANSACT-SQL

Question 5

Which of the following is the most restrictive transaction isolation level supported by SQL Server?

Accepted Answer

A)  Pessimistic
B)  Read Committed
C)  Serializable
D)  Read Uncommitted
E)  Repeatable Read

Question 6

With SQL Server,the preferred way to create database structures is with SQL statements.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A)  SCROLL_LOCK
B)  Optimistic
C)  Serializable
D)  Read only
E)  Pessimistic

Question 9

Which of the following is not a type of trigger supported by SQL Server?

Accepted Answer

A)  BEFORE
B)  INSTEAD OF
C)  CONCURRENT
D)  AFTER
E)  A and C

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

With SQL Server,a nonclustered index does not contain data but has pointers to the data.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

In SQL Server,insert and update triggers store new values in a pseudotable named inserted.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A)  Clustered
B)  Nonclustered
C)  Unique
D)  baseline
E)  B and D

Question 15

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

Accepted Answer

A)  Pessimistic
B)  Read Committed
C)  Serializable
D)  Read Uncommitted
E)  Repeatable Read

Question 16

In SQL Server,triggers can roll back the transaction that caused them to be fired.

Accepted Answer

A) True 
 B)False

Question 17

The SQL Server GUI interface database management program is the ________.

Accepted Answer

A)  Enterprise Manager
B)  Query Analyzer
C)  Microsoft SQL Server Management Studio
D)  A and B
E)  A,B and C

Question 18

When creating a T-SQL statement,you should:

Accepted Answer

A)  predefine it graphically in Enterprise Manager.
B)  limit it to one table.
C)  limit it to two tables.
D)  end it with the semicolon normally used to terminate SQL statements.
E)  include the word "View" in the view name.

Question 19

A stored procedure can be stored in a text file and run with the Microsoft SQL Server Management Studio.If we are running the code that creates this procedure for the third time,it must start with ________.

Accepted Answer

A)  STORED PROCEDURE
B)  CREATE PROCEDURE
C)  ALTER PROCEDURE
D)  MODIFY PROCEDURE
E)  RUN PROCEDURE

Question 20

One means of processing an SQL Server database is to save groups of SQL Server DBMS commands in a text file and then process this file in the Microsoft SQL Server Management Studio.

Accepted Answer

A) True 
 B)False

Exam 10: Managing Databases With SQL Server 2008 R2

To use an SQL Server reserved word as a user identifier,it must be enclosed in square brackets [ ].

The name TRANSACTION is so special to SQL Server that no stored procedures will work on a table with that name.

SQL Server AFTER triggers may be used with insert and update actions,but not delete actions.

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

Which of the following is the most restrictive transaction isolation level supported by SQL Server?

With SQL Server,the preferred way to create database structures is with SQL statements.

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

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

Which of the following is not a type of trigger supported by SQL Server?

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

With SQL Server,a nonclustered index does not contain data but has pointers to the data.

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

In SQL Server,insert and update triggers store new values in a pseudotable named inserted.

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

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

In SQL Server,triggers can roll back the transaction that caused them to be fired.

The SQL Server GUI interface database management program is the ________.

When creating a T-SQL statement,you should:

A stored procedure can be stored in a text file and run with the Microsoft SQL Server Management Studio.If we are running the code that creates this procedure for the third time,it must start with ________.

One means of processing an SQL Server database is to save groups of SQL Server DBMS commands in a text file and then process this file in the Microsoft SQL Server Management Studio.