Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Server Trivia

Think you know SQL Server past and present? Here are the next-to-impossible questions I asked at the SQLSaturday #51 Stump The Experts session in Nashville. There were a few people who apparently have far more active brain cells than me who managed to answer a couple of these questions. But for the most part, these questions, did indeed, stump the experts.

Let’s see how you do.

The Trivia Questions

Question 1:

True or False. The following T-SQL statement is valid.

CREATE TABLE # (Column1 INT);

Question 2:

What’s the maximum number of nonclustered indexes per table for a 64-bit instance of SQL Server 2008 R2?

Question 3:

There was a little known and cancelled upgrade to Windows 95 that eventually became known as Windows Desktop Update, Internet Explorer 4.0. What was its codename?

Question 4:

For what processors was SQL Server 4.21a SP4 available?

Question 5:

When did Mainstream Support end for SQL Server 2000 Enterprise Edition?

Question 6:

What is the maximum number of columns you can have in a single SELECT statement in a 64-bit instance of SQL Server 2008 R2?

Question 7:

What was the final name of the SQL Server feature that originally was known by the code name Rosetta?

Question 8:

What command displays information about the installed versions and registered instances of Notification Services?

Question 9:

How many task in SSIS for SQL Server 2008 R2 are designed for SSAS?

Question 10:

On what operating systems did SQL Server 4.20 run?

Question 11:

How many copies of a query plan can be in memory at one time in SQL Server 2008 R2?

Question 12:

In how many different North American cities has the PASS Community Summit been held?

Question 13:

Name one aspect of SQL Server that separate it from any other Microsoft product.

Question 14:

For which operating system was SQL Server originally developed?

Question 15:

In SQL Server 2008 R2, how many DMVs are related to Indexes?

Question 16:

How much was an unlimited user license for SQL Server 1.1?

Question 17:

When was SQL Server 1.1 released?

Question 18:

When SQL Server 1.1 was first released, it was considered to be well behind in sales compared to Oracle Server for OS/2. How many licenses had Oracle sold already?

Question 19:

True or False. SQL CE can be managed from SQL Server Management Studio 2005.

Question 20:

When AUTO_UPDATE_STATISTICS is ON, updated statistics or cardinality changes to which of the follow tables cause a recompile?

a) User Tables
b) Temporary Tables
c) Inserted Tables
d) Deleted Tables

The Answers

Answer 1:

True. But it’s scheduled to be deprecated in a post SQL Server 2008 R2 release. (http://bit.ly/sqlsat51-1)

Answer 2:

999 (http://bit.ly/sqlsat51-2)

Answer 3:

Nashville (http://bit.ly/sqlsat51-3)

Answer 4:

SQL Server 4.21a Service Pack 4 was available for Intel (x86), MIPS, and Alpha-based computers. (http://bit.ly/sqlsat51-4)

Answer 5:

April 8th, 2008 (http://bit.ly/sqlsat51-5)

Answer 6:

4096 (http://bit.ly/sqlsat51-6)

Answer 7:

Reporting Services (http://bit.ly/sqlsat51-7)

Answer 8:

NSControl ListVersions (http://bit.ly/sqlsat51-8)

Answer 9:

3 (http://bit.ly/sqlsat51-9)

Answer 10:

Windows NT 3.1/Windows NT Advanced Server 3.1 (http://bit.ly/sqlsat51-10)

Answer 11:

2; one for parallel execution and another for serialized execution. (http://bit.ly/sqlsat51-11)

Answer 12:

6; Chicago, San Francisco, Denver, Seattle, Orlando, Dallas/Grapevine (http://bit.ly/sqlsat51-12)

Answer 13:

SQL Server is the only Microsoft product that allows you to set processor affinity. (via Buck Woody)

Answer 14:

UNIX; that’s why SQL Server still has processor affinity on a SMP operating system. (via Buck Woody)

Answer 15:

7 (http://bit.ly/sqlsat51-15)

sys.dm_db_index_operational_stats,

sys.dm_db_index_usage_stats,

sys.dm_db_missing_index_details,

sys.dm_db_missing_index_groups,

sys.dm_db_index_physical_stats,

sys.dm_db_missing_index_columns

sys.dm_db_missing_index_group_stats

Answer 16:

$3,995 (http://bit.ly/sqlsat51-16)

Answer 17:

August 20th, 1990 (http://bit.ly/sqlsat51-17)

Answer 18:

7,000 (http://bit.ly/sqlsat51-18)

Answer 19:

True. (http://bit.ly/sqlsat51-19)

Answer 20:

All of the above. (http://bit.ly/sqlsat51-20)

The Results

So how did you do? Got any other good trivia questions that I could have / should have added to the list?

And a very special thanks to our panel of experts – Thomas LaRock, Jason Strate, Kendra Little, Jeremiah Peschka, Louis Davidson, and Kevin Boles!


Filed under: Community, Events, Just for fun, SQLServerPedia Syndication

Comments

Posted by Shawn Melton on 24 August 2010

Huh, a few of those would be good interview questions too ;)

Like (12) just to see if they know what PASS is. I got a few right but only close to the other ones :(

Posted by Joe Webb on 24 August 2010

Don't beat yourself up too badly over these. They were designed to be next to impossible to answer.

Leave a Comment

Please register or log in to leave a comment.