CMSC 461 Database Management
Systems Exam Questions With 100%
Verified Answers
Database Management System (DBMS) -
correct answer ✅collection of interrelated data and a set of
programs to access those data
database -
correct answer ✅collection of data contains information relevant
to an enterprise
primary goal of a DBMS -
correct answer ✅is to provide a way to store and retrieve database
information that is convenient and efficient.
Drawbacks of File Systems -
correct answer ✅Data redundancy and inconsistency, Difficulty in
accessing data,
Data isolation,
Integrity problems,
Atomicity problems, Concurrent-access anomalies, Security
problems
,CMSC 461 Database Management
Systems Exam Questions With 100%
Verified Answers
file-processing system -
correct answer ✅stores permanent records in various files, and it
needs different application programs to extract records from, and
add records to, the appropriate files
query -
correct answer ✅a statement requesting the retrieval of
information
Levels of Abstraction -
correct answer ✅physical - describes how a record is stored
logical - describes the data stored in the database and the
relationships among the data
view level - hide and/or modify aspects of data types as seen by
various users
Schema -
correct answer ✅logical structure of the database
entity -
correct answer ✅collection of basic objects
, CMSC 461 Database Management
Systems Exam Questions With 100%
Verified Answers
attributes -
correct answer ✅Entities are described in a database by a set of
relationship -
correct answer ✅an association among several entities
tuple -
correct answer ✅simply a sequence (or list) of values
superkey -
correct answer ✅a set of one or more attributes that, taken
collectively, allow us to identify uniquely a tuple in the relation
candidate keys. -
correct answer ✅minimal superkeys
primary key -
correct answer ✅candidate key that is chosen by the database
designer as the principal means of identifying tuples within a
relation
Systems Exam Questions With 100%
Verified Answers
Database Management System (DBMS) -
correct answer ✅collection of interrelated data and a set of
programs to access those data
database -
correct answer ✅collection of data contains information relevant
to an enterprise
primary goal of a DBMS -
correct answer ✅is to provide a way to store and retrieve database
information that is convenient and efficient.
Drawbacks of File Systems -
correct answer ✅Data redundancy and inconsistency, Difficulty in
accessing data,
Data isolation,
Integrity problems,
Atomicity problems, Concurrent-access anomalies, Security
problems
,CMSC 461 Database Management
Systems Exam Questions With 100%
Verified Answers
file-processing system -
correct answer ✅stores permanent records in various files, and it
needs different application programs to extract records from, and
add records to, the appropriate files
query -
correct answer ✅a statement requesting the retrieval of
information
Levels of Abstraction -
correct answer ✅physical - describes how a record is stored
logical - describes the data stored in the database and the
relationships among the data
view level - hide and/or modify aspects of data types as seen by
various users
Schema -
correct answer ✅logical structure of the database
entity -
correct answer ✅collection of basic objects
, CMSC 461 Database Management
Systems Exam Questions With 100%
Verified Answers
attributes -
correct answer ✅Entities are described in a database by a set of
relationship -
correct answer ✅an association among several entities
tuple -
correct answer ✅simply a sequence (or list) of values
superkey -
correct answer ✅a set of one or more attributes that, taken
collectively, allow us to identify uniquely a tuple in the relation
candidate keys. -
correct answer ✅minimal superkeys
primary key -
correct answer ✅candidate key that is chosen by the database
designer as the principal means of identifying tuples within a
relation
