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.
正确答案:B
答案解析:有
微信扫一扫手机做题