男性，70岁，30小时前因咳嗽而突然右下腹剧烈疼痛，以后持续胀痛，伴有恶心，呕吐，右侧阴囊肿胀疼痛。既往有右侧腹股沟可复性包块史。查体：腹胀明显，全腹轻压痛，无腹肌紧张，肠鸣音减弱。右侧腹股沟韧带中点上方至右侧阴囊高起，呈梨形，不能回纳，有轻压痛。
如手术发现肠管绞窄坏死，应采取的治疗为
A．坏死肠段切除
B．坏死肠段切除术+疝囊高位结扎术
C．坏死肠段切除术+疝修补术
D．坏死肠段切除术+吻合口下段肠造口术
E．坏死肠段切除术牛吻合口上段肠造口术
参考答案：B
解析：若发现肠管坏死，行坏死肠段切除及疝囊高位结扎，此时不宜修补，因伤口污染，修补易失败。
以下是EMPLOYEE表的详细定义，其中也包括了约束的描述。
| EMPLOYEE | ||||||||
| Column Name | EMPLOYEE_ID | NAME | JOB | MANAGER | DATE_HIRED | SALARY | BONUS | DEPIARTMENT_ID |
| Key-Type | PK | |||||||
| Nulls/Unique | NN，U | NN | NN | |||||
| FK Table | ||||||||
| FK Column | ||||||||
| Datatype | HUM | VARCHAR2 | VARCHAR2 | NUM | DATE | NUM | HUM | NUM |
| Length | 6 | 20 | 9 | 6 | 7, 2 | 7, 2 | 2 | |
A．CREATE VIEW department_v
AS SELECT DISTINCT department
FROM
employee;
B．CREATE VIEW emp_info_v
AS SELECT employee_id, name, job, manager
FROM
employee;
C．CREATE VIEW emp_info_v
AS SELECT employee_id, name, job, manager, department_id, date_hired
FROM
employee;
D．CREATE VIEW dept_salary_v
AS SELECT department_id，AVG (salary) "average salary"
FROM
employee
GROUP BY department_id;