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.