Database management Questions
Terms
undefined, object
copy deck
- 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. )