注意:此页面搜索的是所有试题
题目内容
(软件工程)
你要评估一个数据库设计。此数据库中的所有表都应有聚集索引。你需要使用系统目录视图来确定缺少聚集索引的表。应使用哪一条Transact-SQL语句?
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;
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;
参考答案