CIS305 Chapter 1 Quiz

8 September 2022
4.7 (114 reviews)
43 test answers

Unlock all answers in this set

Unlock answers (39)
question
Redundant data
answer
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