---

The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR; （）
A:You obtain the results retrieved from the public synonym HR created by the database administrator.
B:You obtain the results retrieved from the HR table that belongs to your schema.
C:You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
D:You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
E:You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.

---

出自：Oracle认证

显示答案