SQL Server: Test 2 - Online Test

Test Difficulty Level: Medium

Questions based on the SQL Server.

Question: Which is faster?

Option A: Union

Option B: Union All

Option C: Both are of equal efficiency

Option D: Can't be determined

To answer, click the "Start This Test" button below.

deepak k on 2011-07-18 11:39:08 wrote,

The number of non clustered index which can be created are 249 ..not 256 in Q.no 2

udham sorout on 2011-11-09 22:57:05 wrote,

sql server version is not specified while asking no. of non clustured indexes.