Oracle Interview Questions and Answers
Question - 111 : - How can we reduce the network traffic?
Answer - 111 : - - Replication of data in distributed environment.
- Using snapshots to replicate data.
- Using remote procedure calls.
Question - 112 : - Differentiate simple and complex, snapshots ?
Answer - 112 : - - A simple snapshot is based on a query that does not contains GROUP BY clauses, CONNECT BY clauses, JOINs, sub-query or snashot of operations.
- A complex snapshots contain atleast any one of the above.
Question - 113 : - What are the Built-ins used for sending Parameters to forms?
Answer - 113 : - You can pass parameter values to a form when an application executes the call_form, New_form, Open_form or Run_product.
Question - 114 : - Can you have more than one content canvas view attached with a window?
Answer - 114 : - Yes. Each window you create must have atleast one content canvas view assigned to it. You can also create a window that has manipulated content canvas view. At run time only one of the content canvas views assign to a window is displayed at a time.
Question - 115 : - Is the After report trigger fired if the report execution fails?
Answer - 115 : - Yes.
Question - 116 : - Does a Before form trigger fire when the parameter form is suppressed?
Answer - 116 : - Yes.
Question - 117 : - What is SGA?
Answer - 117 : - The System Global Area in an Oracle database is the area in memory to facilitate the transfer of information between users. It holds the most recently requested structural information between users. It holds the most recently requested structural information about the database. The structure is database buffers, dictionary cache, redo log buffer and shared pool area.
Question - 118 : - What is a shared pool?
Answer - 118 : - The data dictionary cache is stored in an area in SGA called the shared pool. This will allow sharing of parsed SQL statements among concurrent users.
Question - 119 : - What is a data segment?
Answer - 119 : - Data segment are the physical areas within a database block in which the data associated with tables and clusters are stored.
Question - 120 : - What is mean by Program Global Area (PGA)?
Answer - 120 : - It is area in memory that is used by a single Oracle user process.