CIS305 Chapter 1 Quiz
a datamart.
A data warehouse derives its data from: on-line transactions. various operational data sources. reports. a datamart.
logically
A database is an organized collection of ________ related data logically physically loosely badly
data model.
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.
repository.
A knowledge base of information or facts about an enterprise is called a(n): enterprise information system. repository. systems information unit. database process.
entity.
A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n): relationship. object. attribute. entity.
workgroup.
A relatively small team of people who collaborate on the same project is called a: server group. workgroup. data collaborative. typical arrangement.
constraint.
A rule that CANNOT be violated by database users is called a: password constraint. program. view.
a logical description of some portion of the database.
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.
server.
A workgroup database is stored on a central device called a: client. server. remote P network.
user view
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
providing an integrated development environment.
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.
processing logic.
All of the following are properties of metadata EXCEPT: data definitions. processing logic. rules or constraints. data structures.
RAD
An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called: CASE CAD RAD MST
metadata.
Data that describe the properties of other data are: relationships. logical. physical. metadata.
enterprise data modeling
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
1970s.
E. F. Codd developed the relational model in the: 1960s. 1970s. 1980s. 1990s.
application programs.
In a file processing environment, descriptions for data and the logic for accessing the data are built into: application programs. database descriptors. fields. records.
user interface.
Languages, menus, and other facilities by which users interact with the database are collectively called a(n): client. user interface. icon. development environment.
legacy
Older systems that often contain data of poor quality are called ________ systems. controlled legacy database mainframe
prototyping.
One of the most popular RAD methods is: automated design. structured walkthrough. prototyping. crafting.
80
Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance. 40 25 60 80
design
Organizing the database in computer disk storage is done in the ________ phase. design maintenance analysis Implementation
file descriptions being stored in each database application.
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.
relation
Relational databases establish the relationships between entities by means of common fields included in a file called a(n): entity relationship relation association
implementation
The SDLC phase in which database processing programs are created is the ________ phase. planning design analysis implementation
analysis
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
analysis
The SDLC phase in which the detailed conceptual data model is created is the ________ phase. planning design analysis implementation
failure to implement a strong database administration function.
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.
Organizational conflict
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
1960s.
The period that can be considered a "proof of concept" time was the: 1950s. 1960s. 1970s. 1990s.
Internal
The three-schema approach includes which of the following schemas? Internal Logical Cross-functional Dissecting
Improved responsiveness
Which of the following is NOT a cost and/or risk of the database approach? Specialized personnel Cost of conversion Improved responsiveness Organizational conflict
Redundant data
Which of the following is NOT an advantage of database systems? Redundant data Program-data independence Better data quality Reduced program maintenance
The desire to require programmers to write all file handling functionality
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
Database management system (DBMS)
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
Database Administration
Which organizational function should set database standards? Management Application development Technical services Database Administration
Systems analysts
________ 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
Relationships
________ are established between entities in a well-structured database so that the desired information can be retrieve Entities Relationships Lines Ties
Database analysts
________ do NOT concentrate on determining the requirements for the database component of an information system. Database analysts Systems analysts Programmers End Users
End Users
________ do NOT concentrate on determining the requirements for the database component of an information system. Database analysts Systems analysts Programmers End Users
Structured query language
________ is a tool even non-programmers can use to access information from a database. ODBC Structured query language ASP Data manipulation query language
END
________ is the most popular RDMS data model notation. ERD END DRE RED
