单项选择题
A.ALTER TABLE语句创建从EMPLOYEE表到DEPARTMENT表的引用约束条件
B.ALTER TABLE语句创建从DEPARTMENT表到EMPLOYEE表的引用约束条件
C.ADD CONSTRAINT子句存在语法错误,因此ALTER TABLE语句将会失败
D.ALTER TABLE语句执行成功,但不重新创建引用约束条件
单项选择题 请观察PRODUCT表和SUPPLIER表的结构: PRODUCT PRODUCT_ID NUMBER NOT NULL, Primary Key PRODUCT_NAME VARCHAR2 (25) SUPPLIER_ID NUMBER ( SUPPLIER表的SUPPLIER_ID的外键) LIST_PRICE NUMBER (7,2) COST NUMBER (7,2) QTY_IN_STOCK NUMBER QTY_ON_ORDER NUMBER REORDER_LEVEL NUMBER REORDER_QTY NUMBER SUPPLIER SUPPLIER_ID NUMBER NOT NULL, Primary Key SUPPLIER_NAME VARCHAR2 (25) ADDRESS VARCHAR2 (30) CITY VARCHAR2 (25) REGION VARCHAR2 (10) POSTAL_CODE VARCHAR2 (11) 请评估以下语句: ALTER TABLE suppliers DISABLE CONSTRAINT supplier_id_pk CASCADE; 该语句用于执行什么任务()
单项选择题 评估以下语句: ALTER TABLE employees ADD CONSTRAINT employee_id PRIMARY KEY; 该语句将返回以下哪种结果()
单项选择题 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) 请评估以下语句: ALTER TABLE po_details DISABLE CONSTRAINT po_details_pk CASCADE;此语句用于完成什么任务()