柠檬试题库
search
首页 计算机 公务员 驾照 关于

设在SQL Server 2008某数据库中建有如下会员卡表: CREATE TABLE Table_Card ( CardID char(4) PRJMARY KEY, StartDate datetime NOT NULL, Score int NOT NULL DEFAULT 0, State int NOT NULL CHECK (State in (0,1,2)) ) 现表中无数据,某用户对此表依次进行了如下操作: Ⅰ. INSERT INTO Table_Card VALUES ('1001 ','2012-1-1 12:30:01 ',154,0) Ⅱ . INSERT INTO Table_Card ( CardID, StartDate, State) VALUES ('1002','2012-1-1 12:30:02',1) Ⅲ. INSERT INTO Table_Card VALUES ('1003','2012-1-1 12:30:03 ',172,2) IV. INSERT INTO Table_Card VALUES (' 1004','2012-1-1 12:30:04',135,3) V. UPDATE Table_Card SET State = 3 WHERE CardID ='1001 ' VI. UPDATE Table Card SET State = 1 WHERE CardID='1004' 以上操作对Table_Card表数据产生影响的是()


  • A.仅Ⅰ、Ⅱ和Ⅲ
  • B.仅Ⅰ、Ⅴ和Ⅵ
  • C.仅Ⅰ、Ⅱ、Ⅲ和Ⅵ
  • D.仅Ⅲ、Ⅳ、Ⅴ和Ⅵ
热度🔥406
参考答案:A
解析:打开微信小程序查看本题解析