Here are some SQL Server 2005 questions (I'll post the correct answers next time, but you have to give your answers first):
This database engine advisor in SQL Server 2005 allows you to examine the work load and helps in increasing query performance.
ANSWER:
A common name that specifies the auto numbering property in a SQL Server table.
ANSWER:
In SQL Server 2005, this new graphical tool replaces SQL Server 2000's Enterprise Manager.
ANSWER:
The extension of a primary database file.
ANSWER:
These values are always indeterminate, or undefined, or may be not applicable.
ANSWER:
This command line tool allows you to execute T-SQL batches and scripts via an OLEDB connection to a SQL Server instance. It supersedes the OSQL command from earlier versions.
ANSWER:
This database serves as a template for all new databases.
ANSWER:
This setting is of primary importance during installation of SQL Server version 7.0 or higher, as it relates to characterset, sort order and Unicode issues.
ANSWER:
This file contains a history of all transactions executed by a database.
ANSWER:
In order to access SQL Server 2005 using the local server name, one has to choose this instance during the install process.
ANSWER:
This specifies association between entities.
ANSWER:
One has to use this T-SQL command when building new database objects.
ANSWER:
This is also known as a repository of structured data.
ANSWER:
An explorer to view and manage SQL Server 2005 server objects.
ANSWER:
This tool helps to transfer and transform your data.
ANSWER:
This configuration tool of SQL Server 2005 is used to enable, disable and configure features, services and connections.
ANSWER:
These are alternate names that can be used to connect to a SQL Server instance.
ANSWER:
Each extent in a datafile is made up of several of these.
ANSWER:
To capture events that occur in SQL Server 2005, one has to use this tool.
ANSWER:
This key uniquely identifies each row in a table and is used for entity integrity checking.
ANSWER:
In this type of port configuration, the client application does not know the listening port of the SQL Server instance to which it is connecting.
ANSWER:
ENJOY!!!!