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í)行時(shí)此語句會失敗()
A.NUMBER數(shù)據(jù)類型要求精度值 B.UNIQUE約束條件必須在列級定義 C.CREATETABLE語句不定義PRIMARYKEY D.不能在表級定義NOTNULL約束條件
評估EMPLOYEE表的結(jié)構(gòu): EMPLOYEE_IDNUMBER(9) LAST_NAMEVARCHAR2(25) FIRST_NAMEVARCHAR2(25) DEPARTMENT_IDNUMBER(9) MANAGER_IDNUMBER(9) SALARYNUMBER(7,2) 您使用以下哪條語句可將LAST_NAME列(當(dāng)前包含200條記錄)的長度增加到35個(gè)字節(jié)()
A.ALTER employee TABLEAL TERCOLUMN(last_name VARCHAR2(35)) B.ALTER TABLE employee RENAME last_name VARCHAR2(35) C.ALTER TABLE employee MODIFY(last_name VARCHAR2(35)) D.不能增大LAST_NAME列的寬度