Oracle认证考试
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
题目
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.
相似问题和答案
第1题：
What can we know from the last paragraph?
A. Mary feels pity for herself.
B. Mary has recovered from her disease.
C. Mary wants to help others as much as possible.
D. Mary determines to go back to the dance floor.
第2题：
A)has asked to
B)was asked to
C)is asked
D)asks to
第3题：
A.with
B.on
C.in
D.out of
第4题：
X?Mary has been to Japan. Y. Mary has been to Asia.
B.X presupposes Y
C.X is inconsistent with Y
D.X is synonymous with Y
第5题：
Mary ( ) brown eyes and golden hair.
A. have
B. have got
C. has got
第6题：
Mary ______ in bed all day because she had a fever.
A. lay
B. has laid
C. has lain
D. laid
9．答案为A 主要测试lie和lay,的词形变化，即：
|
动词原形 |
过去式 |
过去分词 |
现在分词 |
|
lie(躺) |
lay |
lain |
lying |
|
lie(说谎) |
lied |
lied |
lying |
|
lay(产卵，放下) |
laid |
laid |
laying |
第7题：
A、has been
B、are
C、was
D、were
第8题：
A、yet
B、already
C、never
第9题：
A.mkgroup -A=john,mary delivery
B.groupadd -A=john,mary delivery
C.mkgroup adms=john,mary delivery
D.groupadd adms=john,mary delivery
第10题：
X?Mary has been to Japan. Y. Mary has been to Asia.
B.X presupposes Y
C.X is inconsistent with Y
D.X is synonymous with Y