There is a customer table in the schema that has a public synonym and you are granted all object privileges on it. You have a process_customer that processes customer information that is in the public synonym customer table. You have just created a new table called customer within your schema. Which statement is true?
A. Creating the table has no effect and procedure process_custoiner still access data from public synonym customer table.
B. If the structure of your customer table is the same as the public synonym customer table then the procedure process_customer is invalidated and gives compilation errors.
C. The structure of your customer table is entirely different from the public synonym customer table, then the procedure process_customer successfully recompiles and accesses your customer table.
D. If the structure of your customer table is the same as the public synonym customer table then the procedure process_custoiner successfully recompiles when invoked and accesses your customer table.
Answer: D
A. Creating the table has no effect and procedure process_custoiner still access data from public synonym customer table.
B. If the structure of your customer table is the same as the public synonym customer table then the procedure process_customer is invalidated and gives compilation errors.
C. The structure of your customer table is entirely different from the public synonym customer table, then the procedure process_customer successfully recompiles and accesses your customer table.
D. If the structure of your customer table is the same as the public synonym customer table then the procedure process_custoiner successfully recompiles when invoked and accesses your customer table.
Answer: D