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-3 section-1

21
There is only one way to create and modify tables in SQL Server. Write SQL code using either the CREATE or ALTER statements.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
22
SQL Server automatically creates an index on all primary and foreign keys.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
23
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.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
24
With SQL Server, parameters and variables in T-SQL start with the "%" sign.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
25
Nonclustered indexes are faster than clustered indexes for retrieval.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
26
SQL Server supports INSTEAD OF, AFTER and BEFORE triggers.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
27
SQL Server supports two kinds of indexes: clustered and nonclustered.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
28
SQL Server indexes are special data structures used to improve performance.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
29
SQL Server supports a language called Transact-SQL (also called T-SQL).
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
30
The .NET languages are the most popular languages for writing stored procedures in SQL Server 2000.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board