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

31
READ COMMITTED is the default isolation level.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
32
A differential backup makes a copy of the entire database.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
33
SQL Server supports three recovery modes: simple, full and Bulk.
Discuss
Answer & Solution
Answer: Option A
Solution:

SQL Server provides three different recovery models that allow you to specify the way SQL Server manages log files and prepares your enterprise for a disaster. Each of these models represents a different approach to balancing the tradeoff between conserving disk space and providing for granular disaster recovery options.

The three disaster recovery models offered by SQL Server are:
1. Simple Recovery Model
2. Full Recovery Model
3. Bulk-logged Recovery Model

34
SERIALIZABLE is the strictest isolation level.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
35
With SQL Server pessimistic locking, no lock is obtained until the user updates the data.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
36
Better security occurs if Windows-only authentication is selected.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
37
SQL Server AFTER Triggers may be assigned views.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
38
'dbo' stands for database object.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
39
With SQL Server optimistic locking, an update lock is placed on the row when the row is read.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
40
By default, SQL Server will create one data file and one log file for each newly created database.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board