A.CHECK B.UNIQUE C.NOTNULL D.PRIMARYKEY
A.NOTNULL B.FOREIGNKEY C.UNIQUE D.CHECK
評估以下CREATETABLE語句的執(zhí)行結(jié)果: CREATET ABLE customers (customer_id NUMBER,customer_name VARCHAR2(25), address VARCHAR 2(25), city VARCHAR 2(25), region VARCHAR 2(25), postal_code VARCHAR 2(11), CONSTRAINT customer_id_un UNIQUE(customer_id), CONSTRAINTcustomer_name_nnNOTNULL(customer_name)); 為什么執(zhí)行時此語句會失敗()
A.NUMBER數(shù)據(jù)類型要求精度值 B.UNIQUE約束條件必須在列級定義 C.CREATETABLE語句不定義PRIMARYKEY D.不能在表級定義NOTNULL約束條件