SQL Server 2000 Which of the following is not a factor in determining the concurrency control behavior of SQL Server? Transaction isolation level Cursor concurrency setting Locking hints Lock level Transaction isolation level Cursor concurrency setting Locking hints Lock level ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server supports two kinds of indexes: clustered and nonclustered. False True False True 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 With which type of SQL Server recovery model are all database changes logged? Full recovery Bulk-logged recovery Differential recovery Simple recovery Full recovery Bulk-logged recovery Differential recovery Simple recovery ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 Better security occurs if Windows-only authentication is selected. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 Nonclustered indexes are faster than clustered indexes for retrieval. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS