You are given a database design to evaluate. All of the tables in this database should have a
clustered index.
You need to determine the tables that are missing a clustered index by using the system catalog
views.
Which TransactSQL
statement should you use?

You need to identify which tables are referenced by name in a stored procedure that does not use
dynamic SQL.
Which catalog view should you use?

How many years of experience do you have in developing databases using SQL Server 2008?

How many years of experience do you have in configuring any version of SQL Server?

Rate your level of proficiency with creating, implementing, and altering tables, views, and indexes in
SQL Server, including implementing data types and partitioning solutions.

Rate your level of proficiency with implementing programming objects in SQL Server, including
creating and altering stored procedures, userdefined
functions, DML and DDL triggers, and CLRbased
objects; managing transactions; and implementing error handling.

Rate your level of proficiency in working with query fundamentals, including using SELECT, INSERT,
UPDATE, DELETE, OUTPUT, and MERGE statements, implementing aggregate queries, combining
datasets, and applying builtin
scalar functions.

Rate your level of proficiency with applying additional SQL Server query techniques, including
subqueries, CTE queries, ranking functions, and execution plans.

Rate your level of proficiency with using additional SQL Server components, including Database Mail,
Fulltext search, Windows PowerShell?, SQL Server Management Objects, and Service Broker.

Rate your level of proficiency with using XML data, including retrieving relational data as XML,
transforming XML into relational data, and querying and managing XML data.