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 Transact-SQL statement should you use?
A.
SELECT name AS table_name FROM sys.tables
WHERE OBJECTPROPERTY(object_id,’TableHasClustIndex’) = 0
ORDER BY name;
B.
SELECT name AS table_name
FROM sys.tables WHERE OBJECTPROPERTY(object_id,’TableHasUniqueCnst’) = 0 ORDER BY name;
C.
SELECT name AS table_name FROM sys.tables
WHERE OBJECTPROPERTY(object_id,’TableHasClustIndex’) = 0 AND
OBJECTPROPERTY(object_id,’TableHasUniqueCnst’) = 1 ORDER BY name;
D.
SELECT name AS table_name FROM sys.tables
WHERE OBJECTPROPERTY(object_id,’TableHasClustIndex’) = 1 AND OBJECTPROPERTY(object_id,’TableHasUniqueCnst’) = 1
ORDER BY name;