单选题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. Wh
题目
单选题
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.