皮皮学，免费搜题
登录
搜题
【单选题】
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_SEQEMP_NAME and JOB_ID: As specified by the user during run time, through substitution 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);
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
皮皮学刷刷变学霸
举一反三
【单选题】客户张先生，年过40，就职于一家国有大型企业，任销售经理。他对于养老保险方面的知识知之甚少，以前对于自己的养老保险也没有多过问，但是随着年龄的增长，张先生开始越来越多地考虑自己退休以后的生活。虽然知道单位给自己缴纳了养老保险金，但是张先生并不知道自己的养老保险具体是怎么回事，自己退休后的生活有多大程度的保障。因而，张先生就相关知识向理财规划师进行咨询。张先生最关心的还是将来养老金的领取，他想知道是...
A.
归入国家财政收入
B.
一次性地支付给本人
C.
以年金的形式支付给本人
D.
归入全国社会保障基金
【单选题】病人说“走在街上陌生人总是冲着我吐痰,我认为他们讨厌我。有些人总是走到我身边看手表,他们指责我虚度青春。”这种思维障碍是
A.
被害妄想
B.
关系妄想
C.
夸大妄想
D.
嫉妒妄想
相关题目：