Which of the following is NOT an advantage of database systems?
Redundant data
Program-data independence
Better data quality
Reduced program maintenance
question
Database analysts
answer
________ do NOT concentrate on determining the requirements for the database component of an information system.
Database analysts
Systems analysts
Programmers
End Users
question
design
answer
Organizing the database in computer disk storage is done in the ________ phase.
design
maintenance
analysis
Implementation
question
providing an integrated development environment.
answer
All of the following are primary purposes of a database management system (DBMS) EXCEPT:
creating data.
updating data.
storing data.
providing an integrated development environment.
question
entity.
answer
A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n):
relationship.
object.
attribute.
entity.
question
application programs.
answer
In a file processing environment, descriptions for data and the logic for accessing the data are built into:
application programs.
database descriptors.
fields.
records.
question
a logical description of some portion of the database.
answer
A user view is:
what a user sees when he or she looks out the window.
a table or set of tables.
a logical description of some portion of the database.
a procedure stored on the server.
question
constraint.
answer
A rule that CANNOT be violated by database users is called a:
password
constraint.
program.
view.
question
analysis
answer
The SDLC phase in which every data attribute is defined, every category of data is listed and every business relationship between data entities is defined is called the ________ phase.
planning
design
analysis
Implementation
question
The desire to require programmers to write all file handling functionality
answer
Which of the following is NOT an objective that drove the development and evolution of database technology?
The need to provide greater independence between programs and data
The desire to manage increasing complex data types and structures
The desire to require programmers to write all file handling functionality
The need to provide ever more powerful platforms for decision support applications
question
repository.
answer
A knowledge base of information or facts about an enterprise is called a(n):
enterprise information system.
repository.
systems information unit.
database process.
question
failure to implement a strong database administration function.
answer
The most common source of database failures in organizations is:
lack of planning.
inadequate budget.
inadequate hardware.
failure to implement a strong database administration function.
question
prototyping.
answer
One of the most popular RAD methods is:
automated design.
structured walkthrough.
prototyping.
crafting.
question
Structured query language
answer
________ is a tool even non-programmers can use to access information from a database.
ODBC
Structured query language
ASP
Data manipulation query language
question
analysis
answer
The SDLC phase in which the detailed conceptual data model is created is the ________ phase.
planning
design
analysis
implementation
question
1960s.
answer
The period that can be considered a "proof of concept" time was the:
1950s.
1960s.
1970s.
1990s.
question
design
answer
Organizing the database in computer disk storage is done in the ________ phase.
design
maintenance
analysis
Implementation
question
user view
answer
A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.
enterprise view
reporting document
user view
user snapshot
question
data model.
answer
A graphical system used to capture the nature and relationships among data is called a(n):
XML data model.
hypertext graphi
relational database.
data model.
question
legacy
answer
Older systems that often contain data of poor quality are called ________ systems.
controlled
legacy
database
mainframe
question
80
answer
Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance.
40
25
60
80
question
implementation
answer
The SDLC phase in which database processing programs are created is the ________ phase.
planning
design
analysis
implementation
question
Internal
answer
The three-schema approach includes which of the following schemas?
Internal
Logical
Cross-functional
Dissecting
question
RAD
answer
An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called:
CASE
CAD
RAD
MST
question
Database management system (DBMS)
answer
Which of the following is software used to create, maintain, and provide controlled access to databases?
Network operating system
User view
Database management system (DBMS)
Attribute
question
logically
answer
A database is an organized collection of ________ related data
logically
physically
loosely
badly
question
END
answer
________ is the most popular RDMS data model notation.
ERD
END
DRE
RED
question
Improved responsiveness
answer
Which of the following is NOT a cost and/or risk of the database approach?
Specialized personnel
Cost of conversion
Improved responsiveness
Organizational conflict
question
Systems analysts
answer
________ analyze the business situation and identify the need for information and information services to meet the problems or opportunities of the business.
Programmers
Users
Systems analysts
Database analysts
question
workgroup.
answer
A relatively small team of people who collaborate on the same project is called a:
server group.
workgroup.
data collaborative.
typical arrangement.
question
Database Administration
answer
Which organizational function should set database standards?
Management
Application development
Technical services
Database Administration
question
server.
answer
A workgroup database is stored on a central device called a:
client.
server.
remote P
network.
question
a datamart.
answer
A data warehouse derives its data from:
on-line transactions.
various operational data sources.
reports.
a datamart.
question
relation
answer
Relational databases establish the relationships between entities by means of common fields included in a file called a(n):
entity
relationship
relation
association
question
End Users
answer
________ do NOT concentrate on determining the requirements for the database component of an information system.
Database analysts
Systems analysts
Programmers
End Users
question
metadata.
answer
Data that describe the properties of other data are:
relationships.
logical.
physical.
metadata.
question
file descriptions being stored in each database application.
answer
Program-data dependence is caused by:
file descriptions being stored in each database application.
data descriptions being stored on a server.
data descriptions being written into programming code.
data cohabiting with programs.
question
enterprise data modeling
answer
Database development begins with ________, which establishes the range and general contents of organizational databases.
database design
cross-functional analysis
departmental data modeling
enterprise data modeling
question
1970s.
answer
E. F. Codd developed the relational model in the:
1960s.
1970s.
1980s.
1990s.
question
processing logic.
answer
All of the following are properties of metadata EXCEPT:
data definitions.
processing logic.
rules or constraints.
data structures.
question
Relationships
answer
________ are established between entities in a well-structured database so that the desired information can be retrieve
Entities
Relationships
Lines
Ties
question
user interface.
answer
Languages, menus, and other facilities by which users interact with the database are collectively called a(n):
client.
user interface.
icon.
development environment.
question
Organizational conflict
answer
The need for consensus on data definitions is an example of which type of risk in the database environment?
Specialized personnel needs
Organizational conflict
Conversion costs
Legacy systems
Haven't found what you need?
Search for quizzes and test answers now
Quizzes.studymoose.com uses cookies. By continuing you agree to our cookie policy