Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key


Play button


Play button




Click to flip

31 Cards in this Set

  • Front
  • Back
  • 3rd side (hint)
Method used to access the data and consists of processes and system memory is called?
one or more of these store the information contained in the database.
Two or more of these files hold information used for recovery in the event of a system failure.
redo log
One or more of these files contain information used to start an instance, such as the location of datafiles and redo log files.
control files
The information for a single table can span many of these or many tables can share a single set?
This stores a log of all changes made to the database and used in the event of a system failure to reapply changes that have been made and committed, but that might not have been made to the datafiles.
redo log
Oracle needs the information contained in these files to start the database instance. Every time the system is modified, it is recorded in these files
control files
consists of items such as tables, clusters, indexes, views, stored procedures, database triggers, sequences, and so on.
database schema
Is used to logically group data together. For example, you can create one of these for accounting and a separate one for purchasing.
A database is divided into one or more logical pieces called?
By using more than one of these per tablespace, you can spread data over many different disks to distribute the I/O load and improve performance.
This tablespace is where the data dictionary is kept.
As part of the process of creating the database, Oracle automatically creates this tablespace for you
What does the data dictionary contain?
information about tables, indexes, clusters, etc.
What is the collection of logical-structure objects such as tables, clusters, indexes, views, stored procedures, database triggers, and sequences referred to as?,
schema objects
consists of rows and columns of data and is the basic logical storage unit in the Oracle database. Columns are defined by name and data type. Stored within a tablespace; often, many of these share a tablespace.
Set of tables physically stored together as one table that shares a common column.
If data in two or more tables is frequently retrieved together based on data in the common column, using this can be quite efficient.
This is a structure created to help retrieve data more quickly and efficiently and is declared on a column or set of columns.
A window into one or more tables. It does not store any data; it presents table data.
It can be queried, updated, and deleted as a table without restriction.
transparently providing limited information from one table, or a set of information from several tables
can also be used to prevent some data from being accessed by the user or to create a join from multiple tables.
predefined SQL query that is stored in the data dictionary designed to allow more efficient queries
stored procedures
using these you can reduce the amount of information that must be passed to the RDBMS
a procedure that is run automatically when an event occurs.
the smallest unit of storage in an Oracle Database.
in most systems the size is 2KB
consist of data blocks and used to minimize the amount of wasted (empty) storage. Can grow or shrink as necessary.
many tablespaces can share the same storage space without preallocating the divisions between those tablespaces.
An Oracle database can use four types of segments
data, system, rollback and temporary
consists of the Oracle processes, including user and background processes, and shared memory necessary to access information in the database.
The 2 basic memory structures associated with Oracle are called
sga and pga
is a shared memory region used to store data and control information for one Oracle instance.
allocated when the Oracle instance starts and is deallocated when the Oracle instance shuts down.
The information in the SGA consists of three elements
database buffer cache, the redo log buffer, and the shared pool.
stores the most recently used data blocks.
database buffer cache
Database buffer cache containing modified data that has not yet been written to disk is referred to as? blocks that have not been modified, or blocks that have been written to disk since modification are referred to as?
dirty blocks, clean blocks
this buffer stores a log of changes made to the database.
redo log buffer
Area of the SGA that stores shared memory structures such as shared SQL statements and internal information. Consists of SQL area and the data-dictionary cache.
shared pool
important because an insufficient amount of memory allocated to the shared pool can cause performance degradation.