SQL Server automatically creates an index on:
Answer: C
No answer description available for this question.
Enter details here
Which of the following is a way to create and modify tables using SQL Server?
Answer: C
No answer description available for this question.
Enter details here
With SQL Server optimistic locking, an update lock is placed on the row when the row is read.
Answer: B
No answer description available for this question.
Enter details here
With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data
Answer: A
No answer description available for this question.
Enter details here
The .NET languages are the most popular languages for writing stored procedures in SQL Server 2000.
Answer: B
No answer description available for this question.
Enter details here
With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
Answer: C
No answer description available for this question.
Enter details here
SQL Server indexes are special data structures used to improve performance.
Answer: A
No answer description available for this question.
Enter details here
A differential backup makes a copy of the entire database.
Answer: B
No answer description available for this question.
Enter details here
SQL Server 2000 stored procedures can:
Answer: B
No answer description available for this question.
Enter details here
With SQL Server pessimistic locking, no lock is obtained until the user updates the data.
Answer: B
No answer description available for this question.
Enter details here