Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
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
|
|