Deck 9: Learn how to create a database in SQL Server 2016

Question 1

To start working with SQL Server 2016 in Windows 10,use the command Start | All Apps | Microsoft SQL Server 2016 | Microsoft SQL Server Management Studio.

Answer 1

True

Question 2

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

Answer 2

True

Question 3

SQL Server 2016 uses ________ authentication by default.

Answer 3

Windows

Question 4

SQL Server 2016 uses DBMS authentication by default.

Question 5

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

Question 6

SQL Server 2016 requires that ________ be installed.

Question 7

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

Question 8

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

Question 9

Microsoft .NET Framework 4.6.1 is provided by Windows 10.

Question 10

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 11

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 12

SQL Server 2016 Express requires that the .NET Framework version 3.5 be automatically installed.

Question 13

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

Question 14

Logging into the SQL Server 2016 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

To properly import a table from Microsoft Excel 2016,which of the following steps is not taken?

A) Use the SQL Server Import and Export Wizard to import data into a temporary table
B) Use an SQL Create Table statement to create the actual table
C) Use SQL Server to normalize the table
D) Use an SQL Insert statement to copy data from the temporary table to the actual table
E) Delete the temporary table from the database

Question 16

The ________ edition is a free,single-user version of the Enterprise Edition.

Question 17

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

Question 18

Microsoft SQL Server 2016 Express Advanced includes ________.

A) MySQL Workbench
B) SQL Server 2016 Reporting Services
C) Windows Installer 4.5
D) Oracle Advanced Analytics
E) Maximum database size of 524 Petabytes

Question 19

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

Question 20

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

Question 21

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

Question 22

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

Question 23

SQL query results are displayed in a tabbed Results window.

Question 24

When SQL Server 2016 is installed,the SQL Server 2016 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 2016
E) Either A or B

Question 25

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 26

To run an SQL script or SQL command in SQL Server 2016 ________.

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 27

The name of the SQL Server 2016 ODBC client as it appears in the ODBC Data Source Administrator is ________.

A) SQL Server ODBC Client 2016
B) ODBC Driver 13 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 ________.

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 29

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

Question 30

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

Question 31

SQL query results are displayed in a tabbed ________ window.

Question 32

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

Question 33

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

Question 34

An SQL command to add data into a database is ADD INTO…

Question 35

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

Question 36

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

Question 37

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

Question 38

SQL Server Management Studio provides a text editor to create SQL commands,such as creating tables.

Question 39

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

Question 40

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

Question 41

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

Question 42

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

Question 43

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