ADVANCED SQL QUIZ

READ COMMITTED is the default isolation level.

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

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

INSTEAD OF trigger

AFTER trigger

BEFORE trigger

BEGIN trigger

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Differential recovery

Bulk-logged recovery

Simple recovery

Full recovery

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

INSTEAD OF trigger

BEFORE trigger

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the three possible types of triggers does SQL Server support?

AFTER only

INSTEAD OF only

INSTEAD OF and AFTER only

BEFORE only

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server automatically creates an index on:

foreign key only

primary keys only

both primary and foreign keys

SQL Server never automatically creates an index

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

'dbo' stands for database object.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑