.Net Framework

SQL Server

Server OS

All the Above

Sequential

State machine

Sequential & State machine

None of the above

As a lookup field in list column

Can be derived programmatically

As a lookup field in list column & Can be derived programmatically

Not supported by SharePoint

30 days

2 weeks

10 days

1 week

Wild Card Inclusion

Explicit inclusion

Implicit inclusion

Wild Card Inclusion & Explicit inclusion

Explicit inclusion & Implicit inclusion

Possible in all list

Possible in libraries

Not possible in libraries

No such feature in SharePoint

List

Libraries

List & Libraries

None of the above

Not Possible

Restrict only certain file types.

Restrict any file type by doing as below, Central administration page >Under operations > Blocked File Types and Add .extension of the file type

Restrict any file type by doing as below, Site setting >Under Gallery > Blocked File Types and Add .extension of the file type

At Home page

Only at sub sites

Only in Quick Launch

Only in Web Part Zone

C:\inetpub

C:\inetpub\wwwroot\wss\VirtualDirectories

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Bin

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions

Dws

Dwp

Pwd

Wbp

Site template

Features

List Definition

All the above

http://servername/

http://Servername:Portnumber/

http://portnumber:servername/

http://portnumber/

Number which indicates the server

GUID number used in URL

Unique number used to create site

Number helps in identifying the site name.

C:\inetpub

C:\inetpub\wwwroot\wss\VirtualDirectories

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12

As per user’s convenience.

Combined Application Marketing Language

Collaborative Application Marketing Language

Custom Application Marketing Language

Collaborative Application Markup Language

Under Site collection Feature

Under Manage site features

Under Site Administration

Cannot do manually

Under People and Groups

Under Site Settings

Under Central Administrations

Not Possible

Cannot open

Cannot create version at all

From Version History in ECB menu

From Site Settings

Project team should have gone for a failover architecture like 2 servers of 12 CPU, 12 GB RAM instead of single server

Project team trusted server vendor who guaranteed excellent performance and scalability

Project team overlooked the fact that results derived on a single CPU machine cannot be extrapolated to 24 CPU servers

It's sheer bad luck that the application crashed; there's no mistake, at least they tried