A synonym for chloroform is（）...

第1题

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

A、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、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、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、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、E.Scott cannot create a synonym because synonyms can be created only for tables. F、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.

点击查看答案

第2题

[单选题] 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.

点击查看答案

第3题

[] 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、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、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、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、D. Scott cannot create a synonym because synonyms can be created only for tables. E、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.

点击查看答案

第4题

[单选题] 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.

点击查看答案

第5题

[单选题] 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_vu B、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_vu F、CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;

点击查看答案

第6题

[单选题] 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_vu B、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_vu F、CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;

点击查看答案

第7题

[单选题] Which statement is true regarding synonyms?（）

A、Synonyms can be created only for a table B、Synonyms are used to reference only those tables that are owned by another user C、A public synonym and a private synonym can exist with the same name for the same table D、The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid

点击查看答案

第8题

[] 在Oracle中，你以SYSDBA登录，CUSTOMER表位于Mary用户方案中，下面哪条语句为数据库中的所有用户创建CUSTOMER表的同义词（）。

A、A.CREATE PUBLIC SYNONYM cust ON mary.customer B、B.CREATE PUBLIC SYNONYM cust FOR mary.customer C、C.CREATE SYNONYM cust ON mary.customer FOR PUBLIC D、D.不能创建CUSTOMER的公用同义词

点击查看答案

第9题

[单选题] The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?（）

A、CREATE SYNONYM ord FOR orders; This command is issued by OE B、CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE C、CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator D、CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator

点击查看答案

A synonym for chloroform is（）.

请使用微信扫码支付