MIS 3300 Questions with Correct Answers
data dictionary Correct Answer-stores definitions, such as data types for
fields, default values, and validation rules for data in each field.
data hierarchy Correct Answer-the structure and organization of data,
which involves fields, records, and files.
data mart Correct Answer-usually a smaller version of a data warehouse,
used by a single department or function.
data model Correct Answer-determines how data is created, represented,
organized, and maintained. It usually contains data structure, operations,
and integrity rules.
data warehouse Correct Answer-a collection of data from a variety of
sources used to support decision-making applications and generate
business intelligence.
data-driven Web site Correct Answer-acts as an interface to a database,
retrieving data for users and allowing users to enter data in the database.
Data-mining analysis Correct Answer-used to discover patterns and
relationships.
database Correct Answer-a collection of related data that is stored in a
central location or in multiple locations.
, database administrator (DBA) Correct Answer-found in large
organizations, design and set up databases, establish security measures,
develop recovery procedures, evaluate database performance, and add
and fine-tune database functions.
database management system (DBMS) Correct Answer-software for
creating, storing, maintaining, and accessing database files. A DBMS
makes using databases more efficient.
distributed database management system (DDBMS) Correct Answer-
stores data on multiple servers throughout an organization.
Extraction, transformation, and loading (ETL) Correct Answer-the
processes used in a data warehouse. It includes extracting data from
outside sources, transforming it to fit operational needs, and loading it
into the end target (database or data warehouse)
foreign key Correct Answer-a field in a relational table that matches the
primary key column of another table. It can be used to cross-reference
tables.
fragmentation Correct Answer-addresses how tables are divided among
multiple locations. There are three variations: horizontal, vertical, and
mixed
data dictionary Correct Answer-stores definitions, such as data types for
fields, default values, and validation rules for data in each field.
data hierarchy Correct Answer-the structure and organization of data,
which involves fields, records, and files.
data mart Correct Answer-usually a smaller version of a data warehouse,
used by a single department or function.
data model Correct Answer-determines how data is created, represented,
organized, and maintained. It usually contains data structure, operations,
and integrity rules.
data warehouse Correct Answer-a collection of data from a variety of
sources used to support decision-making applications and generate
business intelligence.
data-driven Web site Correct Answer-acts as an interface to a database,
retrieving data for users and allowing users to enter data in the database.
Data-mining analysis Correct Answer-used to discover patterns and
relationships.
database Correct Answer-a collection of related data that is stored in a
central location or in multiple locations.
, database administrator (DBA) Correct Answer-found in large
organizations, design and set up databases, establish security measures,
develop recovery procedures, evaluate database performance, and add
and fine-tune database functions.
database management system (DBMS) Correct Answer-software for
creating, storing, maintaining, and accessing database files. A DBMS
makes using databases more efficient.
distributed database management system (DDBMS) Correct Answer-
stores data on multiple servers throughout an organization.
Extraction, transformation, and loading (ETL) Correct Answer-the
processes used in a data warehouse. It includes extracting data from
outside sources, transforming it to fit operational needs, and loading it
into the end target (database or data warehouse)
foreign key Correct Answer-a field in a relational table that matches the
primary key column of another table. It can be used to cross-reference
tables.
fragmentation Correct Answer-addresses how tables are divided among
multiple locations. There are three variations: horizontal, vertical, and
mixed
