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 synonym for the view and grant SELECT privilege on that synonym to Scott.
相关问题推荐
-
随着环境温度的升高，电池的浮充电压：（）
A、不变
B、升高
C、降低
D、以上都不正确
-
Which of the following would help a new administrator quickly determine if a network had a VLANfor its publicly accessible servers?（）
A、Baselines
B、Regulations
C、Logical network diagrams
D、Wiring schematics
-
以下哪种技术标准可以有效实现高速移动环境下的高数据传输速率（）。
A、IEEE802.11
B、IEEE802.16
C、IEEE802.20
D、IEEE802.11s
-
有一堆零件（零件个数不超过1000），如果分成4个零件一组余2个；7个一组余3个；9个一组余5个。求这堆零件的个数有几种可能。
-
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）
A、You should perform a log switch
B、You should make a backup of the database
C、You should switch the database to the NONARCHIVELOG mode
D、You should shut down the database instance and perform a complete database recovery