Question 1 :
With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?
Question 2 :
Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?
Question 3 :
What mode of authentication does SQL Server NOT provide?
Question 4 :
The strictest transaction isolation level provided by SQL Server is called:
Question 5 :
SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):
Question 6 :
Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
Question 7 :
Which of the three possible types of triggers does SQL Server support?
Question 8 :
Which of the following is a way to create and modify tables using SQL Server?
Question 9 :
With which type of SQL Server recovery model, is no logging done?
Question 10 :
SQL Server 2000 stored procedures can:
Question 11 :
With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
Question 12 :
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:
Question 13 :
With this type of index, the data are stored in the bottom level of the index and in the same order as that index.
Question 14 :
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?
Question 15 :
With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.
Question 16 :
With which type of SQL Server recovery model are all database changes logged?
Question 17 :
SQL Server automatically creates an index on:
Question 18 :
Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
Question 19 :
SQL Server program code that is executed after an SQL command has been processed is called a(n):
Question 20 :
Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?