多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题