搜题
问题   更新时间2023/4/3 12:59:00

你要评估一个数据库设计。此数据库中的所有表都应有聚集索引。你需要使用系统目录视图来确定缺少聚集索引的表。应使用哪一条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

出自:江开 >> 软件工程

王老师:19139051760(拨打)