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;
24 Cards in this Set
- Front
- Back
The units of data ordered from smallest to largest are
|
attribute, record, table, database
|
|
In a database design, the concept of "entity" is implemented most directly as a:
|
table
|
|
An attribute that uniquely identifies a record is which type of key?
|
Primary (Primary key: A field included in a database that assures that each instance of an entity is stored or retrieved accurately.)
|
|
The most common language used to interface with databases is
|
SQL.
|
|
A text-based language used to query and manipulate the contents of a relational database is:
|
SQL.
|
|
The administrator responsible for a firm's database resources is known by this acronym.
|
DBA (Chief information officer; the IT manager )
|
|
A data query system that is based on a graphical interface is:
|
QBE (Text-based system )Query by example (QBE): A capability of a DBMS that enables data to be requested by providing a sample or a description of the types of data we would like to see.
|
|
In conceptual data modeling, the database is viewed as a collection of entities and their:
|
relationships.
|
|
The process of making a complex database simpler, more efficient, and stable is:
|
normalization.
|
|
The process of examining a database to uncover hidden relationships is data:
|
mining.
|
|
Graphical software tools that provide complex analysis of data stored in a database are called:
|
OLAP. (OLAP server: The chief component of an OLAP system that understands how data is organized in the database and has special functions for analyzing the data.)
|
|
The process of providing an immediate automated response to the requests of users is:
|
OLTP. (OLTP: Online transaction processing )
|
|
The units of data ordered from smallest to largest are
|
attribute, record, table, database
|
|
In a database design, the concept of "entity" is implemented most directly as a:
|
table. Table: A collection of related records where each row is a record and each column is an attribute.
|
|
An attribute that uniquely identifies a record is which type of key?
|
Primary (Primary key: A field included in a database that assures that each instance of an entity is stored or retrieved accurately.)
|
|
The most common language used to interface with databases is
|
SQL.
|
|
A text-based language used to query and manipulate the contents of a relational database is:
|
SQL.
|
|
The administrator responsible for a firm's database resources is known by this acronym.
|
DBA (Database administrator: A person responsible for the development and management of the organization's databases.- Chief information officer; the IT manager )
|
|
A data query system that is based on a graphical interface is:
|
QBE (Text-based system )(Query by example (QBE): A capability of a DBMS that enables data to be requested by providing a sample or a description of the types of data we would like to see.)
|
|
In conceptual data modeling, the database is viewed as a collection of entities and their:
|
relationships.
|
|
The process of making a complex database simpler, more efficient, and stable is:
|
normalization.
|
|
The process of examining a database to uncover hidden relationships is data:
|
mining.
|
|
Graphical software tools that provide complex analysis of data stored in a database are called:
|
OLAP. (OLAP server: The chief component of an OLAP system that understands how data is organized in the database and has special functions for analyzing the data.)
|
|
The process of providing an immediate automated response to the requests of users is:
|
OLTP. (OLTP: Online transaction processing -Immediate automated responses to the requests from multiple concurrent transactions from customers. )
|