ISDS 351 Exam 2 ACTUAL UPDATED
Exam Questions and CORRECT Answers
Within a SQL database, achieving the property of atomicity means that attributes _____.
- are not considered durable values
- can be altered by more than one user at a time
- can safely be inconsistent across the database
- are values that have no component parts - CORRECT ANSWER - are values that have
no component parts
How does data normalization improve the performance of relational databases?
- by reducing their required storage
space
- by delaying propagation of changes
- by reorganizing the data repeatedly
- by reducing data isolation - CORRECT ANSWER - by reducing their required storage
space
Mike chooses a DaaS arrangement for his small business because it reduces costs. Why is DaaS
less costly than the traditional alternative?
- promotional pricing intended to boost market presence
- no in-house database installation, maintenance, or monitoring
- no backup capabilities or security measures
- fixed database storage capacity - CORRECT ANSWER - no in-house database
installation, maintenance, or monitoring
, Sometimes a database can contain "bad data," meaning incomplete, incorrect, inaccurate, or
irrelevant records, which can be corrected or deleted through data cleansing.
False
True - CORRECT ANSWER - True
DBMSs are used primarily for modeling data.
True
False - CORRECT ANSWER - False
Which of the following statements is true of a database?
- It provides an essential foundation for an organization's knowledge management and artificial
intelligence systems.
- It is a collection of unstructured data.
- It is accessed only by an organization's database administrator and data administrator.
- It helps companies analyze information to identify new market opportunities. - CORRECT
ANSWER - It helps companies analyze information to identify new market opportunities.
Which process consists of one application program following a logical access path (LAP) and
then a DBMS following a physical access path (PAP)?
- access privilege definition
- data retrieval
- concurrency control
- data manipulation - CORRECT ANSWER - data retrieval
Which component of the data hierarchy is ranked just below the database and represents a
collection of similar entities?
Exam Questions and CORRECT Answers
Within a SQL database, achieving the property of atomicity means that attributes _____.
- are not considered durable values
- can be altered by more than one user at a time
- can safely be inconsistent across the database
- are values that have no component parts - CORRECT ANSWER - are values that have
no component parts
How does data normalization improve the performance of relational databases?
- by reducing their required storage
space
- by delaying propagation of changes
- by reorganizing the data repeatedly
- by reducing data isolation - CORRECT ANSWER - by reducing their required storage
space
Mike chooses a DaaS arrangement for his small business because it reduces costs. Why is DaaS
less costly than the traditional alternative?
- promotional pricing intended to boost market presence
- no in-house database installation, maintenance, or monitoring
- no backup capabilities or security measures
- fixed database storage capacity - CORRECT ANSWER - no in-house database
installation, maintenance, or monitoring
, Sometimes a database can contain "bad data," meaning incomplete, incorrect, inaccurate, or
irrelevant records, which can be corrected or deleted through data cleansing.
False
True - CORRECT ANSWER - True
DBMSs are used primarily for modeling data.
True
False - CORRECT ANSWER - False
Which of the following statements is true of a database?
- It provides an essential foundation for an organization's knowledge management and artificial
intelligence systems.
- It is a collection of unstructured data.
- It is accessed only by an organization's database administrator and data administrator.
- It helps companies analyze information to identify new market opportunities. - CORRECT
ANSWER - It helps companies analyze information to identify new market opportunities.
Which process consists of one application program following a logical access path (LAP) and
then a DBMS following a physical access path (PAP)?
- access privilege definition
- data retrieval
- concurrency control
- data manipulation - CORRECT ANSWER - data retrieval
Which component of the data hierarchy is ranked just below the database and represents a
collection of similar entities?
