Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) Cost = 5 is a CHECK constraint. 
B) The name of the stored procedure is abcCust. 
C) The name of the stored procedure is abc. 
D) Cust is given the value 5. 
E) abcCust is the name of a table or view in the database.

Question 3

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 4

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 5

Briefly explain the different SQL Server backup types.

Accepted Answer

The answer of Briefly explain the different SQL Server backup...

Question 6

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 7

What is the SQL CLR?

Accepted Answer

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

Question 8

The default cursor concurrency setting for a keyset 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 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 10

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 11

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 12

SQL Server security roles provide a simple way to control user privileges in a database.

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

In SQL Server,SCROLL_LOCK is a version of pessimistic locking.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) BEFORE trigger 
B) INSTEAD OF trigger 
C) CONCURRENT trigger 
D) AFTER trigger 
E) Any of the above

Question 16

With SQL Server,only one cluster index is allowed per table.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is generally used to create a new database?

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

SQL Server user variables and parameters start with the @ symbol.

Accepted Answer

A) True 
 B)False

Question 19

Explain the SQL Server IDENTITY constraint.

Accepted Answer

The answer of Explain the SQL Server IDENTITY constraint....

Question 20

When using SQL Server,developers place explicit locks.

Accepted Answer

A) True 
 B)False

Exam 10: A: Managing Databases With SQL Server 20012

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

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

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

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

Briefly explain the different SQL Server backup types.

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

What is the SQL CLR?

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

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

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

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

SQL Server security roles provide a simple way to control user privileges in a database.

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

In SQL Server,SCROLL_LOCK is a version of pessimistic locking.

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

With SQL Server,only one cluster index is allowed per table.

Which of the following is generally used to create a new database?

SQL Server user variables and parameters start with the @ symbol.

Explain the SQL Server IDENTITY constraint.

When using SQL Server,developers place explicit locks.