单选题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? （）AScott 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.BScott 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.CScott 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.DScott cannot create a synonym because synonyms can be created only for tables.EScott 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.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
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
Mary has just called and asked__to have lunch with her tomorrow.A.you and IB.you and meC.I and youD.me and you
Emerson（）Transcendentalist.A、called himselfB、did not like the termC、never called himselfD、created the term
Derek has created a view in the products.nsf database. Derek wants the markup column in the view to display the selling price of the cost. He wants this value to display in currency. Which one of the following should derekl do? （）A、 use the @currenty in thr column formula in the view B、 Select currency on the numbers tab in the view properties box C、 Select currency on the numbers tab in the column properties box D、 Select currency on the numbers tab in the field properties box
Which two statements about views are true? （）A、A view can be created as read only.B、A view can be created as a join on two or more tables.C、A view cannot have an ORDER BY clause in the SELECT statement.D、A view cannot be created with a GROUP BY clause in the SELECT statement.E、A view must have aliases defined for the column names in the SELECT statement.
Derek has created a view in the sales.nsf db. Derek wants the sales value column in the view to be punctuated to display two decimal places . which one of the following should he do?（）A、 use the @function @decimal in the column formula in the view B、 select decimal on the numbers tab in the view properties box C、 select decimal on the numbers tab in the column properties boxD、 use the @function @decimal to format the value in the field on the form that will display in 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 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.
tommy has created a sales view in his sales.nsf database. Tommy wants negative numbers in the sales number column in the view parenthesis. which one of the following should tommy do?（）A、select the parenthesis when negative value in the view properties box B、select the parenthesis when negative value in the column properties box C、use the @function @negative to set this in the column formula in the view D、use a formula to format the value in the field on the form that will be displaying in the 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
Which two statements are true regarding views?（）A、A subquery that defines a view cannot include the GROUP BY clause B、A view that is created with the subquery having the DISTINCT keyword can be updated C、A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated D、A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table
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?（）A、Use the DESCRIBE command on 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.
单选题_____AThe woman has bought a few things for the man.BThe woman has bought a lot of things for Mary.CThe woman has bought nothing for Mary.DThe 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 _____.AsignificantBsignifiedCsignDindex
单选题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?（）ACREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vuBCREATE PUBLIC SYNONYM EDL:VU FOR mary (emp_dept_loc_vu);CCREATE PUBLIC SYNONYM EDL_VU FOR emp _dept_loc_vu;DCREATE SYNONYM EDL_VU ON emp_dept_loc_vu FOR EACH USER;ECREATE SYNONYM EDL_VU FOR EACH USER ON emp_dept_loc_vuFCREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;
多选题Which two statements are true regarding views?（）AA subquery that defines a view cannot include the GROUP BY clauseBA view that is created with the subquery having the DISTINCT keyword can be updatedCA view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updatedDA data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table
单选题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?（）AScott 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.BScott 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.CScott 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.DScott 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.EScott cannot create a synonym because synonyms can be created only for tables.FScott 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?（）AUse the DESCRIBE command in the EMP_DEPT VU view.BUse the DEFINE VIEW command on the EMP_DEPT VU view.CUse the DESCRIBE VIEW command on the EMP_DEPT VU view.DQuery the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.EQuery the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.FQuery the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
多选题Which two statements about views are true?（）AA view can be created as read only.BA view can be created as a join on two or more tables.CA view cannot have an ORDER BY clause in the SELECT statement.DA view cannot be created with a GROUP BY clause in the SELECT statement.EA view must have aliases defined for the column names in the SELECT statement.
单选题What does the FORCE option for creating a view do?（）Acreates a view with constraintsBcreates a view even if the underlying parent table has constraintsCcreates a view in another schema even if you don't have privilegesDcreates a view regardless of whether or not the base tables exist
单选题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?（）AUse the DESCRIBE command on the EMP_DEPT_VU view.BUse the DEFINE VIEW command on the EMP_DEPT_VU view.CUse the DESCRIBE VIEW command on the EMP_DEPT_VU view.DQuery the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.EQuery the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.FQuery the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
单选题You are listening to a radio phone-in programme. Why has the woman called? ATo criticise the famous.BTo express a different point of view.CTo sympathise with photographers.