Question 1

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

Accepted Answer

A) True 
 B)False  True

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

Explain two ways of creating tables in SQL Server.

Accepted Answer

SQL Server tables can be created in either the Microsoft SQL Server Management Studio,which is a GUI environment,or in Microsoft PowerShell if a command line method is preferred.The Microsoft SQL Server Management Studio,like any Windows program,uses a set of menu choices and dialog boxes to create tables.Properties in property dialog boxes can be used to modify table and column properties.The Microsoft SQL Server Management Studio also allows the use of standard SQL statements to create and modify tables.Although it is text-based,it is simpler to use because it uses standard SQL.

Question 4

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) being underlined 
A) the black arrow symbol 
B) the outline arrow symbol 
C) the key symbol 
D) being underlined

Question 5

The name TRANSACTION is so special to SQL Server that no stored procedures will work on a table with that name.

Accepted Answer

A) True 
 B)False

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

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) RUN PROCEDURE 
B) CREATE PROCEDURE 
C) ALTER PROCEDURE 
D) MODIFY PROCEDURE 
A) RUN PROCEDURE 
B) CREATE PROCEDURE 
C) ALTER PROCEDURE 
D) MODIFY PROCEDURE

Question 9

SQL Server AFTER triggers may be used with insert and update actions,but not delete actions.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is not a transaction isolation level supported by SQL Server?

Accepted Answer

A) Pessimistic 
B) Read Committed 
C) Serializable 
D) Read Uncommitted 
A) Pessimistic 
B) Read Committed 
C) Serializable 
D) Read Uncommitted

Question 12

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

Accepted Answer

A) Repeatable Read 
B) Read Committed 
C) Serializable 
D) Read Uncommitted 
A) Repeatable Read 
B) Read Committed 
C) Serializable 
D) Read Uncommitted

Question 13

Which of the following is true about SQL Server Import and Export Wizard?

Accepted Answer

A) SQL Server Native Client should be selected as the destination. 
B) The user can't specify that the column names are in the first row. 
C) There are no problems with modifying the default column attributes. 
D) The user can specify the primary key to be set on the imported table. 
A) SQL Server Native Client should be selected as the destination. 
B) The user can't specify that the column names are in the first row. 
C) There are no problems with modifying the default column attributes. 
D) The user can specify the primary key to be set on the imported table.

Question 14

Which of the following is a type of recovery model supported in SQL Server in which all database changes are logged?

Accepted Answer

A) Bulk logged 
B) Full 
C) Simple 
D) Complete 
A) Bulk logged 
B) Full 
C) Simple 
D) Complete

Question 15

Which type of backup in SQL Server will create a backup of the entire database?

Accepted Answer

A) Full backup 
B) Transaction backup 
C) Database backup 
D) Complete backup 
A) Full backup 
B) Transaction backup 
C) Database backup 
D) Complete backup

Question 16

In SQL Server,triggers can roll back the transaction that caused them to be fired.

Accepted Answer

A) True 
 B)False

Question 17

Explain the SQL Server IDENTITY constraint.

Accepted Answer

The IDENTITY constraint is used to defin

Question 18

Database views can only be created in SQL Server through the use of SQL commands.

Accepted Answer

A) True 
 B)False

Question 19

Briefly explain the different SQL Server backup types.

Accepted Answer

SQL Server supports three types of backu

Question 20

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) HINT 
A) SELECT 
B) WITH 
C) LOCK 
D) HINT

Exam 10: Managing Databases With SQL Server 2014

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

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

Explain two ways of creating tables in SQL Server.

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

The name TRANSACTION is so special to SQL Server that no stored procedures will work on a table with that name.

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

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

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

SQL Server AFTER triggers may be used with insert and update actions,but not delete actions.

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

Which of the following is not a transaction isolation level supported by SQL Server?

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

Which of the following is true about SQL Server Import and Export Wizard?

Which of the following is a type of recovery model supported in SQL Server in which all database changes are logged?

Which type of backup in SQL Server will create a backup of the entire database?

In SQL Server,triggers can roll back the transaction that caused them to be fired.

Explain the SQL Server IDENTITY constraint.

Database views can only be created in SQL Server through the use of SQL commands.

Briefly explain the different SQL Server backup types.

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

Introduction

Introduction to Structured Query Language

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

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With 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 Netbeans IDE

Business Intelligence Systems

Big Data

Filters