Database Concepts, 8e (Kroenke)
Appendix A Getting Started with Microsoft SQL Server 2016
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.
2) Users log into SQL Server 2016 using the Connect to Server dialog box.
3) SQL Server 2016 uses DBMS authentication by default.
4) Database objects are displayed in the Object Explorer window in the SQL Server Management
Studio.
5) A new SQL Server database is created using the New Database dialog box.
6) 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.
7) 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
8) 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
9) Users log into SQL Server 2016 Express using the ________ dialog box.
10) SQL Server 2016 uses ________ authentication by default.
11) Database objects are displayed in the ________ window in the SQL Server Management
Studio.
12) A new SQL Server database is created using the ________ dialog box.
13) Describe how to create a new database in SQL Server 2016 Express.
14) 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
15) SQL Server 2016 Express requires that the .NET Framework version 3.5 be automatically
installed.
16) An important reason for using SQL Server 2016 Express is that it has full SQL capabilities.
17) Microsoft .NET Framework 4.6.1 is provided by Windows 10.
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
19) SQL Server 2016 requires that ________ be installed.
20) The ________ edition is a free, single-user version of the Enterprise Edition.
21) The Microsoft SQL Server 2016 Management Studio is included with Microsoft SQL Server
2016 Express Advanced.
22) 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
23) 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
24) The ODBC Driver 11 for SQL Server is installed ________ when SQL Server 2016 is
installed.
25) The name of the Microsoft SQL Server 2016 ODBC Client as it appears the ODBC Data
Source Administrator is ________.
26) SQL Server Management Studio provides a text editor to create SQL commands, such as
creating tables.
27) An SQL command to add data into a database is ADD INTO…
28) SQL statements can be run individually or as part of a related group of SQL statements
known as a script.
29) To run an SQL script, click the Execute button on the Query Toolbar.
30) To create a new SQL query, click the New Query button.
31) SQL query results are displayed in a tabbed Results window.
32) 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
33) 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
34) 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
35) SQL statements can be run individually or as part of a related group of SQL statements
known as a(n) ________.
36) To run an SQL script, click the ________ button on the SQL Editor Toolbar.
37) Users can click the ________ button to enable or disable the SQL editor windows set of
outlining and auto-completion features.
38) To create a new SQL query, click the ________ button.
39) SQL query results are displayed in a tabbed ________ window.
40) What is an SQL script, and why are SQL scripts useful?
41) Describe how to create and run an SQL script in SQL Server 2016 Express.
42) Describe how to create and run an SQL query in SQL Server 2016 Express.
43) Describe why SQL Server 2016 is sensitive to certain words being used in SQL commands
or scripts, and what to do about it.