Question 1

Microsoft SQL Server 2014 Express Advanced includes:

Accepted Answer

Microsoft SQL Server 2014 Express Advanced includes both SQL Server 2014 Management Studio and SQL Server 2014 Reporting Services, but not Windows Installer 4.5.

Question 2

Logging into the SQL Server 2014 Express DBMS is done using:

Accepted Answer

To log into the SQL Server 2014 Express DBMS, you need to use the Connect to Server dialog box. This dialog box can be accessed from the Object Explorer in SQL Server Management Studio, by right-clicking on the server name and selecting Connect. This dialog box allows you to specify the server type, server name, authentication method, and login credentials required to connect to the SQL Server instance.

Question 3

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

Accepted Answer

SQL statements can be run individually or as part of a script. A script is a group of SQL statements that are executed together as a single unit. This can be useful for automating repetitive tasks, or for executing several related SQL statements as part of a larger operation.

Question 4

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

Accepted Answer

A group of SQL statements is usually saved as a script, which can be executed as a whole. Therefore, the correct choice is C, a script. The other choices - Result, Resultset, Scriptset and Commandset - are not commonly used terms to describe a group of SQL statements.

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.

Accepted Answer

The answer of To start working with SQL Server 2014...

Question 6

SQL Server 2014 Express requires the prior or concurrent installation of:

Accepted Answer

The answer of SQL Server 2014 Express requires the prior...

Question 7

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

Accepted Answer

Clicking the New Query button is a common way to create a new SQL query in various database management software.

Question 8

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

Accepted Answer

SQL Server 2014 Express has full SQL capabilities, including support for advanced features such as in-memory OLTP and columnstore indexes. It is a free, entry-level edition of SQL Server that can be used for small-scale applications or for learning and development purposes.

Question 9

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

Accepted Answer

SQL Server 2014 Express requires the .NET Framework version 3.5 SP1 or later to be installed.

Question 10

SQL query results are displayed:

Accepted Answer

SQL query results are typically displayed in a tabbed Results window in most commonly used SQL environments and tools, such as SQL Server Management Studio, MySQL Workbench, and Oracle SQL Developer. The Results window typically displays the query results in a tabular format, allowing users to easily view, filter, and manipulate the data.

Question 11

A new SQL Server database is created using:

Accepted Answer

The New Database dialog box is specifically designed for creating new SQL Server databases. The other options, such as creating a schema or new object, are not directly related to creating a new database.

Question 12

To run an SQL script or SQL command in SQL Server 2014:

Accepted Answer

The SQL Editor Toolbar is specifically designed for executing SQL scripts and commands in SQL Server. Therefore, clicking the Execute button on the SQL Editor Toolbar is the most appropriate option. The other toolbars mentioned (Browser Toolbar and Query Toolbar) may have some SQL execution capabilities, but they are not specialized for it.

Question 13

SQL query results are displayed in a tabbed Resultset window.

Accepted Answer

SQL query results are typically displayed in a grid or table format within the query editor or results pane, not specifically in a "tabbed Resultset window." The exact display can vary depending on the SQL client or database management tool being used.

Question 14

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

Accepted Answer

This statement is true. The Object Explorer window is where users can view and manage various database objects such as tables, views, procedures, functions, and more in SQL Server Management Studio.

Question 15

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

Accepted Answer

SQL Server 2014 Management Studio is included in SQL Server 2014 Express Advanced.

Question 16

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

Accepted Answer

Users can log into SQL Server 2014 Express using the Connect to Server dialog box which provides options to specify the server name, authentication mode, and login credentials.

Question 17

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

Accepted Answer

The answer of To run an SQL script,click the Execute...

Question 18

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

Accepted Answer

The New Database dialog box is used to create a new SQL Server database.

Question 19

SQL Server 2014 uses DBMS authentication by default.

Accepted Answer

SQL Server 2014 uses Windows Authentication mode by default, not DBMS authentication.

Question 20

SQL Server DBMS objects are displayed:

Accepted Answer

The Object Explorer is the primary tool for browsing and managing SQL Server objects. It displays a hierarchical treeview of server objects, databases, and their constituent parts.

Quiz 9: Getting Started With Microsoft Sql Server 2012