QCM : Oracle Database Fundamentals — 11 questions

Questions et réponses du QCM

1. How can a database administrator utilize knowledge of Oracle Database Architecture to optimize database performance during routine maintenance?

Configure user processes to directly access data files for faster data retrieval.
Adjust memory parameters to allocate more space to the SGA components based on workload patterns.
Disable background processes to reduce resource consumption during peak hours.
Reduce the size of data files to minimize disk usage and improve speed.

Adjust memory parameters to allocate more space to the SGA components based on workload patterns.

Explication

Adjusting memory parameters to allocate more space to the SGA components allows the database to better cache data and reduce disk I/O, which can improve performance during maintenance. Disabling background processes can lead to instability, and configuring user processes to access data files directly is not supported or advisable. Reducing data file sizes is not directly related to architecture management for performance optimization.

2. How do primary keys and foreign keys differ in a relational database model?

Primary keys are used for data retrieval, and foreign keys are used for data storage.
Both primary keys and foreign keys are used to uniquely identify records within the same table.
Primary keys uniquely identify each record, while foreign keys establish relationships between tables.
Both primary keys and foreign keys serve the same purpose in maintaining data integrity.

Primary keys uniquely identify each record, while foreign keys establish relationships between tables.

Explication

Primary keys are used to uniquely identify each record within a table, ensuring entity integrity. Foreign keys, on the other hand, reference primary keys in other tables to establish relationships and enforce referential integrity. This distinction is explicitly stated in the source excerpt.

3. What is a background process in an Oracle database?

A process that handles specific tasks such as writing modified data to disk, recovery, and resource management
A physical storage file that stores user data in the database
A user-level process that interacts directly with the database
A process responsible for managing user connections and executing SQL commands

A process that handles specific tasks such as writing modified data to disk, recovery, and resource management

Explication

A background process in an Oracle database is responsible for internal tasks such as writing dirty buffers to disk, recovery, and resource management, which are critical for maintaining database integrity and performance.

4. What is the consequence of properly designing and configuring the Memory Structures and SGA in an Oracle database?

It eliminates the need for physical data files.
It improves data access speed and recovery efficiency.
It decreases the number of background processes needed.
It makes the database immune to hardware failures.

It improves data access speed and recovery efficiency.

Explication

Proper design and configuration of the Memory Structures and SGA improve data access speed and recovery efficiency by ensuring that frequently accessed data and control information are cached in memory, reducing disk I/O and enhancing overall performance.

5. What is a key feature of the LGWR (Log Writer) background process in Oracle databases?

It writes redo log entries from the redo log buffer to log files.
It performs instance recovery and cleans temporary segments.
It signals checkpoints to synchronize data files and control files.
It writes data blocks from the buffer cache to data files.

It writes redo log entries from the redo log buffer to log files.

Explication

The LGWR process's primary function is to write redo log entries from the redo log buffer to the online redo log files, which is essential for maintaining transaction durability and enabling recovery.

6. What is the primary role of control files in an Oracle database?

Archive copies of redo log files for point-in-time recovery
Store the actual user and system data of the database
Maintain metadata about the database's physical structure
Record all changes made to the database for recovery purposes

Maintain metadata about the database's physical structure

Explication

Control files maintain metadata about the database's physical structure, which is essential for startup and recovery. They do not store data or record changes directly; instead, they hold information about data file locations, log files, and the current log sequence number, enabling the database to be reconstructed or recovered.

7. In the context of Oracle's logical storage structures, what does a data block represent?

A continuous set of storage allocated to a segment
A collection of extents within a segment
The smallest unit of data storage in Oracle
A logical grouping of related tables

The smallest unit of data storage in Oracle

Explication

A data block is the smallest unit of data storage in Oracle, directly corresponding to a physical block on disk. It is the fundamental unit in which data is stored and retrieved, making it essential for organizing and managing data at the physical level within logical storage structures.

8. When was the multitenancy architecture in Oracle Database first introduced?

Oracle 12c
Oracle 11g
Oracle 19c
Oracle 10g

Oracle 12c

Explication

The source explicitly states that Oracle 12c introduced a multitenancy architecture, making it the correct answer. The other options are previous or later versions that did not introduce this feature.

9. What is the primary role of user and server processes in an Oracle database?

User processes execute SQL commands and manage communication with the database, while server processes perform database operations
Server processes manage user connections and user processes perform database backups
User processes and server processes both perform database operations equally
User processes handle database operations and server processes initiate user requests

User processes execute SQL commands and manage communication with the database, while server processes perform database operations

Explication

User processes are responsible for executing SQL commands issued by users and managing communication with the server processes. Server processes perform the actual database operations, such as reading and writing data, based on requests from user processes. This division of roles ensures efficient management and execution of database tasks.

10. How can a database administrator use knowledge of SGA memory areas to improve database performance in practice?

By allocating more memory to the Large Pool to improve user session performance.
By disabling the Redo Log Buffer to reduce memory usage during peak operations.
By increasing the size of the Data Dictionary Cache to store more object metadata.
By monitoring and tuning the size of the Shared Pool and Buffer Cache to optimize SQL execution and data retrieval.

By monitoring and tuning the size of the Shared Pool and Buffer Cache to optimize SQL execution and data retrieval.

Explication

Monitoring and tuning the size of the Shared Pool and Buffer Cache allows the DBA to optimize SQL statement parsing, reduce disk I/O, and improve data access speed, directly enhancing database performance. The other options, while related to memory management, do not directly relate to the primary functions of the Shared Pool and Buffer Cache as described in the source.

11. How do data files and control files differ in their roles within an Oracle database?

Data files store the actual user and system data, while control files contain metadata about the database's structure.
Data files contain metadata about the database, whereas control files store the actual data.
Data files are used only for backup purposes, while control files store all operational data.
Data files and control files serve the same purpose but are located in different physical locations.

Data files store the actual user and system data, while control files contain metadata about the database's structure.

Explication

Data files store the actual user and system data within the database, such as tables and indexes, making them the primary storage units. Control files, however, contain metadata about the database's physical structure, like data file locations and log sequence numbers, which are essential for database startup, shutdown, and recovery operations.

Révisez avec les flashcards

Mémorisez les réponses avec 22 flashcards sur Oracle Database Fundamentals.

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.

Voir les flashcards →

Approfondir avec la fiche

Consultez la fiche de révision complète sur Oracle Database Fundamentals.

Voir la fiche →

Cours similaires

Introduction à l'Intelligence Artificielle Symbolique

Intelligence Artificielle

Introduction aux documents et sécurité en construction

Bases de données

Introduction à l'Informatique et IA

Introduction aux marchés publics et réglementations du bâtiment

Bases de données

Gestion des imprimantes Windows et PDF

Introduction aux bases de données relationnelles

Bases de données

Crée tes propres QCM

Importe ton cours et l'IA génère des QCM avec corrections en 30 secondes.

Générateur de QCM