Sql Server 2000

Take This Test

1)	Choose all options which hold true for denormalization of a database?

2)	Match the relationship types(in column) with their correct way of implementation(in rows).

3)	By default both primary and unique key creates a clustered index on the column.
	True or False
4)	Primary Key allows NULL value in the column.
	True or False
5)	Which is the third state supported by BIT datatype of SQL Server 2000 database beside 1 and 0?

6)	What type of columns can not have default value in a Microsoft Sql Server 2000 database?

7)	ACID stands for _______________

8)	Select default Isolation level of SQL Server 2000.

9)	Match the data concurrency issue(in Column) with their respective definitions(in rows).

10)	Which Isolation level protects from "Dirty Reads", "Non-repeatable Reads " and "Phantom Reads" issues?

11)	CREATE INDEX SampleIndex ON Testtable(ConcernedColumn)
	Which index will be create by this command?
12)	What's the maximum size of a row?

13)	What is the allowed number of columns per select statement in a SQL Server 2000 database?

14)	What should be the maximum size of data stored in a text, ntext or image column of SQL server 2000 database?

15)	Maximum number of columns per foreign key.