ExamVeda
Login
Home

SQL Server 2000 - Database MCQ Questions and answers- Technical Aptitude

SQL Server 2000(Database) mcq questions and answers with easy and logical explanations for various competitive examination, interview and entrance test. Database Mcq question are important for technical exam and interview. Page-2 section-1

11
With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
Discuss
Answer & Solution
Answer: Option C
No explanation is given for this question. Let's Discuss on Board
12
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:
Discuss
Answer & Solution
Answer: Option C
No explanation is given for this question. Let's Discuss on Board
13
With this type of index, the data are stored in the bottom level of the index and in the same order as that index.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
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?
Discuss
Answer & Solution
Answer: Option C
No explanation is given for this question. Let's Discuss on Board
15
With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
16
With which type of SQL Server recovery model are all database changes logged?
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
17
SQL Server automatically creates an index on:
Discuss
Answer & Solution
Answer: Option C
No explanation is given for this question. Let's Discuss on Board
18
Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
19
SQL Server program code that is executed after an SQL command has been processed is called a(n):
Discuss
Answer & Solution
Answer: Option C
No explanation is given for this question. Let's Discuss on Board
20
Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board