BCOR 330 EXAM 2 DSM QUESTIONS & ANSWERS
(chpt. 5)Which of the following is true of a query? - Answers -It is a request that is
executed to retrieve data from a database.
What does it mean when programmers say tables are not normalized? - Answers -The
tables have a format that can cause data integrity problems.
In a database, bytes are grouped into __________. - Answers -columns
Which of the following is an open source document-oriented DBMS that is used by
Craigslist and Foursquare because it does not require normalized data but manages
collections of documents that have a variety of structures? - Answers -MongoDB
Which of the following is true of representing relationships? - Answers -Each table is
normalized to have a single theme.
What characterizes a table that has not been normalized? - Answers -The tables have
a format that can cause data integrity problems.
Which of the following is true of reports? - Answers -They can be used to compute
values as they present data.
Which is NOT a function of a database management system? - Answers -Store data in
more than one location
Which company utilizes MongoDB because it does not require normalized data but
manages collections of documents that have a variety of structures? - Answers -
Craigslist
__________ is the process of converting poorly structured tables into two or more well-
structured tables. - Answers -Normalization
A __________ refers to a collection of data organized to serve many applications
efficiently by centralizing the data and controlling redundant data. - Answers -database
Which of the following is a request that is executed to retrieve data from a database? -
Answers -Query
In this diagram, which of the following best describes the relationship between the
"Adviser" and "Student" entities? - Answers -An N:M relationship
, Just as building architects create a blueprint before they start building, so, too, database
developers create a __________ before they start designing the database. - Answers -
data model
Which of the following best describes a primary key? - Answers -A column or group of
columns that identifies a unique row in a table
Keeping track of data is the primary purpose of a __________. - Answers -database
Which of the following gives an accurate description of a data model? - Answers -It is a
logical representation of the data in a database that describes the data and
relationships that will be stored in the database.
Lists of data involving a single theme can be stored in __________. - Answers -a
spreadsheet
Attributes of an entity-relationship data model are best used to describe __________. -
Answers -the characteristics of entities
Which step is NOT required in transforming a data model into a relational database
design? - Answers -Normalize each table to have multiple themes.
Which of the following is an important action you must take to ensure mistakes aren't
made in the development of databases? - Answers -Perform user reviews.
Which of the following describes a database application? - Answers -A collection of
forms, reports, queries, and programs that process a database
A __________ uncouples programs and data, enabling data to stand on its own. -
Answers -database management system
Which of the following describes the structure of a database? - Answers -Metadata
Which of the following best describes a row in a database? - Answers -A group of
columns
(chpt. 6)
Salesforce.com, iCloud, and Office 365 are examples of which of the following? -
Answers -SaaS
Which of the following protocols is used to move files over the Internet? - Answers -File
Transfer Protocol (FTP)
Which of the following is an advantage of the cloud? - Answers -Capital requirement
(chpt. 5)Which of the following is true of a query? - Answers -It is a request that is
executed to retrieve data from a database.
What does it mean when programmers say tables are not normalized? - Answers -The
tables have a format that can cause data integrity problems.
In a database, bytes are grouped into __________. - Answers -columns
Which of the following is an open source document-oriented DBMS that is used by
Craigslist and Foursquare because it does not require normalized data but manages
collections of documents that have a variety of structures? - Answers -MongoDB
Which of the following is true of representing relationships? - Answers -Each table is
normalized to have a single theme.
What characterizes a table that has not been normalized? - Answers -The tables have
a format that can cause data integrity problems.
Which of the following is true of reports? - Answers -They can be used to compute
values as they present data.
Which is NOT a function of a database management system? - Answers -Store data in
more than one location
Which company utilizes MongoDB because it does not require normalized data but
manages collections of documents that have a variety of structures? - Answers -
Craigslist
__________ is the process of converting poorly structured tables into two or more well-
structured tables. - Answers -Normalization
A __________ refers to a collection of data organized to serve many applications
efficiently by centralizing the data and controlling redundant data. - Answers -database
Which of the following is a request that is executed to retrieve data from a database? -
Answers -Query
In this diagram, which of the following best describes the relationship between the
"Adviser" and "Student" entities? - Answers -An N:M relationship
, Just as building architects create a blueprint before they start building, so, too, database
developers create a __________ before they start designing the database. - Answers -
data model
Which of the following best describes a primary key? - Answers -A column or group of
columns that identifies a unique row in a table
Keeping track of data is the primary purpose of a __________. - Answers -database
Which of the following gives an accurate description of a data model? - Answers -It is a
logical representation of the data in a database that describes the data and
relationships that will be stored in the database.
Lists of data involving a single theme can be stored in __________. - Answers -a
spreadsheet
Attributes of an entity-relationship data model are best used to describe __________. -
Answers -the characteristics of entities
Which step is NOT required in transforming a data model into a relational database
design? - Answers -Normalize each table to have multiple themes.
Which of the following is an important action you must take to ensure mistakes aren't
made in the development of databases? - Answers -Perform user reviews.
Which of the following describes a database application? - Answers -A collection of
forms, reports, queries, and programs that process a database
A __________ uncouples programs and data, enabling data to stand on its own. -
Answers -database management system
Which of the following describes the structure of a database? - Answers -Metadata
Which of the following best describes a row in a database? - Answers -A group of
columns
(chpt. 6)
Salesforce.com, iCloud, and Office 365 are examples of which of the following? -
Answers -SaaS
Which of the following protocols is used to move files over the Internet? - Answers -File
Transfer Protocol (FTP)
Which of the following is an advantage of the cloud? - Answers -Capital requirement
