Exam 10: Managing Databases With SQL Server 2008 R2

Explore all topics

One means of processing an SQL Server database is to create application code in a programming language and invoke SQL Server DBMS commands from that program.

(True/False)

4.7/5

(34)

Question 41

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

(Multiple Choice)

4.8/5

(39)

Question 42

SQL Server user built-in system functions start with the @@ symbol.

(True/False)

4.9/5

(32)

Question 43

Which of the following is generally used to create a new database?

(Multiple Choice)

4.8/5

(29)

Question 44

In SQL Server,the full recovery model creates a log for every change to the database.

(True/False)

4.8/5

(34)

Question 45

Which of the following is a type of cursor concurrency that causes SQL Server to place an update lock on a row when the row is read?

(Multiple Choice)

4.8/5

(38)

Question 46

Which type of index in SQL Server is faster for data retrieval?

(Multiple Choice)

4.8/5

(35)

Question 47

Which of the following is known to be true if the command EXEC abcCust @Cost = 5 is used to invoke a stored procedure in the Microsoft SQL Server Management Studio?

(Multiple Choice)

4.9/5

(35)

Question 48

Using only SQL Server tools,you can enter data into a table by ________.

(Multiple Choice)

4.8/5

(29)

Question 49

In SQL Server,SCROLL_LOCK is a version of pessimistic locking.

(True/False)

4.7/5

(40)

Question 50

SQL Server AFTER triggers may be assigned to either tables or views.

(True/False)

5.0/5

(36)

Question 51

Describe the database files that are automatically created when a new database is created in SQL Server.

(Essay)

4.9/5

(37)

Question 52

Which of the following is not a lock granularity supported by SQL Server?

(Multiple Choice)

4.8/5

(34)

Question 53

When reviewing a table in the SQL Server GUI tools,which property should be set to "Yes" to indicate that the column is a surrogate key for which SQL Server should automatically supply values?

(Multiple Choice)

4.9/5

(31)

Question 54

In SQL Server,it is not possible to make dirty reads.

(True/False)

4.9/5

(43)

Question 55

When creating SQL Server tables in a database,SQL statements can now also be submitted by using ________.

(Multiple Choice)

4.9/5

(35)

Question 56

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

(Multiple Choice)

4.7/5

(35)

Question 57

Database views can only be created in SQL Server through the use of SQL commands.

(True/False)

4.9/5

(36)

Question 58

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

(True/False)

4.8/5

(32)

Question 59

The default transaction isolation level for SQL Server is Read Committed.

(True/False)

4.8/5

(39)

Question 60

Showing 41 - 60 of 100

Exam 10: Managing Databases With SQL Server 2008 R2

One means of processing an SQL Server database is to create application code in a programming language and invoke SQL Server DBMS commands from that program.

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

SQL Server user built-in system functions start with the @@ symbol.

Which of the following is generally used to create a new database?

In SQL Server,the full recovery model creates a log for every change to the database.

Which of the following is a type of cursor concurrency that causes SQL Server to place an update lock on a row when the row is read?

Which type of index in SQL Server is faster for data retrieval?

Which of the following is known to be true if the command EXEC abcCust @Cost = 5 is used to invoke a stored procedure in the Microsoft SQL Server Management Studio?

Using only SQL Server tools,you can enter data into a table by ________.

In SQL Server,SCROLL_LOCK is a version of pessimistic locking.

SQL Server AFTER triggers may be assigned to either tables or views.

Describe the database files that are automatically created when a new database is created in SQL Server.

Which of the following is not a lock granularity supported by SQL Server?

When reviewing a table in the SQL Server GUI tools,which property should be set to "Yes" to indicate that the column is a surrogate key for which SQL Server should automatically supply values?

In SQL Server,it is not possible to make dirty reads.

When creating SQL Server tables in a database,SQL statements can now also be submitted by using ________.

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

Database views can only be created in SQL Server through the use of SQL commands.

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

The default transaction isolation level for SQL Server is Read Committed.

Introduction

Introduction to Structured Query Language SQL

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

SQL for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters