Question 1

When creating a T-SQL statement,you should ________.

Accepted Answer

A) predefine it graphically in Enterprise Manager 
B) limit it to one table 
C) limit it to two tables 
D) end it with the semicolon normally used to terminate SQL statements 
A) predefine it graphically in Enterprise Manager 
B) limit it to one table 
C) limit it to two tables 
D) end it with the semicolon normally used to terminate SQL statements

Question 2

SQL Server AFTER triggers may be assigned to either tables or views.

Accepted Answer

A) True 
 B)False

Question 3

The SQL Server GUI program is the Enterprise Manager.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 6

In SQL Server,SCROLL_LOCK is a version of pessimistic locking.

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

SQL Server supports three types of indexes: clustered,unclustered,and random.

Accepted Answer

A) True 
 B)False

Question 10

When using SQL Server,developers place explicit locks.

Accepted Answer

A) True 
 B)False

Question 11

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 12

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

Accepted Answer

A) @@ 
B) # 
C) ## 
D) @ 
A) @@ 
B) # 
C) ## 
D) @

Question 13

Which of the following is true about indexes in SQL Server?

Accepted Answer

A) SQL Server automatically creates indexes for columns appearing in WHERE clauses in queries. 
B) SQL Server pads all indexes. 
C) SQL Server supports filling up to a limit of 70 percent. 
D) SQL Server automatically creates indexes for foreign keys. 
A) SQL Server automatically creates indexes for columns appearing in WHERE clauses in queries. 
B) SQL Server pads all indexes. 
C) SQL Server supports filling up to a limit of 70 percent. 
D) SQL Server automatically creates indexes for foreign keys.

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Stored procedures and triggers in SQL Server may become confused while executing stored procedures and triggers when SQL Server special words such as TRANSACTION appear as table or other names,even if they are enclosed in square brackets [ ].

Accepted Answer

A) True 
 B)False

Question 16

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

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) Both A and B are correct 
A) Enterprise Manager 
B) Query Analyzer 
C) Microsoft SQL Server Management Studio 
D) Both A and B are correct

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Briefly explain the different SQL Server recovery models.

Accepted Answer

SQL Server supports three recovery model

Question 20

SQL Server built-in system function names start with the @@ symbol.

Accepted Answer

A) True 
 B)False

Exam 10: Managing Databases With SQL Server 2014

When creating a T-SQL statement,you should ________.

SQL Server AFTER triggers may be assigned to either tables or views.

The SQL Server GUI program is the Enterprise Manager.

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

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.

In SQL Server,SCROLL_LOCK is a version of pessimistic locking.

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

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

SQL Server supports three types of indexes: clustered,unclustered,and random.

When using SQL Server,developers place explicit locks.

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

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

Which of the following is true about indexes in SQL Server?

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

Stored procedures and triggers in SQL Server may become confused while executing stored procedures and triggers when SQL Server special words such as TRANSACTION appear as table or other names,even if they are enclosed in square brackets [ ].

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

SQL Server tables can be created and modified using ________.

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

Briefly explain the different SQL Server recovery models.

SQL Server built-in system function names start with the @@ symbol.

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