SQL SERVER 2000 QUIZ

Better security occurs if Windows-only authentication is selected.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is a way to create and modify tables using SQL Server?

Both of the two methods above will work

Use the graphical facilities of SQL Server Enterprise Manager only

Write SQL code using either CREATE or ALTER SQL statements only

Neither of the two methods above will work

TRUE ANSWER : ?
YOUR ANSWER : ?

READ COMMITTED is the default isolation level.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):

INSTEAD OF trigger

BEFORE trigger

AFTER trigger

BEGIN trigger

TRUE ANSWER : ?
YOUR ANSWER : ?

Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?

&

@

#

%

TRUE ANSWER : ?
YOUR ANSWER : ?

With which type of SQL Server recovery model are all database changes logged?

Bulk-logged recovery

Differential recovery

Simple recovery

Full recovery

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server supports INSTEAD OF, AFTER and BEFORE triggers.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

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 : ?

SQL Server program code that is executed after an SQL command has been processed is called a(n):

BEGIN trigger

AFTER trigger

BEFORE trigger

INSTEAD OF trigger

TRUE ANSWER : ?
YOUR ANSWER : ?

↑