Question 1

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

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

The answer of The ________ edition is a free,single-user version...

Question 7

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

Accepted Answer

The answer of Database objects are displayed in the ________...

Question 8

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

Accepted Answer

An SQL Script is a group of SQL statemen

Question 9

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

Accepted Answer

SQL scripts are created in a text editor

Question 10

A new SQL Server database is created using ________.

Accepted Answer

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 
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 Management Studio provides a text editor to create SQL commands,such as creating tables.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

The answer of Users log into SQL Server 2016 Express...

Question 15

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

Accepted Answer

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 
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 16

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.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

SQL Server 2016 has a set of SQL keyword

Question 18

SQL Server 2016 requires that ________ be installed.

Accepted Answer

the .NET F

Question 19

SQL query results are displayed ________.

Accepted Answer

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 
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 20

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

Accepted Answer

A) True 
 B)False

Logging into the SQL Server 2016 Express DBMS is done using ________.

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

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

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

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

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

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

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

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

A new SQL Server database is created using ________.

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

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

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

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

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

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.

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

SQL Server 2016 requires that ________ be installed.

SQL query results are displayed ________.

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

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters

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

Logging into the SQL Server 2016 Express DBMS is done using ________.

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

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

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

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

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

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

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

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

A new SQL Server database is created using ________.

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

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

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

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

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

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.

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

SQL Server 2016 requires that ________ be installed.

SQL query results are displayed ________.

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

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters