Deck 9: Getting Started With Microsoft Sql Server 2012

Question 1

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

Answer 1

D

Question 2

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.

Answer 2

B

Question 3

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

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

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 6

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 7

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

Question 8

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

Question 9

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

Question 10

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.

Question 11

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 12

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 13

SQL query results are displayed in a tabbed Resultset window.

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

SQL Server 2014 uses DBMS authentication by default.

Question 20

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 21

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

Question 22

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 23

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

Question 24

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

Question 25

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

Question 26

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

Question 27

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 28

SQL query results are displayed in a tabbed ________ window.

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

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

Question 34

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

Question 35

SQL Server 2014 Express requires that ________ be installed.

Question 36

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

Question 37

SQL Server 2014 uses ________ authentication by default.

Question 38

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

Question 39

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

Question 40

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