• Was sure about other three answers but not sure about

    Running DBCC CHECKALLOC or DBCC CHECKCATALOG

    I executed them on all SQL Server versions and it could be executed successfully on SQL Server 6.5, SQL Server 7 and SQL Server 2000.

    But 2005 and 2008 throws error.

    The check statement was aborted. DBCC CHECKCATALOG cannot be run on TEMPDB.

    The check statement was aborted. DBCC CHECKALLOC cannot be run on TEMPDB.

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    SQL DBA.