SQL Server Training | Tutorials | How to's

Question 1 : Which query hint will force query to execute on single CPU?

1. MAXDOP
2. SINCPU
3. CPU = 1
4. CPU(1)

Question 2 : How many new collation were introduced in SQL Server 2008?

1. 20
2. 18
3. 80
4. 10

Question 3 : Which of the engine feature SSIS can take advantage of in SQL Server 2008?

1. Merge Statement
2. Multi Server Management
3. Both a and b
4. None of the above

Question 4 : What is the default size of the VARCHAR datatypes? (e.g. DECLARE @myChar CHAR)

1. 10
2. 20
3. 30
4. 40

Question 5 : Which of the following is new feature of SQL Server 2008 Reporting Services?

1. Matrics Grid
2. Report Rendering Architecture
3. Scale-out Analysis
4. None of the above

Question 6 : Data Tier Application is also known as -

1. DAC
2. DTA
3. DT
4. None of the above

Question 7 : TOP clause can be used with following statement?

1. SELECT
2. INSERT
3. DELETE
4. All of the above

Question 8 : How many columns a table can have if it contains SPARSE Columns?

1. 30
2. 3000
3. 30000
4. None of the above

Question 9 : Which catalogue view gives performance bottleneck?

1. sys.tables
2. sys.dm_os_wait_stats
3. sys.perfmonitor_cat
4. None of the above

Question 10 : What is the precision of TIME datatype inside SQL Server 2008?

1. 1 nanosecond
2. 10 nanosecond
3. 100 nanoseconds
4. 1000 nanoseconds

Question 11 : Which datatype allows to store more than 2GB?

1. VARCHAR(MAX)
2. NVARCHAR(2GB)
3. Filestream
4. All of the above

Question 12 : Which of these datatypes can be compressed inside SQL Server?

1. FLOAT, MONEY, TIMESTAMP
2. INT, DATE, TIME
3. Both a and b
4. None of the above

Question 13 :  Which version of the SQL Server supports ISO datetype?

1. SQL Server 2000
2. SQL Server 2005
3. SQL Server 2008
4. None of the above

Question 14 :  Which of the following syntax is invalid in SQL Server 2008 compatibility?

1. SET @x += 2
2. SET @x =* 2
3. SET @x = 2
4. SET @x = 2+2

Question 15 : Which of the following join hint cannot be specified with inner join?

1. Loop
2. Merge
3. Hash
4. All the above

Answers Key

Question	Answer
1	MAXDOP
2	80
3	Merge
4	1
5	Report Rendering Architecture
6	DAC
7	Select
8	30,000
9	sys.dm_os_wait_stats
10	100 nanoseconds
11	Filestream
12	Both a and b
13	SQL Server 2005
14	SET @x += 2
15	Merge