Question 1

When viewing a table in the GUI tools table design window in SQL Server,the primary key is indicated by a black arrow.

Accepted Answer

In SQL Server's GUI tools, such as SQL Server Management Studio (SSMS), the primary key is typically indicated by a gold key icon, not a black arrow. The black arrow is used to indicate the sort order of columns in a table or index, not the primary key.

Question 2

SQL Statements can be submitted to SQL Server from the Microsoft SQL Server Management Studio.

Accepted Answer

SQL statements can be submitted to SQL Server from Microsoft SQL Server Management Studio through the query window.

Question 3

To use an SQL Server reserved word as a user identifier,it must be enclosed in square brackets [ ].

Accepted Answer

SQL Server reserved words can be used as user identifiers by enclosing them in square brackets [ ]. This is because SQL Server recognizes the square brackets as a way to escape reserved words and use them as identifiers.

Question 4

SQL Server 2014 provides two ways to create tables-graphically and through SQL code.

Accepted Answer

SQL Server 2014 allows users to create tables using both graphical interface tools such as SQL Server Management Studio and SQL code through SQL Server Management Studio or other SQL tools.

Question 5

The name TRANSACTION is so special to SQL Server that no stored procedures will work on a table with that name.

Accepted Answer

This is true. SQL Server recognizes the name TRANSACTION as a system keyword and therefore no stored procedures will work on a table with that name. It is best practice to avoid using reserved words as table or column names to avoid conflicts with system functionality.

Question 6

SQL Server supports three types of indexes: clustered,unclustered,and random.

Accepted Answer

SQL Server supports two types of indexes: clustered and nonclustered. Random indexes do not exist in SQL Server.

Question 7

In the Microsoft SQL Server Management Studio,the amount to add to the surrogate key value when adding a new row is specified by the increment property.

Accepted Answer

The increment property specifies the amount to add to the surrogate key value when adding a new row in Microsoft SQL Server Management Studio.

Question 8

In an SQL Server clustered index,the data are stored in the bottom level of the index and in the same order as the index.

Accepted Answer

In a clustered index, the data is physically sorted and stored in the same order as the index key. So, the leaf level of the index contains the actual data pages.

Question 9

When viewing the SQL Server list of tables in a database,dbo means "domain base object" and indicates a system table.

Accepted Answer

"dbo" in SQL Server refers to the default schema for a database user and does not necessarily indicate a system table. The prefix "sys" is commonly used to indicate system tables in SQL Server.

Question 10

The Microsoft SQL Server Management Studio Manager can be used to create a new database.

Accepted Answer

The Microsoft SQL Server Management Studio Manager can be used to create a new database.

Question 11

The SQL Server GUI program is the Enterprise Manager.

Accepted Answer

The SQL Server GUI program is actually called SQL Server Management Studio (SSMS), which replaced Enterprise Manager starting from SQL Server 2005.

Question 12

SQL Server automatically creates an index on primary key fields only.

Accepted Answer

SQL Server automatically creates a clustered index on the primary key, unless a clustered index already exists on the table and a non-clustered index is specified or implied for the primary key. However, it does not limit automatic index creation to primary key fields only; indexes can also be explicitly created on other columns as needed.

Question 13

When viewing a table in the GUI tools table design window in SQL Server,the notation that should supply the values for a surrogate key is that the Identity property of that column is set to "Yes."

Accepted Answer

Setting the Identity property to "Yes" means that SQL Server will automatically generate a unique value for that column when a new row is inserted into the table, which is commonly used for surrogate keys.

Question 14

The Microsoft SQL Server Management Studio cannot verify SQL statements until they are executed.

Accepted Answer

Microsoft SQL Server Management Studio (SSMS) can parse and check the syntax of SQL statements before they are executed, allowing users to find errors without running the actual query.

Question 15

Stored procedures and triggers in SQL Server may become confused while executing stored procedures and triggers when SQL Server special words such as TRANSACTION appear as table or other names,even if they are enclosed in square brackets [ ].

Accepted Answer

SQL Server may interpret special words as keywords even when they are enclosed in square brackets, causing confusion during the execution of stored procedures and triggers.

Question 16

The developer can direct SQL Server to create indexes on non-key fields.

Accepted Answer

SQL Server allows developers to specify non-key fields on which indexes can be created to improve query performance.

Question 17

In addition to the standard SQL Server 2014 tools,SQL statements such as CREATE TABLE can now also be executed by using Microsoft's PowerShell.

Accepted Answer

PowerShell is a scripting language used to automate administrative tasks and it can be used to execute SQL statements as well. SQL Server supports PowerShell scripting in addition to its standard tools.

Question 18

In the Microsoft SQL Server Management Studio,the starting value for a field that has been set as an IDENTITY in SQL Server is set in the seed (StartingValue)property.

Accepted Answer

The starting value for an IDENTITY column in SQL Server is set in the seed property, which is a part of the IDENTITY property. This starting value specifies the first value to be used for the column, and it can be set to any integer value.

Question 19

With SQL Server,the preferred way to create database structures is with SQL statements.

Accepted Answer

SQL Server is designed to work with SQL statements for creating database structures. While there are also visual tools available, using SQL statements is the preferred way for many reasons including better control over the process and more flexibility.

Question 20

The SQL Server default when creating a new database is to create two data files and one log file for each database.

Accepted Answer

The SQL Server default when creating a new database is to create one data file (MDF) and one log file (LDF).

Quiz 10: Managing Databases With SQL Server 2014

When viewing a table in the GUI tools table design window in SQL Server,the primary key is indicated by a black arrow.

SQL Statements can be submitted to SQL Server from the Microsoft SQL Server Management Studio.

To use an SQL Server reserved word as a user identifier,it must be enclosed in square brackets [ ].

SQL Server 2014 provides two ways to create tables-graphically and through SQL code.

The name TRANSACTION is so special to SQL Server that no stored procedures will work on a table with that name.

SQL Server supports three types of indexes: clustered,unclustered,and random.

In the Microsoft SQL Server Management Studio,the amount to add to the surrogate key value when adding a new row is specified by the increment property.

In an SQL Server clustered index,the data are stored in the bottom level of the index and in the same order as the index.

When viewing the SQL Server list of tables in a database,dbo means "domain base object" and indicates a system table.

The Microsoft SQL Server Management Studio Manager can be used to create a new database.

The SQL Server GUI program is the Enterprise Manager.

SQL Server automatically creates an index on primary key fields only.

When viewing a table in the GUI tools table design window in SQL Server,the notation that should supply the values for a surrogate key is that the Identity property of that column is set to "Yes."

The Microsoft SQL Server Management Studio cannot verify SQL statements until they are executed.

Stored procedures and triggers in SQL Server may become confused while executing stored procedures and triggers when SQL Server special words such as TRANSACTION appear as table or other names,even if they are enclosed in square brackets [ ].

The developer can direct SQL Server to create indexes on non-key fields.

In addition to the standard SQL Server 2014 tools,SQL statements such as CREATE TABLE can now also be executed by using Microsoft's PowerShell.

In the Microsoft SQL Server Management Studio,the starting value for a field that has been set as an IDENTITY in SQL Server is set in the seed (StartingValue)property.

With SQL Server,the preferred way to create database structures is with SQL statements.

The SQL Server default when creating a new database is to create two data files and one log file for each database.