Asite Solutions Database Engineer Interview Questions and Answers

Data pump utility is used for fast data and metadata movement between databases.

• Used for high-speed data and metadata movement between databases

• Can be used to export and import data and metadata

• Provides parallelism and network-based export and import

• Can be used to move data between different Oracle database versions

• Can be used to move data between different operating systems

• Examples: expdp, impdp

SGA and PGA are memory structures used by Oracle Database to store data and metadata.

• SGA (System Global Area) is a shared memory area that stores data and control information for the entire database instance.

• PGA (Program Global Area) is a memory area that stores data and control information for a single server process.

• SGA is used to store shared data such as database buffers, shared SQL areas, and redo log buffers.

• PGA ...read more