【多选题】
Examine the structure of the EMPLOYEES table:<br /> EMPLOYEE_ID NUMBER NOT NULL, Primary Key<br /> EMP_NAME VARCHAR2(30)<br /> JOB_ID NUMBER\<br /> SAL NUMBER<br /> MGR_ID NUMBER References EMPLOYEE_ID column<br /> DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in<br /> orderto populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）
A、You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
B、The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
C、The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.
D、Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
E、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.
F、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.
查看正确答案
