SQL Server 2000 READ COMMITTED is the default isolation level. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 By default, SQL Server will create one data file and one log file for each newly created database. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server program code that is executed after an SQL command has been processed is called a(n): AFTER trigger BEGIN trigger BEFORE trigger INSTEAD OF trigger AFTER trigger BEGIN trigger BEFORE trigger INSTEAD OF trigger ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 The .NET languages are the most popular languages for writing stored procedures in SQL Server 2000. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 With SQL Server pessimistic locking, no lock is obtained until the user updates the data. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 With this type of index, the data are stored in the bottom level of the index and in the same order as that index. Nonclustered Clustered Primary Secondary Nonclustered Clustered Primary Secondary ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS