Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Explain how to work around the SQL Server IDENTITY constraint when non-sequential data must be entered.

Accepted Answer

The answer of Explain how to work around the SQL...

Question 3

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

Question 4

What name is so special to SQL Server that no stored procedure will work on a table with that name,not even if it is enclosed in brackets?

Accepted Answer

A) NAME 
B) UPDATE 
C) TRANSACTION 
D) KEY

Question 5

In addition to the standard SQL Server 2014 tools,SQL statements such as CREATE TABLE can now also be executed by using Microsoft's PowerShell.

Accepted Answer

A) True 
 B)False

Question 6

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

Question 7

The Microsoft SQL Server Management Studio cannot verify SQL statements until they are executed.

Accepted Answer

A) True 
 B)False

Question 8

Anytime you want to use an SQL Server reserved word as a user identifier,enclose it in ________.

Accepted Answer

A) { } 
B) [ ] 
C) ( ) 
D)

Question 9

Which of the following is known to be true if the command EXEC abcCust @Cost = 5 is used in SQL to invoke a stored procedure in Microsoft SQL Server?

Accepted Answer

A) The name of the stored procedure is abcCust. 
B) The name of the stored procedure is abc. 
C) The parameter Cost is given a value of 5. 
D) Both A and C are correct.

Question 10

The developer can direct SQL Server to create indexes on non-key fields.

Accepted Answer

A) True 
 B)False

Question 11

For triggers on insert and update actions,the new column values are stored in ________.

Accepted Answer

A) a table named new:TableName 
B) a table named old:TableName 
C) a pseudotable name inserted 
D) a pseudotable named deleted

Question 12

What is the SQL CLR?

Accepted Answer

The answer of What is the SQL CLR?...

Question 13

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

Accepted Answer

A) BEFORE 
B) INSTEAD OF 
C) CONCURRENT 
D) Both A and C are correct

Question 14

When reviewing a table in the SQL Server GUI tools,which property should be set to "Yes" to indicate that the column is a surrogate key for which SQL Server should automatically supply values?

Accepted Answer

A) Identity 
B) Surrogate 
C) AutoIncrement 
D) AutoNumber

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

The recommended SQL Server security is Windows-only security.

Accepted Answer

A) True 
 B)False

Question 17

In SQL Server,it is not possible to make dirty reads.

Accepted Answer

A) True 
 B)False

Question 18

SQL Server 2014 provides two ways to create tables-graphically and through SQL code.

Accepted Answer

A) True 
 B)False

Question 19

The default transaction isolation level for SQL Server is Read Committed.

Accepted Answer

A) True 
 B)False

Question 20

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.

Accepted Answer

A) True 
 B)False

Exam 10: Managing Databases With SQL Server 2014

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

Explain how to work around the SQL Server IDENTITY constraint when non-sequential data must be entered.

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

What name is so special to SQL Server that no stored procedure will work on a table with that name,not even if it is enclosed in brackets?

In addition to the standard SQL Server 2014 tools,SQL statements such as CREATE TABLE can now also be executed by using Microsoft's PowerShell.

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.

The Microsoft SQL Server Management Studio cannot verify SQL statements until they are executed.

Anytime you want to use an SQL Server reserved word as a user identifier,enclose it in ________.

Which of the following is known to be true if the command EXEC abcCust @Cost = 5 is used in SQL to invoke a stored procedure in Microsoft SQL Server?

The developer can direct SQL Server to create indexes on non-key fields.

For triggers on insert and update actions,the new column values are stored in ________.

What is the SQL CLR?

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

When reviewing a table in the SQL Server GUI tools,which property should be set to "Yes" to indicate that the column is a surrogate key for which SQL Server should automatically supply values?

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

The recommended SQL Server security is Windows-only security.

In SQL Server,it is not possible to make dirty reads.

SQL Server 2014 provides two ways to create tables-graphically and through SQL code.

The default transaction isolation level for SQL Server is Read Committed.

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.