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

Home / Database / SQL Server 2000

31.
READ COMMITTED is the default isolation level.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

32.
A differential backup makes a copy of the entire database.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

33.
SQL Server supports three recovery modes: simple, full and Bulk.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

34.
SERIALIZABLE is the strictest isolation level.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

35.
With SQL Server pessimistic locking, no lock is obtained until the user updates the data.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

36.
Better security occurs if Windows-only authentication is selected.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

37.
SQL Server AFTER Triggers may be assigned views.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

38.
'dbo' stands for database object.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

39.
With SQL Server optimistic locking, an update lock is placed on the row when the row is read.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

40.
By default, SQL Server will create one data file and one log file for each newly created database.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

1 2 3 4