题目内容

菜肴盘饰的式样从形状和作用上分为()、()、()、边角式、象形式。

查看答案
更多问题

在我国,劳动和受教育既是公民的权利,又是公民的义务,这体现着()。

A. 公民的权利和义务是对立的
B. 公民的权利和义务是一致的
C. 公民的权利和义务是相互促进的
D. 权利和义务是没有区别的

在管道的某一点安装一个压力表,所得到的读数就是管道内那一点的压力。

A. 正确
B. 错误

当某房地产投资项目的基准收益率大于银行的贷款率,且该项目在经济上又是可行的,那么其资本金的内部收益率就大于全投资的内部收益率。

A. 正确
B. 错误

Examine the data in the EMPLOYEES and EMP_HIST tables: EMPLOYEES NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 IT_ADMIN 5000 106 Smith 40 110 AD_ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EX_DIR 8000 120 Ravi 20 110 SA_DIR 6500 EMP HIST EMPLOYEE_ID NAME JOB_ID SALARY 101 Smith SA_CLERK 2000 103 Chris IT_CLERK 2200 104 John HR_CLERK 2000 106 Smith AD_ASST 3000 108 Jennifer HR_MGR 4500 The EMP_HIST table is updated at the end of every year. The employee ID, name, job ID, and salary of each existing employee are modified with the latest data. New employee details are added to the table. Which statement accomplishes this task?()

A. UPDATE emp_hist SET employee_id, name, job_id, salary = (SELECT employee_id, name, job_id, salary FROM employees) WHERE employee_id IN (SELECT employee_id FROM employees);
B. MERGE INTO emp_hist eh USING employees e ON (eh.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT VALUES (e.employee id, e.name, job id, e.salary);
C. MERGE INTO emp_hist eh USING employees e ON (eh.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE emp hist SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT INTO emp_hist VALUES (e.employees_id, e.name, e.job_id, e.salary);
D. MERGE INTO emp_hist eh USING employees e WHEN MATCHED THEN UPDATE emp_hist SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT INTO emp_hist VALUES (e.employees_id, e.name, e.job_id, e.salary)

答案查题题库