Oracle Database Architecture — components?
Memory structures and background processes.
Database Instance — definition?
Set of processes and memory managing the database.
Database Schema — role?
Defines logical structure and objects owned by a user.
Relational Model — introduced by?
Dr. Edgar Codd.
Table — function?
Stores data in rows and columns.
Primary Key — purpose?
Uniquely identifies each record.
Foreign Key — role?
Establishes relationships between tables.
Tablespace — what?
Logical container grouping related objects.
Segment — composed of?
Multiple extents allocated for an object.
Extent — definition?
Continuous storage block for a segment.
Data Block — smallest unit?
Physical unit of data storage.
Multitenancy — introduced in?
Oracle 12c.
Container Database — contains?
Root and pluggable databases (PDBs).
PDB — stands for?
Pluggable Database.
User Process — role?
Client-side process executing SQL commands.
Server Process — function?
Handles requests and performs database operations.
Dedicated Server — serves?
One user process exclusively.
Shared Server — serves?
Multiple user processes with fewer server processes.
SGA — what?
Shared memory area for database data and control info.
Library Cache — stores?
Parsed SQL and PL/SQL code.
Control Files — record?
Database structure and metadata.
Redo Log Files — record?
All changes made to the database.
Testez vos connaissances avec un QCM de 11 questions sur Oracle Database Fundamentals.
1. How can a database administrator utilize knowledge of Oracle Database Architecture to optimize database performance during routine maintenance?
2. How do primary keys and foreign keys differ in a relational database model?
Révisez le cours complet dans la fiche de révision de Oracle Database Fundamentals.
Voir la fiche →Intelligence Artificielle
Bases de données
Bases de données
Bases de données
Importe ton cours et l'IA génère des flashcards en 30 secondes.
Générateur de flashcards