Question 1

With SQL Server,only one clustered index is allowed per table.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

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 Excel 
D) PL/SQL 
A) Internet Explorer 
B) Microsoft PowerShell 
C) Microsoft Excel 
D) PL/SQL

Question 5

One means of processing an SQL Server database is to create application code in a programming language and invoke SQL Server DBMS commands from that program.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is a type of cursor concurrency that causes SQL Server to place an update lock on a row when the row is read?

Accepted Answer

A) SCROLL_LOCK 
B) Optimistic 
C) Serializable 
D) Read only 
A) SCROLL_LOCK 
B) Optimistic 
C) Serializable 
D) Read only

Question 7

Which of the following is not a lock granularity supported by SQL Server?

Accepted Answer

A) Row 
B) Attribute 
C) Table 
D) Page 
A) Row 
B) Attribute 
C) Table 
D) Page

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

In SQL Server,a transaction log 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 11

The SQL Server GUI interface database management program is the ________.

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 12

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) Both A and B are correct 
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) Both A and B are correct

Question 13

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

Accepted Answer

A) The spreadsheet data must already be normalized in order to be imported. 
B) There may be problems importing Excel 2013 data and we may need to install Excel 2007 compatibility software. 
C) The Import and Export Wizard sometimes creates blank rows at the end of the imported table. 
D) Both B and C are correct. 
A) The spreadsheet data must already be normalized in order to be imported. 
B) There may be problems importing Excel 2013 data and we may need to install Excel 2007 compatibility software. 
C) The Import and Export Wizard sometimes creates blank rows at the end of the imported table. 
D) Both B and C are correct.

Question 14

SQL Server logins can be based on Windows Operating System security or SQL server-specific security.

Accepted Answer

A) True 
 B)False

Question 15

Which type of index in SQL Server is faster for data retrieval?

Accepted Answer

A) Clustered 
B) Nonclustered 
C) Baseline 
D) There is no advantage to any particular index for data retrieval,only for data updating. 
A) Clustered 
B) Nonclustered 
C) Baseline 
D) There is no advantage to any particular index for data retrieval,only for data updating.

Question 16

Discuss the Microsoft PowerShell utility.

Accepted Answer

Microsoft Windows PowerShell is a very p

Question 17

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 18

The default cursor concurrency for a dynamic cursor in SQL Server is optimistic.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is true of clustered indexes?

Accepted Answer

A) They are normally slower than nonclustered indexes for retrieving data. 
B) Only one is allowed per table. 
C) They are normally slower than nonclustered indexes for updating data. 
D) They do not have data in the bottom level. 
A) They are normally slower than nonclustered indexes for retrieving data. 
B) Only one is allowed per table. 
C) They are normally slower than nonclustered indexes for updating data. 
D) They do not have data in the bottom level.

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 10: Managing Databases With SQL Server 2014

With SQL Server,only one clustered index is allowed per table.

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

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.

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

One means of processing an SQL Server database is to create application code in a programming language and invoke SQL Server DBMS commands from that program.

Which of the following is a type of cursor concurrency that causes SQL Server to place an update lock on a row when the row is read?

Which of the following is not a lock granularity supported by SQL Server?

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

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

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

The SQL Server GUI interface database management program is the ________.

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

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

SQL Server logins can be based on Windows Operating System security or SQL server-specific security.

Which type of index in SQL Server is faster for data retrieval?

Discuss the Microsoft PowerShell utility.

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

The default cursor concurrency for a dynamic cursor in SQL Server is optimistic.

Which of the following is true of clustered indexes?

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

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