网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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.
参考答案
更多 “ 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.” 相关考题
考题
Mary has left the book on the table () purpose so that you can read it.
A.withB.onC.inD.out of
考题
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.
考题
Which command will create a group called ‘delivery’and set the administrators to john’ and ‘mary’?()
A.mkgroup -A=john,mary deliveryB.groupadd -A=john,mary deliveryC.mkgroup adms=john,mary deliveryD.groupadd adms=john,mary delivery
考题
The sense relation of the following pair of sentences (see X and Y) is__________.
X?Mary has been to Japan. Y. Mary has been to Asia.A.X entails Y
B.X presupposes Y
C.X is inconsistent with Y
D.X is synonymous with Y
考题
The sense relation of the following pair of sentences (see X and Y) is__________.
X?Mary has been to Japan. Y. Mary has been to Asia.A.X entails Y
B.X presupposes Y
C.X is inconsistent with Y
D.X is synonymous with Y
考题
The sense relation of the following pair of sentences isX. Mary has been to Japan. Y. Mary has been to Asia.
A．X entails Y
B．X presupposes Y
C．X is inconsistent with Y
D．X is synonymous with Y
考题
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 derived a good deal of benefit from her job.A:obtained B:accepted C:bribed D:produced
考题
Mary called me up very late last night.A: praised me
B: visited me
C: telephoned me
D: waked me
考题
You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? （）A、Use the DESCRIBE command in the EMP_DEPT VU view.B、Use the DEFINE VIEW command on the EMP_DEPT VU view.C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view.D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
考题
Which command will create a group called ’delivery’ and set the administrators to ’john’ and ’mary’？（） A、mkgroup -A=john，mary deliveryB、groupadd -A=john，mary deliveryC、mkgroup adms=john，mary deliveryD、groupadd adms=john，mary delivery
考题
单选题_____A
The woman has bought a few things for the man.B
The woman has bought a lot of things for Mary.C
The woman has bought nothing for Mary.D
The woman has bought a few things for herself.
考题
单选题In Saussure’s view, a sign is just like a coin. It has two sides. One is the signifier, the other is called the _____.A
significantB
signifiedC
signD
index
考题
单选题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 cannot create a synonym because synonyms can be created only for tables.E
Scott cannot create any synonym for Mary's view. Mary should create a private synonym 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_vuB
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_vuF
CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;
考题
单选题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.
考题
单选题You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view?（）A
Use the DESCRIBE command in the EMP_DEPT VU view.B
Use the DEFINE VIEW command on the EMP_DEPT VU view.C
Use the DESCRIBE VIEW command on the EMP_DEPT VU view.D
Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.E
Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.F
Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
考题
单选题Mary called and asked her husband ______ home at once, because she locked her daughter in the home.A
to leaveB
leaveC
goD
to go
考题
单选题The EMP_DEPT block in your EMPLOYEE form is based on a view in an Oracle8 database. The items in this block have the Update Allowed property set to Yes. Which database feature makes it possible to permanently modify the underlying view?（）A
REF cursor. B
Instead Of trigger. C
Stored procedure that returns object values. D
The underlying view cannot be modified because DML on a view is not supported.
考题
单选题What does the FORCE option for creating a view do?（）A
creates a view with constraintsB
creates a view even if the underlying parent table has constraintsC
creates a view in another schema even if you don't have privilegesD
creates a view regardless of whether or not the base tables exist
考题
单选题You are listening to a radio phone-in programme. Why has the woman called? A
To criticise the famous.B
To express a different point of view.C
To sympathise with photographers.
热门标签
最新试卷
