Oracle Database Architecture
Test your knowledge of Oracle database internal components, memory structures, storage architecture, and configuration concepts including SGA, PGA, tablespaces, schemas, and instance modes.
Questions
Which of the following files in Oracle records the physical structure of a database?
- Data files
- Redo log files
- Control files
- None of these
Which of the following components of Oracle is a centralized repository of organizational data?
- Oracle database
- Oracle instance
- Oracle server
- None of these
Which of the following types of cursors is used by Oracle for each UPDATE, DELETE and INSERT SQL commands?
- Explicit cursor
- Implicit cursor
- % NOT FOUND
- None of these
Which of the following components of Oracle is a database object that groups logically related PL/SQL types, objects and subprograms?
- Database triggers
- Cursors
- Package
- None of these
Which of the following memory pools in system global area is used for handling large I/O requests of server processes?
- Java pool
- Streams pool
- Shared pool
- Large pool
Which of the following components of Program Global Area is a memory area used for operations such as Sorting, Hash-joins, Bitmap Merge and Bitmap create operations?
- Private SQL area
- Session memory
- SQL work area
- None of these
Which of the following Oracle instance modes maintains one-to-one ratio between user and server processes?
- Dedicated server mode
- Shared server mode
- Background processes
- None of these
___________ is a logical structure used to classify or group database objects.
- Database block
- Schema
- Extent
- None of these
Which of the following logical storage structures is a logical grouping of database objects?
- Tablespace
- Segment
- Extent
- None of these
Which of the following memory components of System Global Area is a circular buffer that stores all changes made in the database?
- Database buffer cache
- Redo log buffer
- Library cache
- None of these