one (or more) columns of a table that are used to identify a row
What is a key
100
consists of a group of programs that manipulate the data within a database. It provides an interface between the database and the user, or the database and application programs.
What is a database management system
100
This provides a detailed description of each field and table in a database.
What is data dictionary
100
This is a very large database that holds important information from a variety of sources.
What is a data warehouse
100
this involves combining two or more tables...
What is joining!
200
A two-dimensional table that has specific characteristics
What is a relation
200
the manner in which data in a database is organized into sequential levels of detail.
What is data hierarchy
200
This is a graphical representation of the structure of a database.
What is schema
200
This refers to the process of extracting information from a data warehouse or data mart.
What is data mining
200
This is a collection of instructions and commands used to define and describe data and data relationships in a specific database.
What is data definition language
300
The table dimensions consist of rows [also called ______] and columns [also called ______]
What is records and attributes
300
a field in a table used to identify a record, such as Employee Number.
What is a database key?
300
This includes software and techniques for analyzing, maintaining, and manipulating data in a database.
What is database tools
300
This is a climate-controlled building or set of buildings that house the servers that store and deliver mission-critical information and services.
What is A data center
300
This is a small data warehouse, often developed for a specific person or purpose. It can be generated from a data warehouse using a database management system.
What is data mart
400
a primary key placed from one table into another
What is foreign key
400
what does DBMS stand for?
What is database management system
400
This is a popular data manipulation language used by the vast majority of database programmers and administrators for manipulating data to meet the needs of the users.
What is Structured Query Language
400
this is an example of what... SELECT ClientName, Debt
FROM Client
WHERE Debt>1000
What is structured query language
400
Distributed databases connect data at different locations via what?
What is telecommunications.
500
This takes available data stored in multiple locations and makes it appear as a single collection.
What is distributed database
500
a type of database that organizes data into multiple tables that are related by common fields.
What is a relational database
500
this is where a database entity is selected as an example of the criteria to be queried
What is query by example
500
This is a skilled and trained computer professional who directs all activities related to an organization’s database, including providing security from intruders.
What is a database administrator
500
This is a database that holds a duplicate set of frequently used data.