Question 1

Which of the following are ways of processing an SQL Server database?

Accepted Answer

A) From an application written in a programming language such as C# or Visual Basic 
B) From text files processed by the SQL Server Query Analyzer 
C) From invoked SQL Server stored procedures 
D) From invoked SQL Server triggers 
E) All of the above. 
A) From an application written in a programming language such as C# or Visual Basic 
B) From text files processed by the SQL Server Query Analyzer 
C) From invoked SQL Server stored procedures 
D) From invoked SQL Server triggers 
E) All of the above.

Question 2

Which of the following is the default transaction isolation level for 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 3

Briefly explain the different SQL Server backup types.

Accepted Answer

SQL Server supports three types of backu

Question 4

In the Microsoft SQL Server Management Studio,the amount to add to the surrogate key value when adding a new row is specified by the increment property.

Accepted Answer

A) True 
 B)False

Question 5

SQL Server security provides three modes of authentication.

Accepted Answer

A) True 
 B)False

Question 6

Explain SQL Server indexes.

Accepted Answer

There are two types of SQL Server indexe

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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) SQL 
E) KEY 
A) NAME 
B) UPDATE 
C) TRANSACTION 
D) SQL 
E) KEY

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

Specifying locking hints in which parameter in an SQL clause can modify locking behavior in SQL Server?

Accepted Answer

A) SELECT 
B) WITH 
C) LOCK 
D) TRANS 
E) HINT 
A) SELECT 
B) WITH 
C) LOCK 
D) TRANS 
E) HINT

Question 12

When you use the Microsoft SQL Server Management Studio to run and rerun a set of SQL Server DBMS commands stored in a text file,the stored procedure must start with CREATE PROCEDURE.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Explain two ways of creating tables in SQL Server.

Accepted Answer

SQL Server tables can be created in eith

Question 15

SQL Server supports three recovery models: simple,complex and bulk logged.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

SQL Server tables can be created and modified using ________.

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

The SQL Server default when creating a new database is to create two data files and one log file for each database.

Accepted Answer

A) True 
 B)False

Question 19

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 
E) None of the above. 
A) a table named new:TableName 
B) a table named old:TableName 
C) a pseudotable name inserted 
D) a pseudotable named deleted 
E) None of the above.

Question 20

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

Accepted Answer

A) the black arrow symbol 
B) the outline arrow symbol 
C) the key symbol 
D) the asterisk symbol 
E) being underlined 
A) the black arrow symbol 
B) the outline arrow symbol 
C) the key symbol 
D) the asterisk symbol 
E) being underlined

Exam 10: Managing Databases With SQL Server 2008 R2

Which of the following are ways of processing an SQL Server database?

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

Briefly explain the different SQL Server backup types.

In the Microsoft SQL Server Management Studio,the amount to add to the surrogate key value when adding a new row is specified by the increment property.

SQL Server security provides three modes of authentication.

Explain SQL Server indexes.

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

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?

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

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

Specifying locking hints in which parameter in an SQL clause can modify locking behavior in SQL Server?

When you use the Microsoft SQL Server Management Studio to run and rerun a set of SQL Server DBMS commands stored in a text file,the stored procedure must start with CREATE PROCEDURE.

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

Explain two ways of creating tables in SQL Server.

SQL Server supports three recovery models: simple,complex and bulk logged.

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

SQL Server tables can be created and modified using ________.

The SQL Server default when creating a new database is to create two data files and one log file for each database.

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

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

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

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

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 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters