Deck 9: Getting Started With Microsoft Sql Server 2014 Express Edition

Question 1

SQL query results are displayed:

A)in a tabbed Resultset window.
B)in a tabbed Results window.
C)in a tabbed Document window.
D)in a tabbed Messages window.
E)in a tabbed Finished window.

Answer 1

B

Question 2

The Microsoft SQL Server 2014 Management Studio is included with Microsoft SQL Server 2014 Express Advanced.

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

A)Result.
B)Resultset.
C)Script.
D)Scriptset.
E)Commandset.

Question 5

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

Question 6

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

Question 7

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

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 8

SQL query results are displayed in a tabbed Resultset window.

Question 9

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

Question 10

Users log into SQL Server 2014 Express using the Connect to Server dialog box.

Question 11

Microsoft SQL Server 2014 Express Advanced includes:

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 12

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.

Question 13

SQL Server DBMS objects are displayed:

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

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

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 15

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

Question 16

SQL Server 2014 uses DBMS authentication by default.

Question 17

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

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 18

To create a new SQL query,click the New Query button.

Question 19

A new SQL Server database is created using:

A)the New Database dialog box.
B)the Create Database command.
C)the Create New Schema dialog box.
D)the Create Schema command.
E)the New Object dialog box.

Question 20

To run an SQL script,click the Execute button on the Query Toolbar.

Question 21

To run an SQL script,click the ________ button on the Query Toolbar.

Question 22

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

Question 23

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

Question 24

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

Question 25

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

Question 26

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

Question 27

Describe how to create and run an SQL script in SQL Server 2014 Express.

Question 28

SQL Server 2014 uses ________ authentication by default.

Question 29

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

Question 30

Describe how to create and run an SQL query in SQL Server 2014 Express.

Question 31

SQL query results are displayed in a tabbed ________ window.

Question 32

Describe why SQL Server 2014 is sensitive to certain words being used in SQL commands or scripts,and what to do about it.

Question 33

The name of the SQL Server 2014 ODBC client as it appears in the ODBC Data Source Administrator is:

A)SQL Server ODBC Client 2014.
B)ODBC Driver 11 for SQL Server.
C)SQL Server Native Client 2008.
D)SQL Server Native Client 2008 R2.
E)SQL Server Native Client 11.0.

Question 34

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

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 35

What is an SQL script,and why are SQL scripts useful?

Question 36

SQL statements can be run individually or as part of a related group of SQL statements known as a(n)________.

Question 37

Users log into SQL Server 2014 Express using the ________ dialog box.

Question 38

SQL Server 2014 Express requires that ________ be installed.

Question 39

Users can click the ________ button to enable or disable the SQL editor windows set of outlining and auto-completion features.

Question 40

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