A.CHECK B.UNIQUE C.NOTNULL D.PRIMARYKEY
A.NOTNULL B.FOREIGNKEY C.UNIQUE D.CHECK
評(píng)估以下CREATETABLE語(yǔ)句的執(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í)行時(shí)此語(yǔ)句會(huì)失?。ǎ?/p>
A.NUMBER數(shù)據(jù)類(lèi)型要求精度值 B.UNIQUE約束條件必須在列級(jí)定義 C.CREATETABLE語(yǔ)句不定義PRIMARYKEY D.不能在表級(jí)定義NOTNULL約束條件