Question 1

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

Accepted Answer

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

Question 2

SQL Server bulk-logged recovery differs from other log-based recovery methods because it does not include log entries for changes that cause large log entries.

Accepted Answer

A) True 
 B)False

Question 3

When viewing a table in the GUI tools table design window in SQL Server,the primary key is indicated by a black arrow.

Accepted Answer

A) True 
 B)False

Question 4

When viewing the SQL Server list of tables in a database,dbo means "domain base object" and indicates a system table.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Locking hints included in an SQL statement will override locking behavior based on explicit transaction isolation level statements.

Accepted Answer

A) True 
 B)False

Question 7

In an SQL Server clustered index,the data are stored in the bottom level of the index and in the same order as the index.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) /* 
B) # 
C) ## 
D) @ 
E) @@ 
A) /* 
B) # 
C) ## 
D) @ 
E) @@

Question 10

Briefly describe how a developer defines the type of locking behavior to be used with SQL Server.

Accepted Answer

Locking behavior in SQL Server is determ

Question 11

The SQL Server default when creating a new database is to create ________ for each database.

Accepted Answer

A) one data file and one log file 
B) one data file and two log files 
C) two data files and one log file 
D) two data files and two log files 
E) there is no default the database creator must specify how many data files and log files will be created 
A) one data file and one log file 
B) one data file and two log files 
C) two data files and one log file 
D) two data files and two log files 
E) there is no default the database creator must specify how many data files and log files will be created

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

Question 14

Explain the SQL Server IDENTITY constraint.

Accepted Answer

The IDENTITY constraint is used to defin

Question 15

Which of the following is true of clustered indexes?

Accepted Answer

A) They are normally slower than nonclustered indexes for retrieving data. 
B) Only one is allowed per table. 
C) They are normally slower than nonclustered indexes for updating data. 
D) They do not have data in the bottom level. 
E) A and C 
A) They are normally slower than nonclustered indexes for retrieving data. 
B) Only one is allowed per table. 
C) They are normally slower than nonclustered indexes for updating data. 
D) They do not have data in the bottom level. 
E) A and C

Question 16

SQL Server automatically makes determinations of whether or not to promote or demote a lock.

Accepted Answer

A) True 
 B)False

Question 17

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 18

The SQL Server GUI program is the Enterprise Manager.

Accepted Answer

A) True 
 B)False

Question 19

PL/SQL is a programming language for SQL Server that adds programming constructs to the SQL language.

Accepted Answer

A) True 
 B)False

Question 20

The Microsoft SQL Server Management Studio Manager can be used to create a new database.

Accepted Answer

A) True 
 B)False

Exam 10: Managing Databases With SQL Server 2008 R2

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

SQL Server bulk-logged recovery differs from other log-based recovery methods because it does not include log entries for changes that cause large log entries.

When viewing a table in the GUI tools table design window in SQL Server,the primary key is indicated by a black arrow.

When viewing the SQL Server list of tables in a database,dbo means "domain base object" and indicates a system table.

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

Locking hints included in an SQL statement will override locking behavior based on explicit transaction isolation level statements.

In an SQL Server clustered index,the data are stored in the bottom level of the index and in the same order as the index.

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

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

Briefly describe how a developer defines the type of locking behavior to be used with SQL Server.

The SQL Server default when creating a new database is to create ________ for each database.

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

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.

Explain the SQL Server IDENTITY constraint.

Which of the following is true of clustered indexes?

SQL Server automatically makes determinations of whether or not to promote or demote a lock.

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

The SQL Server GUI program is the Enterprise Manager.

PL/SQL is a programming language for SQL Server that adds programming constructs to the SQL language.

The Microsoft SQL Server Management Studio Manager can be used to create a new database.

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