XML AND ADO.NET QUIZ

SQL Server supports INSTEAD OF, AFTER and BEFORE triggers.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Bulk-logged recovery

Simple recovery

Differential recovery

Full recovery

TRUE ANSWER : ?
YOUR ANSWER : ?

'dbo' stands for database object.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Nonclustered indexes are faster than clustered indexes for retrieval.

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

AFTER trigger

BEGIN trigger

BEFORE trigger

INSTEAD OF trigger

TRUE ANSWER : ?
YOUR ANSWER : ?

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

BEFORE only

INSTEAD OF and AFTER only

INSTEAD OF only

AFTER only

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server 2000 stored procedures can:

never be kept within the database

be stored on the users' computer

be kept within the database and invoked by application programs

support BEFORE, INSTEAD OF and AFTER types

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server automatically creates an index on:

foreign key only

SQL Server never automatically creates an index

both primary and foreign keys

primary keys only

TRUE ANSWER : ?
YOUR ANSWER : ?

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

↑