READ Free Dumps For Oracle- 1z1-051
Question ID 4952 | Which four are types of functions available in SQL? (Choose 4) |
Option A | A. string |
Option B | B. character |
Option C | C. integer |
Option D | D. date |
Option E | E. numeric |
Option F | F. conversion |
Correct Answer | B,D,E,F |
Question ID 4953 | Examine the structure of the EMPLOYEES table: |
Option A | A. You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column. |
Option B | B. The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column. |
Option C | C. The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table. |
Option D | D. Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence. |
Option E | E. The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table. |
Option F | F. The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column. |
Correct Answer | C,D |