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

SQL Server supports three types of backu

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 Mircosoft .NET framework is built ar

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 
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 
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 
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 Transact-SQL IDENTITY_INSERT propert

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 
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 
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 IDENTITY constraint is used to defin

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.

Introduction

Introduction to Structured Query Language SQL

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

Sql for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

B: Managing Databases With Oracle Database 11g Release 2

C: Managing Databases With MySQL

The Web Server Environment

Big Data datawarehouse and Business Intelligence Systems

Microsoft Access 2013

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers php and the Eclipse PDT

Business Intelligence Systems

Filters