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. 
E) include the word "View" in the view name. 
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. 
E) include the word "View" in the view name.

Question 2

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 3

In SQL Server,locking behavior can be modified by providing locking hints in the WITH parameter of the FROM clause in SELECT statements.

Accepted Answer

A) True 
 B)False

Question 4

Data can be entered directly into a table in Enterprise Manager or via SQL INSERT statements submitted through the Microsoft SQL Server Management Studio.

Accepted Answer

A) True 
 B)False

Question 5

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 6

The SQL Server GUI program is the Enterprise Manager.

Accepted Answer

A) True 
 B)False

Question 7

SQL Server user built-in system functions start with the @@ symbol.

Accepted Answer

A) True 
 B)False

Question 8

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. 
E) All of the above. 
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. 
E) All of the above.

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

The default transaction isolation level for SQL Server is Read Committed.

Accepted Answer

A) True 
 B)False

Question 12

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 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

The recommended SQL Server security is Windows-only security.

Accepted Answer

A) True 
 B)False

Question 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

In SQL Server,an interactive backup makes a copy of the changes that have been made since the last time a backup of the entire database was made.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is not a type of trigger supported by SQL Server?

Accepted Answer

A) BEFORE 
B) INSTEAD OF 
C) CONCURRENT 
D) AFTER 
E) A and C 
A) BEFORE 
B) INSTEAD OF 
C) CONCURRENT 
D) AFTER 
E) A and C

Exam 10: A: Managing Databases With SQL Server 20012

When creating a T-SQL statement,you should:

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,locking behavior can be modified by providing locking hints in the WITH parameter of the FROM clause in SELECT statements.

Data can be entered directly into a table in Enterprise Manager or via SQL INSERT statements submitted through the Microsoft SQL Server Management Studio.

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

The SQL Server GUI program is the Enterprise Manager.

SQL Server user built-in system functions start with the @@ symbol.

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

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

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

The default transaction isolation level for SQL Server is Read Committed.

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?

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

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

The recommended SQL Server security is Windows-only security.

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.

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

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

In SQL Server,an interactive backup makes a copy of the changes that have been made since the last time a backup of the entire database was made.

Which of the following is not a type of trigger supported by SQL Server?

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