Cuestionario: Oracle Database Fundamentals — 11 preguntas

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

A. Configure user processes to directly access data files for faster data retrieval.

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

C. Disable background processes to reduce resource consumption during peak hours.

D. Reduce the size of data files to minimize disk usage and improve speed.

Answer: (B)

Explicación

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?

A. Primary keys are used for data retrieval, and foreign keys are used for data storage.

B. Both primary keys and foreign keys are used to uniquely identify records within the same table.

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

D. Both primary keys and foreign keys serve the same purpose in maintaining data integrity.

Answer: (C)

Explicación

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. A process that handles specific tasks such as writing modified data to disk, recovery, and resource management

B. A physical storage file that stores user data in the database

C. A user-level process that interacts directly with the database

D. A process responsible for managing user connections and executing SQL commands

Answer: (A)

Explicación

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?

A. It eliminates the need for physical data files.

B. It improves data access speed and recovery efficiency.

C. It decreases the number of background processes needed.

D. It makes the database immune to hardware failures.

Answer: (B)

Explicación

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?

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

B. It performs instance recovery and cleans temporary segments.

C. It signals checkpoints to synchronize data files and control files.

D. It writes data blocks from the buffer cache to data files.

Answer: (A)

Explicación

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?

A. Archive copies of redo log files for point-in-time recovery

B. Store the actual user and system data of the database

C. Maintain metadata about the database's physical structure

D. Record all changes made to the database for recovery purposes

Answer: (C)

Explicación

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. A continuous set of storage allocated to a segment

B. A collection of extents within a segment

C. The smallest unit of data storage in Oracle

D. A logical grouping of related tables

Answer: (C)

Explicación

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?

A. Oracle 12c

B. Oracle 11g

C. Oracle 19c

D. Oracle 10g

Answer: (A)

Explicación

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?

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

B. Server processes manage user connections and user processes perform database backups

C. User processes and server processes both perform database operations equally

D. User processes handle database operations and server processes initiate user requests

Answer: (A)

Explicación

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?

A. By allocating more memory to the Large Pool to improve user session performance.

B. By disabling the Redo Log Buffer to reduce memory usage during peak operations.

C. By increasing the size of the Data Dictionary Cache to store more object metadata.

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

Answer: (D)

Explicación

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?

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

B. Data files contain metadata about the database, whereas control files store the actual data.

C. Data files are used only for backup purposes, while control files store all operational data.

D. Data files and control files serve the same purpose but are located in different physical locations.

Answer: (A)

Explicación

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.