1Z0-061 · Question #167
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…
The correct answer is 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. The EMP_ID_SEQ sequence is not affected by modification to the EMPLOYEES table. Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
Question
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 order to populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? (Choose two.)
Options
- AYou cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
- BThe EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
- CThe EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.
- DAny other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
- EThe EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.
- FThe EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.
How the community answered
(23 responses)- A4% (1)
- C83% (19)
- E9% (2)
- F4% (1)
Explanation
The EMP_ID_SEQ sequence is not affected by modification to the EMPLOYEES table. Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
Topics
Community Discussion
No community discussion yet for this question.