SQL Server 2000 With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data. PESSIMISTIC READ_ONLY SCROLL_LOCK OPTIMISTIC PESSIMISTIC READ_ONLY SCROLL_LOCK OPTIMISTIC 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 Nonclustered indexes are faster than clustered indexes for retrieval. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data. Clustered Secondary Nonclustered Primary Clustered Secondary Nonclustered Primary 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 Locking hints Transaction isolation level Lock level Cursor concurrency setting Locking hints Transaction isolation level Lock level ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 What mode of authentication does SQL Server NOT provide? Both SQL Server and Windows-only security Mixed security Windows-only security SQL Server only security Both SQL Server and Windows-only security Mixed security Windows-only security SQL Server only security ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS