Examine the structure of the EMPLOYEES table: EMPL...
多选题

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER/ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in orderto populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? ()

发布日期:2020-04-10

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.

热门试题

热门资讯

    暂无相关推荐~

分享给好友

分享到朋友圈

取消

使用浏览器的分享功能,把这篇文章分享出去

确定