SQL SERVER 2000 QUIZ

In SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup?

Transaction Log

Differential backup

None of these

Complete backup

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 2000 stored procedures can:

support BEFORE, INSTEAD OF and AFTER types

never be kept within the database

be stored on the users' computer

be kept within the database and invoked by application programs

TRUE ANSWER : ?
YOUR ANSWER : ?

With this type of index, the data are stored in the bottom level of the index and in the same order as that index.

Primary

Secondary

Clustered

Nonclustered

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

With which type of SQL Server recovery model, is no logging done?

Bulk-logged recovery

Full recovery

Simple recovery

Differential recovery

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Locking hints

Transaction isolation level

Cursor concurrency setting

Lock level

TRUE ANSWER : ?
YOUR ANSWER : ?

What mode of authentication does SQL Server NOT provide?

Mixed security

Windows-only security

Both SQL Server and Windows-only security

SQL Server only security

TRUE ANSWER : ?
YOUR ANSWER : ?

With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.

OPTIMISTIC

READ_ONLY

PESSIMISTIC

SCROLL_LOCK

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

Secondary

Clustered

TRUE ANSWER : ?
YOUR ANSWER : ?

↑