问题
选择题
以下列举的事例中说法正确的是 [ ]
A.食用馒头可以补充糖类
B.用含亚硝酸钠的工业用盐腌制食品
C.服用大量含碳酸钙的药物来补钙
D.用甲醛水溶液泡制水产品并出售
答案
答案:A
以下列举的事例中说法正确的是 [ ]
A.食用馒头可以补充糖类
B.用含亚硝酸钠的工业用盐腌制食品
C.服用大量含碳酸钙的药物来补钙
D.用甲醛水溶液泡制水产品并出售
答案:A
以下是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;