Oracle
1Z0-007 · Question #137
1Z0-007 Question #137: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #137. The question stem and answer options stay visible for context.
Question
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;
Options
- AYou obtain the results retrieved from the public synonym HR created by the database administrator.
- BYou obtain the results retrieved from the HR table that belongs to your schema.
- CYou get an error message because you cannot retrieve from a table that has the same name as a
- DYou obtain the results retrieved from both the public synonym HR and the HR table that belongs to
- EYou obtain the results retrieved from both the public synonym HR and the HR table that belongs to
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.