This test is available in both the Average Skill level and the Advanced Skill level. The Average Skill level test will have at least 25 questions and will take approximately 30 minutes to complete. The Advanced Skill level test will have at least 40 questions and will take approximately 45 to 60 minutes to complete. These tests may also be combined with other tests to present a Combined Test of any length.

These are Multiple Choice type tests with at least four possible answers, only one of which is correct. We constantly change, revise and upgrade our test and really value your opinion. Please send us any suggestions or additions so that we may consider them.

Among the areas covered by this test are the following:

  • Prebuilt databases within SQL server,
  • Database system type,
  • SQL Server data types, creating index,
  • Transaction logs, transaction,
  • View, Snapshots,
  • Backup and recovery,
  • XML, Replication
  • and much more

We have included a sample question below to give you the style and essence of the test To take a demo of our tests please click the Try a Test Demo button above.

A user has installed SQL Server 2008 and needs to move the system databases to a new drive to comply with corporate standards. Which of the following system database files can he move?

1)      “master.mdf, mssqlsystemresource.mdf, msdb.mdf ”

2)      “mssqlsystemresource.mdf, model.mdf, msdb.mdf ”

3)      master.mdf, model.mdf, mssqlsystemresource.mdf

4)      master.mdf, model.mdf, msdb.mdf