OCP-1Z0-051 补充题库第22题 SYNONYM同义词_please choose the synonym(近义词) of “stanza” . ( ) a-CSDN博客

本文链接：https://blog.csdn.net/holly2008/article/details/33442687

本文全面概述了信息技术领域的多个细分技术领域，包括前端开发、后端开发、移动开发、游戏开发、大数据开发等，并深入探讨了各类技术的核心概念、应用实例及发展趋势。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一、原题

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?
SELECT * FROM ord;
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.

答案: D

二、题目翻译

ORDERS表是OE用户的，OE用户授予了SELECT权限给HR。
下面哪句创建同义词ORD的语句后，HR用户能执行下面的查询？
SELECT * FROM ord;
A.CREATE SYNONYM ord FOR orders; 在OE用户下执行这个命令。
B.CREATE PUBLIC SYNONYM ord FOR orders;在OE用户下执行这个命令。
C.CREATE SYNONYM ord FOR oe.orders;数据库管理员执行这个命令。
D.CREATE PUBLIC SYNONYM ord FOR oe.orders;数据库管理员执行这个命令。

三、题目解析

A选项不正确，这个命令执行后，HR用户可以使用SELECT * FROM oe.ord;查询。
B选项不正确，CREATE PUBLIC SYNONYM执行这个命令需要有权限。
C选项不正确，同A。
D选项正确，创建公共同义词后，其它用户查询不再需要带用户名。