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
Reading...
Front

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

image

Play button

image

Play button

image

Progress

1/30

Click to flip

30 Cards in this Set

  • Front
  • Back
  • 3rd side (hint)
The physical files that reside on the system and the logical pieces such as the database schema are called?
Database
This is the method used to access the data and consists of processes and system memory?
instance
The physical layer of the database consists of these 3 file types?
data files, redo log files, control files.
This information is 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 files
If this info is lost, you cannot recover the system.
One or more of these contain information used to start an instance, such as the location of datafiles and redo log files.
control files
Every time the system is modified, it is recorded here.
One or more store the information contained in the database.
datafiles
The information for a single table can span many of these or many tables can share a set.
The logical layer of the Oracle Database consists of?
tablespace and database schema
consists of items such as tables, clusters, indexes, views, stored procedures, database triggers, sequences, and so on
database schema
is divided into one or more logical pieces known as this?
tablespace
used to logically group data together
Contains information about tables, indexes, clusters, etc.
data dictionary
Tablespace where the data dictionary is kept?
system
consist of structures such as tables, clusters, indexes, views, stored procedures, database triggers, and sequences.
schema objects
Consists of name and rows and columns of data, is the basic logical storage unit in the Oracle database?
table
is 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.
cluster
Because of the structure of this, related data requires much less I/O overhead if accessed simultaneously.
Structure created to help retrieve data more quickly and efficiently
index
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.
view
can be queried, updated, and deleted as a table without restriction.
predefined SQL query that is stored in the data dictionary designed to allow more efficient queries
stored procedures
can reduce the amount of information that must be passed to the RDBMS and thus reduce network traffic and improve performance.
a procedure that is run automatically when an event occurs.
trigger
The space used to store data is controlled by the use of these 3 logical structures?
data blocks, extents, segments
This data structure consists of data blocks and is used to minimize the amount of wasted (empty) storage?
extents
As more and more data is entered, the number of extents used to store that data can grow or shrink as necessary
This data structure is a set of extents used to store a particular type of data?
segments
The smallest unit of storage in an Oracle database.
data blocks
in most systems is 2KB
List the 4 types of segments
data, index, rollback, temporary
This consists of the Oracle processes, including user and background processes, and shared memory necessary to access information in the database.
instance
The 2 basic memory structure associated with Oracle are?
sga and pga
shared memory region used to store data and control information for one Oracle instance.
sga
is allocated when the Oracle instance starts and is deallocated when the Oracle instance shuts down
The information in the SGA consists of these three elements?
database buffer cache, redo log buffer and shared pool.
Stores a log of changes made to the database. It is used for instance recovery in the event of a system failure.
redo log buffers
stores the most recently used data blocks
database buffer
can contain dirty data blocks, clean blocks or blocks that have not been modified
modified data that has not yet been written to disk is referred to as? Blocks that have been written to disk since modification are?
dirty data blocks, clean blocks