BMGT 301 ACTUAL TEST QUESTIONS WITH VERIFIED ANSWERS COMPLETE EXAM REVIEW

BMGT 301 ACTUAL TEST QUESTIONS WITH
VERIFIED ANSWERS COMPLETE EXAM
REVIEW

●● database management systems
Answer: software for creating, maintaining, and manipulating data


●● Structured query language (SQL)
Answer: used to create and manipulate databases; it is non-procedural
language; it is declarative language


●● database hierarchy
Answer: bit-->byte-->field-->record--> file-->database


●● problems with the traditional file environment
Answer: -data redundancy
-data-inconsistency
-poor security
-lack of data sharing and availability


●● data definition language

,Answer: specifies structure of database content, used to create tables and
define characteristics of fields


●● data dictionary
Answer: automated or manual file storing definitions of data elements
and their characteristics


●● data manipulation language
Answer: used to add, change, delete, retrieve data from database


●● database
Answer: group of related files


●● file
Answer: group of RECORDS of the same type


●● record
Answer: group of related fields


●● field
Answer: group of words or numbers
-entity (person, place, or thing)
-attribute: each characteristic, or quality, describing entity

, ●● attribute example
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)
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?
Answer: Serves many applications by centralizing data and controlling
redundant data


●● how does DBMS solve issues with traditional file environment?
Answer: -Controls redundancy
-Eliminates inconsistency
-Uncouples programs and data