INMT 341 Exam 2 ACTUAL QUESTIONS
AND CORRECT ANSWERS
Application Programs - CORRECT ANSWERS programs written to
accomplish certain tasks
Application/System Programmers - CORRECT ANSWERS write
application programs that store, maintain, and/or use database data to
accomplish business and systems tasks
Attribute - CORRECT ANSWERS a quality or characteristic belonging
to or associated with someone or something
Big Data - CORRECT ANSWERS a term used to describe large
volumes of data. Can be structured, unstructured, or semi-structured
binary relationship - CORRECT ANSWERS A relationship between the
instances of two entity types.
Business Analytics Mindset - CORRECT ANSWERS promotes the
ability to use large volumes of all types and sources of data to provide business
insights
Candidate Keys - CORRECT ANSWERS more than one attribute from
which to choose
Cardinalities - CORRECT ANSWERS describe the nature of the
relationship between two entities by indicating how many instances of one
entity can be linked to each specific instance of another entity
, Cardinality Constraints - CORRECT ANSWERS the number of
instances of one entity that can or must be associated with each instance of
another entity
Composite Attribute - CORRECT ANSWERS can (and likely should) be
decomposed into several separate attributes.
Ex: Address
Conceptual Data Model - CORRECT ANSWERS represent the entities
or objects about which you want to collect data, and rules about the meaning
and interrelationships among these data objects.
Conceptual Modeling Steps - CORRECT ANSWERS 1. Understanding
the business process of interest
2. Identifying the entities of interest
3. Identifying the entity relationships
4. Adding cardinalities to relationships
Data Control Language (DCL) Commands - CORRECT ANSWERS it is
used by the database administrator (DBA) to protect the database from
corruption and security by controlling the rights and permission such as to grant
or to revoke privileges for accessing the database.
Data Definition Language (DDL) Commands - CORRECT ANSWERS
it defines the database schema and is used to create and modify the structure of
database objects in the database by creating, altering, and dropping tables and
views.
AND CORRECT ANSWERS
Application Programs - CORRECT ANSWERS programs written to
accomplish certain tasks
Application/System Programmers - CORRECT ANSWERS write
application programs that store, maintain, and/or use database data to
accomplish business and systems tasks
Attribute - CORRECT ANSWERS a quality or characteristic belonging
to or associated with someone or something
Big Data - CORRECT ANSWERS a term used to describe large
volumes of data. Can be structured, unstructured, or semi-structured
binary relationship - CORRECT ANSWERS A relationship between the
instances of two entity types.
Business Analytics Mindset - CORRECT ANSWERS promotes the
ability to use large volumes of all types and sources of data to provide business
insights
Candidate Keys - CORRECT ANSWERS more than one attribute from
which to choose
Cardinalities - CORRECT ANSWERS describe the nature of the
relationship between two entities by indicating how many instances of one
entity can be linked to each specific instance of another entity
, Cardinality Constraints - CORRECT ANSWERS the number of
instances of one entity that can or must be associated with each instance of
another entity
Composite Attribute - CORRECT ANSWERS can (and likely should) be
decomposed into several separate attributes.
Ex: Address
Conceptual Data Model - CORRECT ANSWERS represent the entities
or objects about which you want to collect data, and rules about the meaning
and interrelationships among these data objects.
Conceptual Modeling Steps - CORRECT ANSWERS 1. Understanding
the business process of interest
2. Identifying the entities of interest
3. Identifying the entity relationships
4. Adding cardinalities to relationships
Data Control Language (DCL) Commands - CORRECT ANSWERS it is
used by the database administrator (DBA) to protect the database from
corruption and security by controlling the rights and permission such as to grant
or to revoke privileges for accessing the database.
Data Definition Language (DDL) Commands - CORRECT ANSWERS
it defines the database schema and is used to create and modify the structure of
database objects in the database by creating, altering, and dropping tables and
views.
