BUS-S307 Midterm
Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance.
80 percent
All of the following are primary purposes of a database management system (DBMS) EXCEPT: A) creating data. B) updating data. C) storing data. D) providing an integrated development environment.
D) providing an integrated development environment.
Which of the following is the software that is used to create, maintain and provide controlled access to databases?
Database management system (DBMS)
What do we call the diagrams we draw to show entities and their attributes and relationships between those entities:
ER diagrams
Which of the following is NOT a cost and/or risk of the database approach?
Improved responsiveness
The need for consensus on data definitions is an example of which type of risk in the database environment?
Organizational conflict
For the businesses utilizing Big Data tools effectively, which one of the following options is the analytics method that is mostly used by many organizations in order to increase their business revenue?
Predictive analytics
Which of the following is NOT an advantage of database systems? Better data quality Program-data independence Redundant data Reduced program maintenance
Redundant data
In the 1980's, _________________became accepted as the standard language used to query databases.
Structured Query Language (SQL)
Which one of the following option is not part of the five Vs of big data?
Variety Veracity Volume Vitality
The datanode and namenode are respectively
Worker and master nodes
A user view is:
a logical description of some portion of the database.
In a file processing environment, descriptions for data and the logic for accessing the data are built into:
application programs / files
The SDLC phase in which diagrams are drawn to show entities and relationships is called the _______________ phase
conceptual
A graphical system used to capture the nature and relationships among data is called a(n):
data model
One application of data warehouses is
decision support
A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n):
entity
The most common source of database failures in organizations is:
failure to implement a strong database administration function.
T/F The conceptual model is always technology specific.
false
[True/False] Databases were developed as the first application of computers to data processing.
false
[True/False] Organizations that utilize the file processing approach spend only 20 percent of development time on maintenance.
false
[True/False] With the traditional file processing approach, each application shares data files, thus enabling much data sharing.
false
Program-data dependence is caused by:
file descriptors being stored in each application.
In a file processing system environment, descriptions for data and logic for accessing the data is built into:
files
What is the the signal that is sent by the datanode to the namenode after the regular interval in time to indicate its presence?
heartbeat
The SDLC phase in which data processing programs are coded and tested is called the _______________ phase
implementation
Older systems that often contain data of poor quality are called ________ systems.
legacy
Disadvantages of flat file processing systems include:
limited data sharing
A database is an organized collection of___________________related data.
logically
Data that describes the characteristics of other data is called:
metadata
With the database approach, data descriptions are stored in a central location known as a(n):
repository
TRUE OR FALSE: Systems Development Lifecycle (SDLC) is the traditional methodology used to design, develop, and maintain systems..
true
[True/False] Development starts from scratch with the traditional file processing approach because new file formats, descriptions, and file access logic must be designed for each new program.
true
[True/False] File processing systems have been replaced by database systems in most critical business applications today.
true
[True/False] In practice, databases today may contain either data or information.
true
[True/False] Information is processed data.
true
[True/False] Many of the disadvantages of file processing systems can also be limitations of databases.
true
[True/False] Metadata are data that describe the properties of other data.
true
[True/False] Unplanned duplicate data files are the rule rather than the exception in file processing systems
true
Because applications are often developed independently in file processing systems:
unplanned duplicate data files are the rule rather than the exception.
A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.
user view
A data warehouse derives its data from:
various operational data sources
