ISM4212 – Quizzes and Answers Graded
A+
In SQL a ________ allows a question to be asked of the database and returns an
answer - Correct answer-query
A functional dependency in which one or more nonkey attributes are functionally
dependent on part, but not all, of the primary key is called a ________ dependency
- Correct answer-partial functional
A relation that contains no multi-valued attributes and has nonkey attributes solely
dependent on the primary key but contains transitive dependencies is in which
normal form? - Correct answer-2nd normal form
A two dimensional table is called a: - Correct answer-relation
A two tier database includes: - Correct answer-the database server tier and the
client/user tier
Common database development approaches include: - Correct answer-SDLC
(Systems Development Life Cycle), Prototyping and Agile
©COPYRIGHT 2025, ALL RIGHTS RESERVED 1
, GPA, major, and class standing are _________ of the STUDENT entity - Correct
answer-attributes
Which of the following are purposes of a database management system (DBMS)? -
Correct answer-storing data, creating data, and updating data
__________are established between entities in a database so that information can
be retrieved. - Correct answer-relationships
Relationship cardinality specifies how many of each entity type is allowed in a
relationship. - Correct answer-True
The use of data warehousing and business intelligence helps organizations
transform data, into information (and knowledge), and into decisions and finally
into actions - Correct answer-True
A data warehouse provides an integrated, company-wide view of high quality
information from various databases - Correct answer-True
The objective of business intelligence is to enable easy access to data (and models)
to provide business managers with the ability to conduct analysis for better
decision making. - Correct answer-True
©COPYRIGHT 2025, ALL RIGHTS RESERVED 2
A+
In SQL a ________ allows a question to be asked of the database and returns an
answer - Correct answer-query
A functional dependency in which one or more nonkey attributes are functionally
dependent on part, but not all, of the primary key is called a ________ dependency
- Correct answer-partial functional
A relation that contains no multi-valued attributes and has nonkey attributes solely
dependent on the primary key but contains transitive dependencies is in which
normal form? - Correct answer-2nd normal form
A two dimensional table is called a: - Correct answer-relation
A two tier database includes: - Correct answer-the database server tier and the
client/user tier
Common database development approaches include: - Correct answer-SDLC
(Systems Development Life Cycle), Prototyping and Agile
©COPYRIGHT 2025, ALL RIGHTS RESERVED 1
, GPA, major, and class standing are _________ of the STUDENT entity - Correct
answer-attributes
Which of the following are purposes of a database management system (DBMS)? -
Correct answer-storing data, creating data, and updating data
__________are established between entities in a database so that information can
be retrieved. - Correct answer-relationships
Relationship cardinality specifies how many of each entity type is allowed in a
relationship. - Correct answer-True
The use of data warehousing and business intelligence helps organizations
transform data, into information (and knowledge), and into decisions and finally
into actions - Correct answer-True
A data warehouse provides an integrated, company-wide view of high quality
information from various databases - Correct answer-True
The objective of business intelligence is to enable easy access to data (and models)
to provide business managers with the ability to conduct analysis for better
decision making. - Correct answer-True
©COPYRIGHT 2025, ALL RIGHTS RESERVED 2
