Top

SQL Server 2000

11.

SQL Server program code that is executed after an SQL command has been processed is called a(n):

Answer: C

No answer description available for this question.

Enter details here

Answer: D

No answer description available for this question.

Enter details here

13.

Which of the three possible types of triggers does SQL Server support?

Answer: D

No answer description available for this question.

Enter details here

14.

In SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup?

Answer: C

No answer description available for this question. 

Enter details here

15.

With this type of index, the data are stored in the bottom level of the index and in the same order as that index.

Answer: B

No answer description available for this question.

Enter details here

16.

Which of the following is not a factor in determining the concurrency control behavior of SQL Server?

Answer: A

No answer description available for this question.

Enter details here

17.

An SQL Server reserved word must be placed in brackets. If the word is not in brackets, SQL Server will try to interpret it as the name of one of its special words.

Answer: A

No answer description available for this question.

Enter details here

18.

With which type of SQL Server recovery model are all database changes logged?

Answer: B

No answer description available for this question. 

Enter details here

19.

Better security occurs if Windows-only authentication is selected.

Answer: A

No answer description available for this question.

Enter details here

20.

An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:

Answer: C

No answer description available for this question.

Enter details here

Loading…
Tags: SQL Server 2000 Questions and Answers || SQL Server 2000 MCQ Questions and Answers || SQL Server 2000 GK Questions and Answers || SQL Server 2000 GK MCQ Questions || SQL Server 2000 Multiple Choice Questions and Answers || SQL Server 2000 GK || GK on SQL Server 2000 || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database