试题详情
- 单项选择题 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.
关注下方微信公众号，在线模考后查看
热门试题
- Examinethestructures
- Examine the structu
- You want to display
- What is necessary fo
- You need to produce
- What is true about u
- Examine the structu
- Which three are true
- You define a multipl
- Examine these state
- Which three are DATE
- Which two statements
- You need to design
- Which two tasks can
- Which best describes
- ExaminethedataoftheE
- Examine the structu
- You are granted the
- Evaluate the SQL st
- You need to create