Chapter 8 Flashcards
Facilitates the storage modification, and retrieval of this data
Database Management System (DBMS)
The data consists of a set of relational objects
Relational Database Management System (RDBMS)
The column or set of columns that uniquely identifies a row
Primary Key
States that the data value in the column exists in the other table
Foreign Key
The table where the column is a primary key
Parent Table
The table where the foreign key column exists
Child Table
Used by Oracle to enforce the parent-child relationship between tables
Constraints
Basic from of data storage that has columns and stores rows of data
Table
A stored query; no data storage space is occupied for view data
View
Used to summarize and store data
Materialized view
Use primary key and stores the table data in the index segment
Index-organized table
A group of tables that share the same storage blocks
Cluster
A stored rule to enforce data integrity
Constraint
Provides a mechanism for the continuous generation of numbers
Sequence
An alias for a database schema object
Synonym
A PL/SQL program unit that gets executed when an event occurs
Triggers
Are PL/SQL programs that can be used to create user-defined functions to return a value
Stored function
PL/SQL programs to define a business process
Stored procedure
A collection of procedures, functions, and other program constructs
Package
Can be created in Oracle to define business processes
Java
Used to communicate between databases to share data
Database link
Primary tool for an Oracle DBA to administer the database using SQL commands
SQL*Plus
A free GUI database-development tool; you can create and view the dtabase objects, make changes to the objects, run SQL statements, run PL/SQL programs, create and edit PL/SQL programs, and perform PL/SQL debugging
SQL Developer
An optional structure that is useful for locating data faster
Index
A web-based database management tool that is bundled with the Oracle 11g database
Oracle Enterprise Manager Database Control
Logical memory structures
Oracle instance
Physical file structures
Database
Key database components
Memory structures, Process structures, and storage structures
Instance and database together
Oracle server
2 types of processes that allow a user to interact with instance/database
User and Server process
Process of initiating and maintaining communication between user process and instance
Connection
Stores user-specific session information such as bind variables and session variables
Program Global Area (PGA)
The server process communicates when the user accesses the data in the database
System Global Area (SGA)
Caches the most recently used SQL statements that have been issued by database users
Shared pool (required SGA components)
Caches the data that has been most recently accessed by database users
Database buffer cache (required SGA components)
Stores transaction information for recovery purposes
Redo log buffer (required SGA components)
Caches the most recently used Java objects and application code when Oracle’s JVM option is used
Java pool (optional SGA components)
Caches data for large operations such as Recovery Manager(RMAN) backup and restore activities and Shared Server components
Large pool
Caches the data associated with queued message requests when Oracle’s Advanced Queuing option is used
Streams pool
This new area is introduced in Oracle 11g database and stores results of SQL queries and PL/SQL functions for better performance
Result cache
Memory in SGA is allocated in units of contiguous memory
Granules
Write the contents of the dirty buffers to the data files
Database writer process (DBWn)
Buffer blocks that need to be written to the data files
Dirty buffers
Dont contain any data or are free to be overwritten
Free buffers
Buffers that are currently being accessed or explicitly retained for future use
Pinned buffers
Writes the redo log buffer to redo log file on disk
LogWriter Process (LGWR)
Records checkpoint information in - Control file - Each data file header
Checkpoint Process (CKPT)
- Performs recovery at instance startup
- Cleans up unused temporary segments
System Monitor Process (SMON)
Performs process recovery when a user process fails
Process Monitor Process (PMON)
Recovers failed transactions that are distributed across multiple databases
Recoverer (RECO)
Copy redo log files to a designated storage device after a log switch has occurred
Archiver Processes (ARCn)
Performs manageability-related background tasks
MMON Memory Monitor
Performs frequent and lightweight manageability-related tasks
MMNL Memory Monitor Light
Performs automatic memory management tasks
MMAN Memory Manager
Runs user jobs used in batch processing
CJQ0 Job Queue Coordinator
Monitors the Streams Advanced Queuing message queues
QMNC AQ Coordinator
- What are the benefits of using the OFA Optimal Flexible Architecture standard for installing Oracle 11g?
A. Helps eliminate fragmentation of free space in the SYSTEM tablespace
C. Facilitates routine administrative tasks such as software backups
- You are trying to install Oracle 11g and the OUI Oracle Universal Installer prerequisite check failed. What should you do?
C. Correct the underlying issue, and retry the installation
- When installing Oracle 11g on the Linux platform, which file is created by executing the orainstRoot.sh script as root?
B. /etc/oraInst.loc
- Which component is not part of the Oracle instance?
C. Control file
- Which background process guarantees that committed data is saved even when the changes have not been recorded in data files?
C. LGWR
- Hired as DBA for company. Which of the following tasks might have been included in job description?
D. Any of the above
- Which of the following best describes RAC configuration?
A. One database, multiple instances
- Which component of the SGA contains the parsed SQL code?
C. Library cache
- Which are the tasks accomplished by the SMON process?
A. Performs recovery at instance startup
D. Coalesces contiguous free space in dictionary-managed tablespaces
- Choose the best statement from the options related to segments
B. A nonpartitioned table can have only one segment
- The Oracle Universal Installer prompts for which variable if not set?
C. ORACLE_BASE
- Which SGA component will you increase or configure so that RMAN backups are not using area from the shared pool?
D. Large pool
- When a user session is terminated, which processes are responsible for cleaning up and releasing locks?
D. PMON
- The LRU algorithm is used to manage what part of the Oracle architecture?
D. The shared pool and database buffer cache portions of the SGA
- 2 structures make up an Oracle server : an instance and db. Which of the following best describes the difference between both?
A. Instance consists of memory structures and processes
Database is composed of physical files
- Which of the following is the proper order of Oracle’s storage hierarchy from small to large?
B. Operating-system block, database block, extent, segment
17.
D. Determine which directory will be used for $ORACLE_HOME
- Oracle’s OFA model specifies a naming convention for all but which of the following?
A. Database name
Oracle Universal Installer is started by executing which program?
B. runInstaller
Script root.sh must be executed during installation process.
D. It copies files and sets permissions on files outside $ORACLE_HOME
