多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

Examine the structure if the EMPLOYEES table: You need to create a view called EMP_VU that allows the user to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the user to insert rows?()

  • A、CREATE VIEW emp_Vu AS   SELECT employee_id, emp_name,   department_id   FROM employees   WHERE mgr_id IN (102, 120);
  • B、CREATE VIEW emp_Vu AS   SELECT employee_id, emp_name, job_id   department_id   FROM employees   WHERE mgr_id IN (102, 120);
  • C、CREATE VIEW emp_Vu AS   SELECT department_id, SUM(sal) TOTALSAL   FROM employees   WHERE mgr_id IN (102, 120)   GROUP BY department_id;
  • D、CREATE VIEW emp_Vu AS   SELECT employee_id, emp_name, job_id,   DISTINCT department_id   FROM employees;
正确答案:B
答案解析:
进入题库查看解析

微信扫一扫手机做题