Examine the statement:
Create synonym emp for hr.employees;
What happens when you issue the statement?
A.
An error is generated.
B.
You will have two identical tables in the HR schema with different names.
C.
You create a table called employees in the HR schema based on you EMP table.
D.
You create an alternative name for the employees table in the HR schema in your own schema.
ANS : B only
B is wrong because, you created a synonym not a table.
Sorrry…its D
What happen if you don’t have grants of HR schema? option “A” could be correct, or not?
Since details were not given we assume that permissions were correctly accorded.
select round(156.00,-2)
from dual;
plz explain the process..rep asap..
200
D is the only one Correct Answer.