Question

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.
CCREATE SYNONYM ord FOR Oe.orders. This command is issued by the
database administrator
Van (0) ENG 07:33 PM​

Answer 1

Answer:

please mark as brainliest answer

Explanation:

HTML5

FOR ORDERED LIST

<ol>

Answer 2

Answer: B: CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by

OE.

Explanation:

• We can create a synonym on the schema where the table is present

• OE needs the privilege "CREATE PUBLIC SYNONYM" from SYS, then it could able to create synonyms and grant HR access. Initially, it(OE) doesn't have that one.

About the Synonym:

• A synonym is an object of a database.

• It is an alternate name for an object.

• It can be created for TABLE or VIEW.

There are two types of synonyms PRIVATE and PUBLIC.

• PRIVATE SYNONYM CREATE SYNONYM:

• Is used to create a private synonym in a current schema, and can be accessed within that schema only.

CREATE SYNONYM synonym_name FOR object_name;

CREATE SYNONYM news_sym FOR news;

Go through the links below to know more about the "Database":

https://brainly.in/question/7324085?referrer=searchResults

https://brainly.in/question/17917517?referrer=searchResults

#SPJ3