Question 1

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

Question 2

Which of the following are ways of processing an SQL Server database?

Accepted Answer

A) From an application written in a programming language such as C# or Visual Basic 
B) From text files processed by the SQL Server Query Analyzer 
C) From invoked SQL Server stored procedures 
D) From invoked SQL Server triggers 
E) All of the above 
A) From an application written in a programming language such as C# or Visual Basic 
B) From text files processed by the SQL Server Query Analyzer 
C) From invoked SQL Server stored procedures 
D) From invoked SQL Server triggers 
E) All of the above

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

The Microsoft SQL Server Management Studio cannot verify SQL statements until they are executed.

Accepted Answer

A) True 
 B)False

Question 6

With SQL Server,the preferred way to create database structures is with SQL statements.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

SQL statements can be passed to SQL Server using the ________.

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 10

The SQL Server default when creating a new database is to create two data files and one log file for each database.

Accepted Answer

A) True 
 B)False

Question 11

Using only SQL Server tools,you can enter data into a table by ________.

Accepted Answer

A) entering it into a table grid in the Microsoft SQL Server Management Studio 
B) using INSERT statements through the Microsoft SQL Server Management Studio 
C) using an SQL Server form 
D) A or B 
E) A,B,or C 
A) entering it into a table grid in the Microsoft SQL Server Management Studio 
B) using INSERT statements through the Microsoft SQL Server Management Studio 
C) using an SQL Server form 
D) A or B 
E) A,B,or C

Question 12

With SQL Server,a nonclustered index does not contain data but has pointers to the data.

Accepted Answer

A) True 
 B)False

Question 13

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

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 16

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 
E) DBMS backup 
A) Full backup 
B) Transaction backup 
C) Database backup 
D) Complete backup 
E) DBMS backup

Question 17

Explain SQL Server indexes.

Accepted Answer

There are two types of SQL Server indexe

Question 18

SQL Server system functions start with the symbol ________.

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

When creating SQL Server tables in a database,SQL statements can now also be submitted by using ________.

Accepted Answer

A) Internet Explorer 
B) Microsoft PowerShell 
C) Microsoft Word 
D) Microsoft Excel 
E) PL/SQL 
A) Internet Explorer 
B) Microsoft PowerShell 
C) Microsoft Word 
D) Microsoft Excel 
E) PL/SQL

Exam 10: A: Managing Databases With SQL Server 20012

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

Which of the following are ways of processing an SQL Server database?

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

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

The Microsoft SQL Server Management Studio cannot verify SQL statements until they are executed.

With SQL Server,the preferred way to create database structures is with SQL statements.

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

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

SQL statements can be passed to SQL Server using the ________.

The SQL Server default when creating a new database is to create two data files and one log file for each database.

Using only SQL Server tools,you can enter data into a table by ________.

With SQL Server,a nonclustered index does not contain data but has pointers to the data.

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.

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

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

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

Explain SQL Server indexes.

SQL Server system functions start with the symbol ________.

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

When creating SQL Server tables in a database,SQL statements can now also be submitted by using ________.

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