Set - 2

Question 16 :

Does a Before form trigger fire when the parameter form is suppressed?

Answer :

Yes.


Question 17 :

What is SGA?

Answer :

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 18 :

What is a shared pool?

Answer :

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 19 :

What is mean by Program Global Area (PGA)?

Answer :

It is area in memory that is used by a single Oracle user process.


Question 20 :

What is a data segment?

Answer :

Data segment are the physical areas within a database block in which the data associated with tables and clusters are stored.