Question 1

When recovering a database in SQL Server,it is possible to process the log to a particular point in time or to a transaction mark.

Accepted Answer

A) True 
 B)False

Question 2

Explain SQL Server indexes.

Accepted Answer

The answer of Explain SQL Server indexes....

Question 3

Briefly describe how a developer defines the type of locking behavior to be used with SQL Server.

Accepted Answer

The answer of Briefly describe how a developer defines the...

Question 4

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

A) True 
 B)False

Question 5

SQL Server system function names start with the symbol ________.

Accepted Answer

A) @@ 
B) # 
C) ## 
D) @

Question 6

When you use the Microsoft SQL Server Management Studio to run and rerun a set of SQL Server DBMS commands stored in a text file,the stored procedure must start with CREATE PROCEDURE.

Accepted Answer

A) True 
 B)False

Question 7

A view may not be assigned to a(n)________.

Accepted Answer

A) BEFORE trigger 
B) INSTEAD OF trigger 
C) CONCURRENT trigger 
D) AFTER trigger

Question 8

With SQL Server,a clustered index has the data with,and in the same order as,the bottom level of the index.

Accepted Answer

A) True 
 B)False

Question 9

The default cursor concurrency setting for a keyset cursor in SQL Server is ________.

Accepted Answer

A) Pessimistic 
B) Optimistic 
C) Serializable 
D) Read only

Question 10

SQL Server supports AFTER and INSTEAD OF triggers,but not BEFORE triggers.

Accepted Answer

A) True 
 B)False

Question 11

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

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Briefly explain the process for importing spreadsheet data into a SQL Server table,and indicate some of the pitfalls or potential problems.

Accepted Answer

The answer of Briefly explain the process for importing spreadsheet...

Question 14

SQL statements can be passed to SQL Server using the ________.

Accepted Answer

A) Enterprise Manager 
B) Query Analyzer 
C) Microsoft SQL Server Management Studio 
D) Both A and B are correct

Question 15

In SQL Server,locking behavior can be modified by providing locking hints in the WITH parameter of the FROM clause in SELECT statements.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is the default transaction isolation level for SQL Server?

Accepted Answer

A) Repeatable Read 
B) Read Committed 
C) Serializable 
D) Read Uncommitted

Question 17

The language available in SQL Server that adds programming constructs to the SQL language is known as ________.

Accepted Answer

A) PL/SQL 
B) C++ 
C) INTERACT-SQL 
D) TRANSACT-SQL

Question 18

In SQL Server,a differential backup makes a copy of the entire database.

Accepted Answer

A) True 
 B)False

Question 19

Which type(s)of index in SQL Server has/have a bottom level that does not contain data but has pointers to the data?

Accepted Answer

A) Clustered 
B) Nonclustered 
C) Unique 
D) Both A and B are correct

Question 20

Data can be entered directly into a table in Enterprise Manager or via SQL INSERT statements submitted through the Microsoft SQL Server Management Studio.

Accepted Answer

A) True 
 B)False

Exam 10: Managing Databases With SQL Server 2014

When recovering a database in SQL Server,it is possible to process the log to a particular point in time or to a transaction mark.

Explain SQL Server indexes.

Briefly describe how a developer defines the type of locking behavior to be used with SQL Server.

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.

SQL Server system function names start with the symbol ________.

When you use the Microsoft SQL Server Management Studio to run and rerun a set of SQL Server DBMS commands stored in a text file,the stored procedure must start with CREATE PROCEDURE.

A view may not be assigned to a(n) ________.

With SQL Server,a clustered index has the data with,and in the same order as,the bottom level of the index.

The default cursor concurrency setting for a keyset cursor in SQL Server is ________.

SQL Server supports AFTER and INSTEAD OF triggers,but not BEFORE triggers.

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."

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

Briefly explain the process for importing spreadsheet data into a SQL Server table,and indicate some of the pitfalls or potential problems.

SQL statements can be passed to SQL Server using the ________.

In SQL Server,locking behavior can be modified by providing locking hints in the WITH parameter of the FROM clause in SELECT statements.

Which of the following is the default transaction isolation level for SQL Server?

The language available in SQL Server that adds programming constructs to the SQL language is known as ________.

In SQL Server,a differential backup makes a copy of the entire database.

Which type(s) of index in SQL Server has/have a bottom level that does not contain data but has pointers to the data?

Data can be entered directly into a table in Enterprise Manager or via SQL INSERT statements submitted through the Microsoft SQL Server Management Studio.