Oracle
1Z0-007 · Question #126
Examine the statement: Create synonym emp for hr.employees; What happens when you issue the statement?
The correct answer is D. You create an alternative name for the employees table in the HR schema in your own schema. See the full explanation below for the reasoning.
Question
Examine the statement:
Create synonym emp for hr.employees; What happens when you issue the statement?
Options
- AAn error is generated.
- BYou will have two identical tables in the HR schema with different names.
- CYou create a table called employees in the HR schema based on you EMP table.
- DYou create an alternative name for the employees table in the HR schema in your own schema.
How the community answered
(41 responses)- A7% (3)
- B2% (1)
- C15% (6)
- D76% (31)
Community Discussion
No community discussion yet for this question.