Oracle DBA Flashcards
What does PDB stand for?
Pluggable Database
What does CDB stand for?
Multitenant Container Database
What does OUI stand for?
Oracle Universal Installer
What does DBCA stand for?
Oracle Database Configuration Assistant
What does DBUA stand for?
Oracle Database Upgrade Assistant
What does EM Express stand for?
Oracle Enterprise Manager Database Express
What does OLTP stand for?
High Security Online Transaction Processing
What does SME stand for?
Small and Medium Sized Enterprises
What does Oracle ASM stand for?
Oracle Automatic Storage Management
What does SID stand for?
System Identifier
What does OSDBA stand for?
Operating System Database Administrator Group
What does OMF stand for?
Oracle Managed Files
What does LGWR stand for?
Log Writer Process
What is the Archive Log also known as?
The Archive Redo Log
What is the Archive Redo Log also known as?
The Archive Log
What is Archiving?
The process of turning online redo log files into archived log files.
What does SGA stand for?
System Global Area
What is SGA (System Global Area)?
A group of shared memory dedicated to an oracle instance.
What does PGA stand for?
Program Global Area
What is PGA (Program Global Area)?
A memory region that contains data and control information for a server process.
Is PGA (Program Global Area) memory shared or unshared?
Unshared
When is PGA (Program Global Area) memory created?
It is created by Oracle Database when a server process in started.
To what process in PGA (Program Global Area) memory exclusive to?
The server process.
What two types of processes allocate their own PGA (Program Global Area) memory?
Server processes, and background processes
