Question 1

Microsoft SQL Server 2014 Express Advanced includes:

Accepted Answer

A)  SQL Server 2014 Management Studio. 
B)  SQL Server 2014 Reporting Services. 
C)  Windows Installer 4.5. 
D)  Both A and B 
E)  All of the above 
A)  SQL Server 2014 Management Studio. 
B)  SQL Server 2014 Reporting Services. 
C)  Windows Installer 4.5. 
D)  Both A and B 
E)  All of the above

Question 2

Logging into the SQL Server 2014 Express DBMS is done using:

Accepted Answer

A)  the Connect to Server command. 
B)  the Connect to Server dialog box. 
C)  the Connect to SQL Server Instance command. 
D)  the Connect to SQL Server Instance dialog box. 
E)  None of the above is correct. 
A)  the Connect to Server command. 
B)  the Connect to Server dialog box. 
C)  the Connect to SQL Server Instance command. 
D)  the Connect to SQL Server Instance dialog box. 
E)  None of the above is correct.

Question 3

Describe how to create a new database in SQL Server 2014 Express.

Accepted Answer

In SQL Server 2014,new databases are cre

Question 4

The ODBC Driver 11 for SQL Server is installed ________ when SQL Server 2014 is installed.

Accepted Answer

The answer of The ODBC Driver 11 for SQL Server...

Question 5

A new SQL Server database is created using the ________ dialog box.

Accepted Answer

The answer of A new SQL Server database is created...

Question 6

SQL Server 2014 uses DBMS authentication by default.

Accepted Answer

A) True 
 B)False

Question 7

An important reason for using SQL Server 2014 Express is that it has ________.

Accepted Answer

full SQL c

Question 8

To run an SQL script or SQL command in SQL Server 2014:

Accepted Answer

A)  click the Execute button on the SQL Editor Toolbar. 
B)  click the Execute button on the Browser Toolbar. 
C)  click the Run button on the Query Toolbar. 
D)  click the Run button on the Browser Toolbar. 
E)  click the Results button on the Query Toolbar. 
A)  click the Execute button on the SQL Editor Toolbar. 
B)  click the Execute button on the Browser Toolbar. 
C)  click the Run button on the Query Toolbar. 
D)  click the Run button on the Browser Toolbar. 
E)  click the Results button on the Query Toolbar.

Question 9

The name of the Microsoft SQL Server 2014 ODBC Client as it appears the ODBC Data Source Administrator is ________.

Accepted Answer

ODBC Drive

Question 10

To create a new SQL query,click the ________ button.

Accepted Answer

The answer of To create a new SQL query,click the...

Question 11

To start working with SQL Server 2014 Express in Windows 8.1,use the command Start | All Programs | Microsoft SQL Server 2014 | SQL Server management Studio Express.

Accepted Answer

A) True 
 B)False

Question 12

When SQL Server 2014 is installed,the SQL Server 2014 ODBC client is:

Accepted Answer

A)  installed automatically as part of the installation. 
B)  installed manually as a separate part of the installation process. 
C)  not installed, and must be downloaded and installed manually. 
D)  not installed because there is no ODBC client for SQL Server 2014. 
E)  Either A or B 
A)  installed automatically as part of the installation. 
B)  installed manually as a separate part of the installation process. 
C)  not installed, and must be downloaded and installed manually. 
D)  not installed because there is no ODBC client for SQL Server 2014. 
E)  Either A or B

Question 13

SQL Server DBMS objects are displayed:

Accepted Answer

A)  in the Navigation Pane. 
B)  in the Object Explorer. 
C)  in the tabbed database window. 
D)  in the tabbed document window. 
E)  in the command tab. 
A)  in the Navigation Pane. 
B)  in the Object Explorer. 
C)  in the tabbed database window. 
D)  in the tabbed document window. 
E)  in the command tab.

Question 14

SQL Server 2014 Express requires that ________ be installed.

Accepted Answer

the .NET F

Question 15

SQL query results are displayed in a tabbed Resultset window.

Accepted Answer

A) True 
 B)False

Question 16

SQL Server 2014 Express requires the prior or concurrent installation of:

Accepted Answer

A)  the .NET Framework version 2.0. 
B)  the .NET Framework version 3.0. 
C)  the .NET Framework version 4.0. 
D)  the .NET Framework version 4.5.1. 
E)  None of the above - the .NET Framework is not required. 
A)  the .NET Framework version 2.0. 
B)  the .NET Framework version 3.0. 
C)  the .NET Framework version 4.0. 
D)  the .NET Framework version 4.5.1. 
E)  None of the above - the .NET Framework is not required.

Question 17

Database objects are displayed in the Object Explorer window in the SQL Server Management Studio.

Accepted Answer

A) True 
 B)False

Question 18

An important reason for using SQL Server 2014 Express is that it has full SQL capabilities.

Accepted Answer

A) True 
 B)False

Question 19

SQL Server 2014 Express requires that the .NET Framework version 2.0 be installed.

Accepted Answer

A) True 
 B)False

Question 20

SQL statements can be run individually or as part of a related group of SQL statements known as a script.

Accepted Answer

A) True 
 B)False

Microsoft SQL Server 2014 Express Advanced includes:

Logging into the SQL Server 2014 Express DBMS is done using:

Describe how to create a new database in SQL Server 2014 Express.

The ODBC Driver 11 for SQL Server is installed ________ when SQL Server 2014 is installed.

A new SQL Server database is created using the ________ dialog box.

SQL Server 2014 uses DBMS authentication by default.

An important reason for using SQL Server 2014 Express is that it has ________.

To run an SQL script or SQL command in SQL Server 2014:

The name of the Microsoft SQL Server 2014 ODBC Client as it appears the ODBC Data Source Administrator is ________.

To create a new SQL query,click the ________ button.

To start working with SQL Server 2014 Express in Windows 8.1,use the command Start | All Programs | Microsoft SQL Server 2014 | SQL Server management Studio Express.

When SQL Server 2014 is installed,the SQL Server 2014 ODBC client is:

SQL Server DBMS objects are displayed:

SQL Server 2014 Express requires that ________ be installed.

SQL query results are displayed in a tabbed Resultset window.

SQL Server 2014 Express requires the prior or concurrent installation of:

Database objects are displayed in the Object Explorer window in the SQL Server Management Studio.

An important reason for using SQL Server 2014 Express is that it has full SQL capabilities.

SQL Server 2014 Express requires that the .NET Framework version 2.0 be installed.

SQL statements can be run individually or as part of a related group of SQL statements known as a script.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters

Exam 9: Getting Started With Microsoft Sql Server 2012

Microsoft SQL Server 2014 Express Advanced includes:

Logging into the SQL Server 2014 Express DBMS is done using:

Describe how to create a new database in SQL Server 2014 Express.

The ODBC Driver 11 for SQL Server is installed ________ when SQL Server 2014 is installed.

A new SQL Server database is created using the ________ dialog box.

SQL Server 2014 uses DBMS authentication by default.

An important reason for using SQL Server 2014 Express is that it has ________.

To run an SQL script or SQL command in SQL Server 2014:

The name of the Microsoft SQL Server 2014 ODBC Client as it appears the ODBC Data Source Administrator is ________.

To create a new SQL query,click the ________ button.

To start working with SQL Server 2014 Express in Windows 8.1,use the command Start | All Programs | Microsoft SQL Server 2014 | SQL Server management Studio Express.

When SQL Server 2014 is installed,the SQL Server 2014 ODBC client is:

SQL Server DBMS objects are displayed:

SQL Server 2014 Express requires that ________ be installed.

SQL query results are displayed in a tabbed Resultset window.

SQL Server 2014 Express requires the prior or concurrent installation of:

Database objects are displayed in the Object Explorer window in the SQL Server Management Studio.

An important reason for using SQL Server 2014 Express is that it has full SQL capabilities.

SQL Server 2014 Express requires that the .NET Framework version 2.0 be installed.

SQL statements can be run individually or as part of a related group of SQL statements known as a script.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters