当前位置:1Z0-007题库

问题:

[单选]

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, 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)

侯女士,32岁,诊断为甲亢。护士清晨测得患者的脉搏96/min,血压130/70mmHg,计算其基础代谢率应属于() 正常。 正常范围偏高。 重度甲亢。 中度甲亢。 轻度甲亢。 唐朝初期皇帝调整统治政策所发挥的作用,客观上最能体现战国时期儒家“仁政”主张的是()。 三省六部制、科举制。 租庸调制、科举制。 均田制、科举制。 均田制、租庸调制。 社会学一词最早是由()提出来的 涂尔干。 马克思。 斯宾塞。 孔德。 What does it mean for a variable in the Application Editor to be defined as a parameter?() The variable can be used to pass data to and from subflows.  。 The value for that variable can be supplied via Application Configuration in Application Administration.  。 The value for that variable is defined by the calling application.  。 The variable can be used in conditional steps.  。 The variable can be used to pass data to and from VoiceXML applications.。 【背景资料】某建筑工程,建筑面积24642㎡,地上10层,地下2层(地下水位-2.0m)。主体结构为非预应力现浇混凝土框架剪力墙结构(柱网为9m*9m,局部柱距为6m),抗震设防烈度7度。梁、柱受力钢筋为HRB335.结构主体地下室外墙采用P8防水混凝土浇筑,墙厚250mm,钢筋净距60mm,混凝土为商品混凝土。一、二层柱混凝土强度等级为C40,以上各层柱为C30。 情形1:施工过程中,施工单位进场的一批水泥经检验其初凝时间不符合要求,另外由于工期要求很紧,地下室外墙施工不得不在气温只有-3℃时进行。 情形2:钢筋过程施工时,发现梁、柱钢筋的接头采用挤压连接,有位于梁、柱端箍筋加密区的情况。在现场留取接头试件样本时,是以同一层每600个为一验收批,并按规定抽取试件样本进行合格性检验。 情形3:结构主体地下室外墙防水混凝土浇筑过程中,现场对粗骨料的最大粒径进行了检测,检测结果为40mm。请根据背景资料完成以下选项。 该工程下述施工做法正确的有() 梁、柱端箍筋加密区出现挤压连接接头。 在现场取留接头试件时,在同一层选取试件600个为一验收批。 商品混凝土粗骨料最大粒径控制为40mm。 框架梁同一截面范围钢筋接头百分率不大于50%。

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, 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?()

参考答案:

  参考解析

本题暂无解析

相关题目:

在线 客服