试题详情
- 单项选择题User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database. Which SQL statement can Mary use to accomplish that task?（）
A、CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu
B、CREATE PUBLIC SYNONYM EDL:VU FOR mary (emp_dept_loc_vu);
C、CREATE PUBLIC SYNONYM EDL_VU FOR emp _dept_loc_vu;
D、CREATE SYNONYM EDL_VU ON emp_dept_loc_vu FOR EACH USER;
E、CREATE SYNONYM EDL_VU FOR EACH USER ON emp_dept_loc_vu
F、CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;
关注下方微信公众号，在线模考后查看
热门试题
- Which two statements
- The STUDENT_GRADES
- Which SQL statement
- Mary has a view call
- Which four statement
- Which are iSQL*Plus
- The EMP table has t
- What does the TRUNCA
- You are granted the
- Which SQL statement
- Examine the SQL sta
- Which clause should
- You need to design
- Examine the structu
- Examine the structu
- Examine the descrip
- Evaluate the SQL st
- Examine the structu
- The EMPLOYEES table
- TheEMPLOYEEStablecon