单选题 设在SQL Server 2008某数据库中建有如下会员卡表:
CREATE TABLE Table_Card (
CardID char(4) PRIMARY 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)
Ⅳ.INSERT INTO Table_Card
VALUES('1004','2012-1-1 12:30:04',135,3)
Ⅴ.UPDATE Table_Card SET State=3 WHERE CardID='1001'
Ⅵ.UPDATE Table_Card SET State=1 WHERE CardlD='1004'
以上操作对Table_Card表数据产生影响的是
  • A.仅Ⅰ、Ⅱ和Ⅲ
  • B.仅Ⅰ、Ⅴ和Ⅵ
  • C.仅Ⅰ、Ⅱ、Ⅲ和Ⅵ
  • D.仅Ⅲ、Ⅳ、Ⅴ和Ⅵ
【正确答案】 A
【答案解析】