Examine these SOL statements which execute successfully
CREATE TABLE emp
(emp_no NUMBER(2) CONSTRATINT emp_emp_no_pk PRIMARY KEY,
ename varchar2(15),
salary number(8,2),
mgr_no number(2));
ALTER TABLE emp ADD CONSTRATINT emp_mgr_fk
FOREIGN KET(mgr_no)
REFERENCES emp(emp_no)
ON DELETE SET NULL;
ALTER TABLE emp
DISABLE CONSTRATINT emp_emp_no_pk
CASCADE;
ALTER TABLE emp
ENABLE CONSTRATINT emp_emp_no_pk;
Which two statements are true after execution?
A.The primary key constraint will be enabled and IMMEDIATE B.The foreign key constraint will be enabled and DEFERRED C.The foreign key constraint will be disabled D.The foreign key constraint will be enabled and IMMEDIATE E.The primary key constraint will be enabled and DEFERRED正确答案AC
