SQL Server 2000 SQL Server supports three recovery modes: simple, full and Bulk. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server AFTER Triggers may be assigned views. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 Which type of SQL Server cursor concurrency places an update lock on a row when the row is read? READ_ONLY SCROLL_LOCK READCOMMITTED OPTIMISTIC READ_ONLY SCROLL_LOCK READCOMMITTED OPTIMISTIC 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, is no logging done? Bulk-logged recovery Simple recovery Differential recovery Full recovery Bulk-logged recovery Simple recovery Differential recovery Full recovery ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server supports two kinds of indexes: clustered and nonclustered. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS