評(píng)估以下語句: ALTER TABLE employees ADD CONSTRAINT employee_id PRIMARY KEY; 該語句將返回以下哪種結(jié)果()
A.將返回語法錯(cuò)誤 B.將向EMPLOYEES表添加約束條件 C.將改寫EMPLOYEES表的一個(gè)現(xiàn)有約束條件 D.將啟用EMPLOYEES表的一個(gè)現(xiàn)有約束條件
PO_DETAILS表包含以下列: PO_NUM NUMBER NOT NULL, Primary Key PO_LINE_ID NUMBER NOT NULL, Primary Key PRODUCT_ID NUMBER Foreign Key to PRODUCT_ID column of the PRODUCTS table QUANTITY NUMBER UNIT_PRICE NUMBER(5,2) 請(qǐng)?jiān)u估以下語句: ALTER TABLE po_details DISABLE CONSTRAINT po_details_pk CASCADE;此語句用于完成什么任務(wù)()
A.新創(chuàng)建一個(gè)對(duì)PO_NUM列的PRIMARYKEY約束條件 B.刪除并重新創(chuàng)建對(duì)PO_NUM列的PRIMARYKEY以及FOREIGNKEY的約束條件 C.禁用依賴于PO_NUM列的所有FOREIGNKEY約束條件 D.禁用對(duì)PO_NUM列的約束條件,同時(shí)創(chuàng)建PRIMARYKEY索引
評(píng)估此CREATE TABLE語句的執(zhí)行結(jié)果: CREATE TABLE part( part_id NUMBER, part_name VARCHAR2(25), manufacturer_id NUMBER(9), retail_price NUMBER(7,2) NOT NULL, CONSTRAINT part_id_pk PRIMARY KEY(part_id), CONSTRAINT cost_nn NOT NULL(cost), CONSTRAINT FOREIGN KEY (manufacturer_id) REFERENCES manufacturer(id)); 哪一行會(huì)導(dǎo)致產(chǎn)生錯(cuò)誤()
A.6 B.7 C.8 D.9