SQL Server 2000 What mode of authentication does SQL Server NOT provide? Windows-only security Both SQL Server and Windows-only security SQL Server only security Mixed security Windows-only security Both SQL Server and Windows-only security SQL Server only security Mixed security ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 Better security occurs if Windows-only authentication is selected. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 With which type of SQL Server recovery model, is no logging done? Bulk-logged recovery Differential recovery Full recovery Simple recovery Bulk-logged recovery Differential recovery Full recovery Simple recovery ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 Which of the following is not a factor in determining the concurrency control behavior of SQL Server? Cursor concurrency setting Lock level Locking hints Transaction isolation level Cursor concurrency setting Lock level Locking hints Transaction isolation level ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 The .NET languages are the most popular languages for writing stored procedures in SQL Server 2000. 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
EXAMIANS