Oracle Interview Questions and Answers

Where is the external query executed at the client or the server?
At the server.

Where is a procedure return in an external pl/sql library executed at the client or at the server?
At the client.

What is coordination Event?
Any event that makes a different record in the master block the current record is a coordination causing event.

What is the difference between OLE Server & Ole Container?
An Ole server application creates ole Objects that are embedded or linked in ole Containers ex. Ole servers are ms_word & ms_excel. OLE containers provide a place to store, display and manipulate objects that are created by ole server applications. Ex. oracle forms is an example of an ole Container.

Oracle Interview Questions and Answers

Can a view based on another view?
Yes.

What are the advantages of views?
- Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table.
- Hide data complexity.
- Simplify commands for the user.
- Present the data in a different perspective from that of the base table.
- Store complex queries.

What is an Oracle sequence?
A sequence generates a serial list of unique numbers for numerical columns of a database's tables.

What is a synonym?
A synonym is an alias for a table, view, sequence or program unit.

What are the types of synonyms?
There are two types of synonyms private and public.

What is a private synonym?
Only its owner can access a private synonym.

What is a public synonym?