SQL Server 2000 SQL Server supports three recovery modes: simple, full and Bulk. True False True False 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 Nonclustered indexes are faster than clustered indexes for retrieval. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 With which type of SQL Server recovery model are all database changes logged except those that cause large log entries? Bulk-logged recovery Full recovery Simple recovery Differential recovery Bulk-logged recovery Full recovery Simple recovery Differential recovery ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server automatically creates an index on: both primary and foreign keys primary keys only SQL Server never automatically creates an index foreign key only both primary and foreign keys primary keys only SQL Server never automatically creates an index foreign key only ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS