創建成績表tscore,成績(score)列上創建檢查約束,要求score>=0,正確的語句為()
A.create table tscore(…, score numeric(18,1),… constraint score>=0)
B.create table tscore(…, score numeric(18,1)>=0,… )
C.create table tscore(…, score numeric(18,1),… constraint ck()score check(score>=0))
D.create table tscore(…, score numeric(18,1),… constraint ck()score score>=0)
正確答案:create table tscore(…, score numeric(18,1),… constraint ck()score check(score>=0))