单选题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 MA

题目

单选题

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

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.

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.

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.

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.

Scott cannot create a synonym because synonyms can be created only for tables.

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.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

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

答案：B

解析：

作ask的宾语需用宾格me。

第2题：

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

正确答案:C

第3题：

Get up! Mary. Tom has () called you three times this morning.

A、yet

B、already

C、never

参考答案：B

第4题：

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

正确答案:B

第5题：

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 box
D、 use the @function @decimal to format the value in the field on the form that will display in the view

正确答案:C

第6题：

Emerson（）Transcendentalist.

A、called himself
B、did not like the term
C、never called himself
D、created the term

正确答案:C

第7题：

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.

正确答案:A,B

第8题：

Which command will create a group called ‘delivery’and set the administrators to john’ and ‘mary’?()

A.mkgroup -A=john,mary delivery

B.groupadd -A=john,mary delivery

C.mkgroup adms=john,mary delivery

D.groupadd adms=john,mary delivery

参考答案：C

第9题：

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.

正确答案:D

第10题：

Which command will create a group called ’delivery’ and set the administrators to ’john’ and ’mary’？（）

A、mkgroup -A=john，mary delivery
B、groupadd -A=john，mary delivery
C、mkgroup adms=john，mary delivery
D、groupadd adms=john，mary delivery

正确答案:C

Mary has a view called EMP_DEPT_LOC_VU that was created base

题目

相似问题和答案

更多相关问题

相关内容