Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

New Database

Question 3

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

Accepted Answer

Execute

Question 4

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

Accepted Answer

In SQL Server 2016,new databases are cre

Question 5

When SQL Server 2016 is installed,the SQL Server 2016 ODBC client is ________.

Accepted Answer

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

SQL Server 2016 uses DBMS authentication by default.

Accepted Answer

A) True 
 B)False

Question 7

SQL query results are displayed in a tabbed ________ window.

Accepted Answer

The answer of SQL query results are displayed in a...

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

In SQL Server 2016,SQL queries are creat

Question 11

SQL Server 2016 uses ________ authentication by default.

Accepted Answer

The answer of SQL Server 2016 uses ________ authentication by...

Question 12

Microsoft SQL Server 2016 Express Advanced includes ________.

Accepted Answer

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

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Microsoft .NET Framework 4.6.1 is provided by Windows 10.

Accepted Answer

A) True 
 B)False

Question 16

SQL query results are displayed in a tabbed Results window.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

IntelliSen

Question 18

SQL Server DBMS objects are displayed ________.

Accepted Answer

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

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

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

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

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

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

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

When SQL Server 2016 is installed,the SQL Server 2016 ODBC client is ________.

SQL Server 2016 uses DBMS authentication by default.

SQL query results are displayed in a tabbed ________ window.

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

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

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

SQL Server 2016 uses ________ authentication by default.

Microsoft SQL Server 2016 Express Advanced includes ________.

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

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

Microsoft .NET Framework 4.6.1 is provided by Windows 10.

SQL query results are displayed in a tabbed Results window.

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

SQL Server DBMS objects are displayed ________.

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

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

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

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

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

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

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

When SQL Server 2016 is installed,the SQL Server 2016 ODBC client is ________.

SQL Server 2016 uses DBMS authentication by default.

SQL query results are displayed in a tabbed ________ window.

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

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

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

SQL Server 2016 uses ________ authentication by default.

Microsoft SQL Server 2016 Express Advanced includes ________.

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

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

Microsoft .NET Framework 4.6.1 is provided by Windows 10.

SQL query results are displayed in a tabbed Results window.

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

SQL Server DBMS objects are displayed ________.

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

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

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