首页 资讯 TableTAB1wascreatedusingthefollowingstatement:CREATETABLEtab

TableTAB1wascreatedusingthefollowingstatement:CREATETABLEtab

TableTAB1wascreatedusingthefollowingstatement:CREATETABLEtab1(c1INT,c2INT,c3INT,c4INT,c5INT);IfcolumnC1isuniqueandqueriestypicallyaccesscolumnsC1andC2together,whichstatement(s)willcreateindex(es)thatwillprovideoptimalqueryperformance?()

A.CREATEUNIQUEINDEXxtab1ONtab1(c1)include(c2)

B.CREATEUNIQUEINDEXxtab1ONtab1(c1);CREATEINDEXxtab2ONtab1(c3)INCLUDE(c2)

C.CREATEUNIQUEINDEXxtab1ONtab1(c2,c1)

D.CREATEUNIQUEINDEXxtab1ONtab1(c2)INCLUDE(c1)

参考答案:A

本文来自网络,不代表煤炭资讯立场。转载请注明出处: http://www.mtxh.cn/zx/413083.html
上一篇
下一篇

作者: Anita

为您推荐

返回顶部