SQL SERVER 2000 QUIZ

Which of the following is not a factor in determining the concurrency control behavior of SQL Server?

Transaction isolation level

Cursor concurrency setting

Locking hints

Lock level

TRUE ANSWER : ?
YOUR ANSWER : ?

What mode of authentication does SQL Server NOT provide?

Both SQL Server and Windows-only security

Mixed security

SQL Server only security

Windows-only security

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server 2000 stored procedures can:

be kept within the database and invoked by application programs

be stored on the users' computer

support BEFORE, INSTEAD OF and AFTER types

never be kept within the database

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server automatically creates an index on all primary and foreign keys.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.

Nonclustered

Primary

Clustered

Secondary

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?

READ UNCOMMITTED

REPEATABLE READ

SERIALIZABLE

READ COMMITTED

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server supports a language called Transact-SQL (also called T-SQL).

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The .NET languages are the most popular languages for writing stored procedures in SQL Server 2000.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server automatically creates an index on:

both primary and foreign keys

SQL Server never automatically creates an index

primary keys only

foreign key only

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server supports two kinds of indexes: clustered and nonclustered.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑