SQL SERVER 2000 QUIZ

What mode of authentication does SQL Server NOT provide?

Mixed security

SQL Server only security

Windows-only security

Both SQL Server and Windows-only security

TRUE ANSWER : ?
YOUR ANSWER : ?

An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:

Visual Basic

V

NET

TRANSACT SQL

COBOL

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

With SQL Server pessimistic locking, no lock is obtained until the user updates the data.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

SERIALIZABLE is the strictest isolation level.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

OPTIMISTIC

PESSIMISTIC

SCROLL_LOCK

READ_ONLY

TRUE ANSWER : ?
YOUR ANSWER : ?

READ COMMITTED is the default isolation level.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A differential backup makes a copy of the entire database.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

With SQL Server, parameters and variables in T-SQL start with the "%" sign.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑