Question 1

Describe the database files that are automatically created when a new database is created in SQL Server.

Accepted Answer

By default there are two datab

Question 2

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 
E) Pessimistic 
A) SCROLL_LOCK 
B) Optimistic 
C) Serializable 
D) Read only 
E) Pessimistic

Question 3

SQL Server supports AFTER and INSTEAD OF triggers,but not BEFORE triggers.

Accepted Answer

A) True 
 B)False

Question 4

To use an SQL Server reserved word as a user identifier,it must be enclosed in square brackets [ ].

Accepted Answer

A) True 
 B)False

Question 5

SQL Server automatically creates an index on primary key fields only.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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 9

In SQL Server,insert and update triggers store old values in a pseudotable named deleted.

Accepted Answer

A) True 
 B)False

Question 10

SQL Statements can be submitted to SQL Server from the Microsoft SQL Server Management Studio.

Accepted Answer

A) True 
 B)False

Question 11

In SQL Server,a differential backup makes a copy of the entire database.

Accepted Answer

A) True 
 B)False

Question 12

When recovering a database in SQL Server,it is possible to process the log to a particular point in time or to a transaction mark.

Accepted Answer

A) True 
 B)False

Question 13

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 14

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 15

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 
E) Sequence 
A) Identity 
B) Surrogate 
C) AutoIncrement 
D) AutoNumber 
E) Sequence

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Discuss the Microsoft PowerShell utility.

Accepted Answer

Microsoft Windows PowerShell is a very p

Question 19

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 20

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

Exam 10: A: Managing Databases With SQL Server 20012

Describe the database files that are automatically created when a new database is created in SQL Server.

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

SQL Server supports AFTER and INSTEAD OF triggers,but not BEFORE triggers.

To use an SQL Server reserved word as a user identifier,it must be enclosed in square brackets [ ].

SQL Server automatically creates an index on primary key fields only.

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

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.

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

In SQL Server,insert and update triggers store old values in a pseudotable named deleted.

SQL Statements can be submitted to SQL Server from the Microsoft SQL Server Management Studio.

In SQL Server,a differential backup makes a copy of the entire database.

When recovering a database in SQL Server,it is possible to process the log to a particular point in time or to a transaction mark.

SQL Server tables can be created and modified using ________.

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.

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?

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

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

Discuss the Microsoft PowerShell utility.

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

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.

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