SQL INTERVIEW QUESTION & ANSWERS
Databases
Follow Us
TAGS
| 71. | Where are Jserv configuration files stored? |
|---|---|
| Jserv configuration files are stored in $IAS_ORACLE_ HOME/Apache/Jserv/etc. |
| 72. | What is SGA? |
|---|---|
| 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. |
| 73. | What is a snapshot? |
|---|---|
| Snapshots are read-only copies of a master table located on a remote node which is periodically refreshed to reflect changes made to the master table. |