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;
36 Cards in this Set
- Front
- Back
Data is stored within a database using..? |
a table structure
|
|
General categories can be found within..
|
columns
|
|
Distinct units of data are contained in..
|
rows
|
|
keys
|
used to identify distinct entries within a database and are used to access or manipulate rows of data.
|
|
Types of keys used to reference data within a database:
|
primary; foreign; secondary; candidate; composite; sort; and alternative.
|
|
What key is required for each row of a table?
|
Primary; as it provides tables and are not supported by all DBMSs.
|
|
Can be used to build relationships between tables; and are not supported by all DBMSs.
|
Foreign keys
|
|
What act as the intermediary for users and DBMSs?
|
Query languages. Provide users a way to retrieve and manipulate data from a database.
|
|
What are the different database models?
|
flat; hierarchical; network; and relational.
|
|
The most common relationships formed between tables in a relational database are..?
|
one-to-many.
|
|
Databases can be built to handle very active; high-volume query environments such as..
|
online transaction processing and POS environments.
|
|
Databases can be built to handle stagnant; low-volume query environments such as..
|
historical data warehouse or data support systems.
|
|
Two very important aspects of a DBMS..?
|
read consistency and query management.
|
|
Read consistency is dependent on a database's ability to manage ______ and refers to the ____ and _____ of data?
|
multiple processes; accuracy; reliability.
|
|
Read consistency is achieved through the use of?
|
efficient transaction processing; concurrency handling; and data-locking mechanisms.
|
|
The general query processing steps of a database are..
|
parsing; optimization; and execution of a SQL statement. |
|
Oracle's architecture has what two main components?
|
the instance and the database.
|
|
The instance begins with a user's ______ and includes the ______ _____ and ____ _____ of the application.
|
Connection; background processes; memory management.
|
|
The database component involves the ____ file structure?
|
physical.
|
|
MySQL's main architectural components include the what?
|
connection manager; query engine; and storage management engine.
|
|
The connection manager in MySQL handles what?
|
connections to the database.
|
|
The query manager in MySQL processes what?
|
SQL statements.
|
|
The storage engine in MySQL manages what for the application?
|
memory and storage.
|
|
The main components of SQL Server include what two engines?
|
relational and storage.
|
|
The relational engine in SQL Server involves what?
|
Query management; threads and processes; and the physical file structure.
|
|
The storage engine in SQL Server includes what?
|
buffer and memory management.
|
|
A field with values not chosen as a primary key; but can be used in cases where the primary key is not available.
|
alternate key.
|
|
A characteristic or variable that describes or further identifies an entity.
|
attribute
|
|
A portion of the SQL Server responsible for accessing data pages and updating the database.
|
buffer manager.
|
|
The area where data pages from a database are stored to minimize the need to read and write from the database file located on the hard disk.
|
buffer pool/buffer cache
|
|
The process of saving a duplicate of the requested data to another area of a system in hopes of saving resources and speeding up future requests for that same data.
|
caching
|
|
A field with values that meet the requirements for a primary key.
|
candidate key.
|
|
The component of a table that maintains a general category of information with similar datatypes.
|
column/field.
|
|
To make a change within a DBMS that is permanent and visible to other users.
|
commit
|
|
A group of two or more fields where their values can be combined to be used as a primary key.
|
composite key.
|
|
The simultaneous access of resources and data
|
concurrency |