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_DEPT_LOC_VU each time the view is referenced?（） -题库考试答案搜索网

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_DEPT_LOC_VU each time the view is referenced?（）

单选题

2022-01-05 13:28

A、Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE PRIVATE SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym.
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.

查看答案

正确答案

试题解析

标签： 1Z0-007

感兴趣题目

A vessel proceeding along the bank of a river or channel has the tendency to（）.

Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?（）

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? （）

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 created.) How do you obtain the definition of the view?（）

Project（71）is an uncertain event or condition that，if it occurs，has a positive or a negative effect on at least one project objective，such as time，cost，scope，or quality．

● Project（71）is an uncertain event or condition that, if it occurs, has a positive or a negative effect on at least one project objective, such as time, cost, scope, or quality.（71）

Sand painting has also called dry or earth painting and is practiced by several American Indian artists.

The inner cloud bands of a hurricane，when viewed from a distance，form a mass of dense，black cumulonimbus clouds called the（）.

The movement of water away from the shore or downstream is called a(n)（）.

A device fitted over the discharge opening on a relief valve consisting of one or two woven wire fabrics is called a flame（）.

A device fitted over the discharge opening on a relief valve consisting of one or two woven wire fabrics is called a（）.

A current moving across a lock entrance toward the river or toward the dam is called a(n)（）.