IS 410 Exam 1 Questions and Answers Already Passed Latest Update 2025-2026
Database management involves all of the following EXCEPT: - Answers design web pages
a database is an organized collection of ____________ related data. - Answers logically
relational databases establish relationships between entities by means of common fields
included in a file called a(n): - Answers relation
A(n) ___________ is often developed by identifying a form or report that a user needs on a regular
basis. - Answers user view
A graphical system used to capture the nature and relationships among data is called a(n): -
Answers data model
A user view is: - Answers a logical description of some portion of the database
A major difference between data warehouses and transactional systems as compared to big
data is: - Answers the data is unstructured in big data systems
which organizational function should set database standards? - Answers Database
Administration
_________ is a tool even non-programmers can use to access information from a database. -
Answers Structured query language
The period that can be considered a "proof of concept" time was the: - Answers 1960's
a departmental multi-tiered client/server database is stored on a central device called a: -
Answers server
Organizations that utilize the file processing approach spend as much as ________ of their IS
development budget on maintenance. - Answers 80 Percent
Which of the following is NOT a cost and/or risk of the database approach? - Answers Improved
Responsiveness
The traditional methodology used to develop, maintain, and replace information systems is
called the: - Answers Systems Development Life Cycle
The SDLC phase in which every data attribute is defined, every category of data is listed, and
every business relationship between entities is defined is called the _________ phase. - Answers
Analysis
The SDLC phase in which database processing programs are created is the _______ phase. -
Answers Implementation
The SDLC phase in which the detailed conceptual data model is created is the _______ phase. -
, Answers Analysis
A data warehouse derives its data from: - Answers various operational data sources
Determining the structure of data and the relationships between data elements either right
before or at the time of use of the data is called: - Answers schema on write
Information is processed data. (T/F) - Answers True
Metadata are data that describe the properties of other data. (T/F) - Answers True
Databases were developed as the first application of computers to data processing. (T/F) -
Answers False
A relational database established the relationships between entities by means of a common
field. (T/F) - Answers True
Separation of metadata from application programs that use the data is called data
independence. (T/F) - Answers True
Data redundancy is used to establish relationships between data, but is never used to improved
database performance. (T/F) - Answers False
Redundancy increases the risk of inconsistent data. (T/F) - Answers True
A user view is how the user sees the data when it is produced. (T/F) - Answers False
The relational data model is no longer popular in the 21st century. (T/F) - Answers False
Although personal databases improve productivity, one risk is that data cannot be shared with
other users. (T/F) - Answers True
The most common way to support a group of individuals who work together on a project or
group of similar projects is with a multi-tiered client/server database. (T/F) - Answers True
In multi-tier database architectures, little functionality needs to be programmed into the client
application. (T/F) - Answers False
The logical representation of an organization's data is called a(n): - Answers entity-relationship
model
A good data definition will describe all of the characteristics of a data object EXCEPT: - Answers
who can delete data
A fact is an association between two or more: - Answers terms
Data modeling may be the most important part of the systems development process because: -
Answers data characteristics are important in the design of the programs and other systems
Database management involves all of the following EXCEPT: - Answers design web pages
a database is an organized collection of ____________ related data. - Answers logically
relational databases establish relationships between entities by means of common fields
included in a file called a(n): - Answers relation
A(n) ___________ is often developed by identifying a form or report that a user needs on a regular
basis. - Answers user view
A graphical system used to capture the nature and relationships among data is called a(n): -
Answers data model
A user view is: - Answers a logical description of some portion of the database
A major difference between data warehouses and transactional systems as compared to big
data is: - Answers the data is unstructured in big data systems
which organizational function should set database standards? - Answers Database
Administration
_________ is a tool even non-programmers can use to access information from a database. -
Answers Structured query language
The period that can be considered a "proof of concept" time was the: - Answers 1960's
a departmental multi-tiered client/server database is stored on a central device called a: -
Answers server
Organizations that utilize the file processing approach spend as much as ________ of their IS
development budget on maintenance. - Answers 80 Percent
Which of the following is NOT a cost and/or risk of the database approach? - Answers Improved
Responsiveness
The traditional methodology used to develop, maintain, and replace information systems is
called the: - Answers Systems Development Life Cycle
The SDLC phase in which every data attribute is defined, every category of data is listed, and
every business relationship between entities is defined is called the _________ phase. - Answers
Analysis
The SDLC phase in which database processing programs are created is the _______ phase. -
Answers Implementation
The SDLC phase in which the detailed conceptual data model is created is the _______ phase. -
, Answers Analysis
A data warehouse derives its data from: - Answers various operational data sources
Determining the structure of data and the relationships between data elements either right
before or at the time of use of the data is called: - Answers schema on write
Information is processed data. (T/F) - Answers True
Metadata are data that describe the properties of other data. (T/F) - Answers True
Databases were developed as the first application of computers to data processing. (T/F) -
Answers False
A relational database established the relationships between entities by means of a common
field. (T/F) - Answers True
Separation of metadata from application programs that use the data is called data
independence. (T/F) - Answers True
Data redundancy is used to establish relationships between data, but is never used to improved
database performance. (T/F) - Answers False
Redundancy increases the risk of inconsistent data. (T/F) - Answers True
A user view is how the user sees the data when it is produced. (T/F) - Answers False
The relational data model is no longer popular in the 21st century. (T/F) - Answers False
Although personal databases improve productivity, one risk is that data cannot be shared with
other users. (T/F) - Answers True
The most common way to support a group of individuals who work together on a project or
group of similar projects is with a multi-tiered client/server database. (T/F) - Answers True
In multi-tier database architectures, little functionality needs to be programmed into the client
application. (T/F) - Answers False
The logical representation of an organization's data is called a(n): - Answers entity-relationship
model
A good data definition will describe all of the characteristics of a data object EXCEPT: - Answers
who can delete data
A fact is an association between two or more: - Answers terms
Data modeling may be the most important part of the systems development process because: -
Answers data characteristics are important in the design of the programs and other systems
