更多"Mary has a view called EMP_DEPT_LOC"的相关试题:
[单项选择] Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY .EMP_DEP_LOC_VU each time the view is referenced?()
A. Scott can create a synonym for the EMP_DEPT_LOC_VU bus using the command: CREATE PRIVATE SYNONYM EDL_VU FOR mary.EMP DEPT_LOC_VU; then he can prefix the columns with this synonymn.
B. Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym.
C. Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE LOCAL SYNONYM EDL_VU FOR mary.EMP DEPT_LOC_VU; then he can prefix the columns with this synonym.
D. Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE SYNONYM EDL_VU ON mary(EMP_DEPT_LOC_VU); then he can prefix the columns with this synonym.
E. Scott cannot create a synonym because synonyms can be created only for tables.
F. Scott cannot create any synonym for Mary’s view. Mary should create a private ynonym for the view and grant SELECT privilege on that synonym to Scott.
[单项选择]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;
[单项选择]Mary has just called and asked ______to have lunch with her tomorrow.
A. you and I
B. you and me
C. I and you
D. me and you
[单项选择]Mary has just called and asked ______ to have lunch with her tomorrow.
A. you and I
B. you and me
C. I and you
D. me and you
[单项选择]Mary has a curious expression on her face as though she ______ about something.
A. is smiling
B. were smiling
C. smiles
D. has smiled
[单项选择]The illness from which Mary is suffering has now been ______ as hepatitis(肝火).
A. diagnosed
B. determined
C. deduced
D. discovered
[单项选择]Mary has ______ his wedding until September.
A. put up
B. put forward
C. put out
D. put off
[单项选择]Mary has a 15-year contract with the company. By June next year, Mary ______ with this company for 14 years.
A. will have been working
B. will have worked
C. will work
D. works
[单项选择]We all know that Mary has had a strict______
A. growth
B. upbringing
C. development
D. cultivation
[单项选择]Mary has()e-dictionary. She got it from her uncle.
A. a
B. an
C. the
D. 不填
[单项选择]--Mary has got the first ______ in the competition. --Let's ______ a celebration, then.
A. praise; have
B. place; to
C. prize; hold
D. price; make
[单项选择]Mary has {{U}}blended{{/U}} the ingredients.
A. mixed
B. made
C. cooked
D. eaten