BMGT 301 Exam 2 ACTUAL UPDATED
Exam Questions and CORRECT Answers
Database - CORRECT ANSWER - single table or collection of related tables
database management systems - CORRECT ANSWER - software for creating,
maintaining, and manipulating data
Structured query language (SQL) - CORRECT ANSWER - used to create and manipulate
databases; it is non-procedural language; it is declarative language
database hierarchy - CORRECT ANSWER - bit-->byte-->field-->record--> file--
>database
problems with the traditional file environment - CORRECT ANSWER - -data redundancy
-data-inconsistency
-poor security
-lack of data sharing and availability
data definition language - CORRECT ANSWER - specifies structure of database content,
used to create tables and define characteristics of fields
data dictionary - CORRECT ANSWER - automated or manual file storing definitions of
data elements and their characteristics
data manipulation language - CORRECT ANSWER - used to add, change, delete, retrieve
data from database
database - CORRECT ANSWER - group of related files
, file - CORRECT ANSWER - group of RECORDS of the same type
record - CORRECT ANSWER - group of related fields
field - CORRECT ANSWER - group of words or numbers
-entity (person, place, or thing)
-attribute: each characteristic, or quality, describing entity
attribute example - CORRECT ANSWER - attribute date/ grade which belongs to an
entity
201 of BMGT 201
Problems with the traditional file environment (files maintained separately by different
departments) - CORRECT ANSWER - --Data redundancy:
Presence of duplicate data in multiple files
--Data inconsistency:
Same attribute has different values
--Poor security
--Lack of data sharing and availability
how does database help organize data? - CORRECT ANSWER - Serves many applications
by centralizing data and controlling redundant data
how does DBMS solve issues with traditional file environment? - CORRECT ANSWER -
-Controls redundancy
-Eliminates inconsistency
-Uncouples programs and data
Exam Questions and CORRECT Answers
Database - CORRECT ANSWER - single table or collection of related tables
database management systems - CORRECT ANSWER - software for creating,
maintaining, and manipulating data
Structured query language (SQL) - CORRECT ANSWER - used to create and manipulate
databases; it is non-procedural language; it is declarative language
database hierarchy - CORRECT ANSWER - bit-->byte-->field-->record--> file--
>database
problems with the traditional file environment - CORRECT ANSWER - -data redundancy
-data-inconsistency
-poor security
-lack of data sharing and availability
data definition language - CORRECT ANSWER - specifies structure of database content,
used to create tables and define characteristics of fields
data dictionary - CORRECT ANSWER - automated or manual file storing definitions of
data elements and their characteristics
data manipulation language - CORRECT ANSWER - used to add, change, delete, retrieve
data from database
database - CORRECT ANSWER - group of related files
, file - CORRECT ANSWER - group of RECORDS of the same type
record - CORRECT ANSWER - group of related fields
field - CORRECT ANSWER - group of words or numbers
-entity (person, place, or thing)
-attribute: each characteristic, or quality, describing entity
attribute example - CORRECT ANSWER - attribute date/ grade which belongs to an
entity
201 of BMGT 201
Problems with the traditional file environment (files maintained separately by different
departments) - CORRECT ANSWER - --Data redundancy:
Presence of duplicate data in multiple files
--Data inconsistency:
Same attribute has different values
--Poor security
--Lack of data sharing and availability
how does database help organize data? - CORRECT ANSWER - Serves many applications
by centralizing data and controlling redundant data
how does DBMS solve issues with traditional file environment? - CORRECT ANSWER -
-Controls redundancy
-Eliminates inconsistency
-Uncouples programs and data
