多项选择题
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? （）
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.
相关考题
-
多项选择题
Which three are DATETIME data types that can be used when specifying column definitions?（）
A.TIMESTAMP
B.INTERVAL MONTH TO DAY
C.INTERVAL DAY TO SECOND
D.INTERVAL YEAR TO MONTH
E.TIMESTAMP WITH DATABASE TIMEZONE -
单项选择题
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) SAL NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below: EMPLOYEE_ID: Next value from the sequence EMP_ID_SEQ EMP_NAME and JOB_ID: As specified by the user during run time, throughsubstitution variables SAL: 2000 MGR_ID: No value DEPARTMENT_ID: Supplied by the user during run time through substitution variable. The INSERT statement should fail if the user supplies a value other than 20 or 50. Which INSERT statement meets the above requirements?（）
A.INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did);
B.INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did IN (20,50));
C.INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50)) VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did);
D.INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50) WITH CHECK OPTION) VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did);
E.INSERT INTO (SELECT * FROM employees WHERE (department_id = 20 AND department_id = 50) WITH CHECK OPTION ) VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did); -
单项选择题
You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view?（）
A.Use the DESCRIBE command on the EMP_DEPT_VU view.
B.Use the DEFINE VIEW command on the EMP_DEPT_VU view.
C.Use the DESCRIBE VIEW command on the EMP_DEPT_VU view.
D.Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
E.Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
F.Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
