CS 5200 DATABASE MANAGEMENT SYSTEMS NORTHEASTERN STUDY GUIDE | SQL PRACTICE
QUESTIONS AND ANSWERS | COMPLETE COURSE REVIEW
independence - correct answer ✔✔A database management systems supports and simplifies
application and data ___________.
Which of the following below are among the main objectives of a modern DBMS? Check all that
apply. - correct answer ✔✔security from unauthorized access, methods for manipulating data,
methods for defining data, recovery of data during failures, methods for retrieving data
Edger F. Codd - correct answer ✔✔IBM research scientist is credited with the invention of the
relational model for storing data and non-procedural methods for retrieving data
common drawbacks (disadvantages) of a file-based approach to storing data - correct answer
✔✔lack of insulation between application and data, frequent data inconsistency, no
enforcement of data integrity constraints, increased data redundancy
SQLite is a _________ database. - correct answer ✔✔relational
A database can be defined as a set or collection of ________ data from which users can
efficiently retrieve the desired information. - correct answer ✔✔related
________ is the main language used to define queries in relational database system and is
based on relational algebra. - correct answer ✔✔SQL
_______ and XPath is the main query mechanism for XML databases. - correct answer
✔✔Xquery
Which three of the following are the levels that are part of the three-schema architecture? -
correct answer ✔✔conceptual schema, external schema, internal schema
, The way that data is stored on disk devices and spread across devices, such as in RAID systems,
is known as the ___________ level. - correct answer ✔✔internal
The ________ level in database architecture describes what data is stored, the relationships
among the various kinds of data without concern how the data is actually stored in storage
devices. - correct answer ✔✔conceptual
The person responsible in an organization for, among other things, maintenance, security, and
recovery of databases is the _________. - correct answer ✔✔DBA
One of the oldest data models is the ________ data model which organizes data in a tree
structure in which child nodes are related to parent nodes. - correct answer ✔✔hierarchical
Which of the following is not a relational database management system? - correct answer
✔✔MongoDB
The DBMS ensures that after every update that the database is in a _______ state. - correct
answer ✔✔valid
SQL is both a data ______ and ______ language. - correct answer ✔✔definition, manipulation
In a centralized database system, the database, application code, and user interface are all on
the same computer or virtual machine while in a __________ architecture, the database resides
on a remote computer and is accessed over the network by application programs. - correct
answer ✔✔client/server
In which of the following types of databases is the data stored on multiple computers and
storage devices connected either through a SAN or a LAN? - correct answer ✔✔distributed
database
QUESTIONS AND ANSWERS | COMPLETE COURSE REVIEW
independence - correct answer ✔✔A database management systems supports and simplifies
application and data ___________.
Which of the following below are among the main objectives of a modern DBMS? Check all that
apply. - correct answer ✔✔security from unauthorized access, methods for manipulating data,
methods for defining data, recovery of data during failures, methods for retrieving data
Edger F. Codd - correct answer ✔✔IBM research scientist is credited with the invention of the
relational model for storing data and non-procedural methods for retrieving data
common drawbacks (disadvantages) of a file-based approach to storing data - correct answer
✔✔lack of insulation between application and data, frequent data inconsistency, no
enforcement of data integrity constraints, increased data redundancy
SQLite is a _________ database. - correct answer ✔✔relational
A database can be defined as a set or collection of ________ data from which users can
efficiently retrieve the desired information. - correct answer ✔✔related
________ is the main language used to define queries in relational database system and is
based on relational algebra. - correct answer ✔✔SQL
_______ and XPath is the main query mechanism for XML databases. - correct answer
✔✔Xquery
Which three of the following are the levels that are part of the three-schema architecture? -
correct answer ✔✔conceptual schema, external schema, internal schema
, The way that data is stored on disk devices and spread across devices, such as in RAID systems,
is known as the ___________ level. - correct answer ✔✔internal
The ________ level in database architecture describes what data is stored, the relationships
among the various kinds of data without concern how the data is actually stored in storage
devices. - correct answer ✔✔conceptual
The person responsible in an organization for, among other things, maintenance, security, and
recovery of databases is the _________. - correct answer ✔✔DBA
One of the oldest data models is the ________ data model which organizes data in a tree
structure in which child nodes are related to parent nodes. - correct answer ✔✔hierarchical
Which of the following is not a relational database management system? - correct answer
✔✔MongoDB
The DBMS ensures that after every update that the database is in a _______ state. - correct
answer ✔✔valid
SQL is both a data ______ and ______ language. - correct answer ✔✔definition, manipulation
In a centralized database system, the database, application code, and user interface are all on
the same computer or virtual machine while in a __________ architecture, the database resides
on a remote computer and is accessed over the network by application programs. - correct
answer ✔✔client/server
In which of the following types of databases is the data stored on multiple computers and
storage devices connected either through a SAN or a LAN? - correct answer ✔✔distributed
database
