Database(Test 1-2)

Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance. 40 percent 25 percent 60 percent 80 percent

80 percent

The common types of entities are: strong entities. weak entities. associative entities. All of these.

All of these

Which of the following conditions should exist if an associative entity is to be created? All the relationships for the participating entities are many-to-many. The new associative entity has independent meaning. The new associative entity participates in independent relationships. All of these.

All of these

Which of the following criteria should be considered when selecting an identifier? Choose an identifier that is stable. Choose an identifier that will not be null. Choose an identifier that doesn't have large composite attributes. All of these.

All of these

Which of the following types of data can be stored in a database? Voice Letters Numbers All of these

All of these

Which of the following is an integrated decision support database with content derived from various operational databases? Corporate data structure Relational DBMS Data warehouse Client-server system

Data Warehouse

Which of the following is NOT a cost and/or risk of the database approach? Specialized personnel Cost of conversion Improved responsiveness Organizational conflict

Improved responsiveness

The three-schema approach includes which of the following schemas? Internal Logical Cross-functional Dissecting

Internal

Which of the following is not a suggestion by Salin regarding developing data names? Prepare a definition of the data. Keep insignificant or illegal words. Arrange the words in a meaningful, repeatable way. Assign a standard abbreviation for each word.

Keep insignificant or illegal words

Which organizational function should set database standards? -Management -Application development -Technical services -None of these

None of these

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

Organizational

An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called: Case Cad Rad MST

RAD

Which of the following is NOT an advantage of database systems? -Redundant data -Program-data independence -Better data quality -Reduced program maintenance

Redundant Data

Which of the following is NOT a good characteristic of a data name? Relates to business characteristics Readable Repeatable Relates to a technical characteristic of the system

Relates to a technical characteristic of the system

________ is a tool even non-programmers can use to access information from a database. -ODBC -Structured query language -ASP -Data manipulation query language

Structured query language

The traditional methodology used to develop, maintain and replace information systems is called the: -Enterprise Resource Model. -Systems Development Life Cycle. -Unified Model. -Systems Deployment Life Cycle.

Systems Development Life Cycle

Which of the following will interfere with access to operational databases? -Unstructured and unpredictable use of data -Predictable use of data -Efficient transaction processing systems -All of these

Unstructured and unpredictable use of data

a logical description of some portion of the database. -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.

a logical description of some portion of the database

Databases may be more expensive to maintain than files because of: -the need for specialized personnel. -the complexity of the database environment. -backup and recovery needs. -All of these.

all of these

A mutually exclusive relationship is one in which: an entity instance can participate in many different relationships. an entity instance can participate in only one of several alternative relationships. an entity instance can not participate in a relationship with another entity instance. None of these.

an entity instance can participate in only one of several alternative relationships.

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

analysis

In a file processing environment, descriptions for data and the logic for accessing the data are built into: application programs database programs fields records

application programs

An entity type name should be all of the following EXCEPT: concise. specific to the organization. as short as possible. a singular noun.

as short as possible

An entity that associates the instances of one or more entity types and contains attributes specific to the relationships is called a(n): associative entity. connecting entity. intersectional entity. All of these.

associative entity

A property or characteristic of an entity type that is of interest to the organization is called a(n): attribute. coexisting entity. relationship. cross-function.

attribute

A person's name, birthday, and social security number are all examples of: attributes. entities. relationships. descriptors.

attributes.

CASE is a class of tools that: -assist the database administrator in maintaining a database. -provide guidelines for the physical design of a database. -provide management reporting tools. -automate the design of databases and application programs.

automate the design of databases and application programs.

A ________ specifies the number of instances of one entity that can be associated with each instance of another entity. degree cardinality constraint counter constraint limit

cardinality constraint

An attribute that can be broken down into smaller parts is called a(n) ________ attribute. associative simple composite complex

composite

An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n): composite attribute. composite identifier. identifying attribute. relationship identifier.

composite identifier

A rule that CANNOT be violated by database users is called a: password. constraint. program. view.

constraint

A graphical system used to capture the nature and relationships among data is called a(n): -logical data model. -hypertext graphic. -ERD. -data model.

data model

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 management system

One application of data warehouses is: decision support shipping of information order processing file updating

decision support

The number of entity types that participate in a relationship is called the: number. identifying characteristic. degree. counter.

degree

An attribute that can be calculated from related attribute values is called a(n) ________ attribute. simple composite multivalued derived

derived

The total quiz points for a student for an entire semester is a(n) ________ attribute. derived mixed stored addressed

derived

Organizing the database in computer disk storage is done in the ________ phase. design maintenance analysis implementation

design

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

enterprise data modeling

Customers, cars, and parts are examples of: entities. attributes. cardinals. relationships.

entities

A person, place, object, event or concept about which the organization wishes to maintain data is called a(n): relationship. object. attribute. entity.

entity

The logical representation of an organization's data is called a(n): database model. entity-relationship model. relationship systems design. database entity diagram.

entity-relationship model.

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.

failure to implement a strong database administration function.

Program-data dependence is caused by: -file descriptors being stored in each application. -data descriptions being stored on a server. -data descriptions being written into programming code. -data cohabiting with programs.

file descriptors being stored in each application.

A(n) ________ is the relationship between a weak entity type and its owner. member chain identifying relationship jump path chain link

identifying relationship

The SDLC phase in which database processing programs are created is the ________ phase. planning design analysis implementation

implementation

Data processed in a way that increases a user's knowledge is: text. graphics. information. hyperlink.

information

Older systems that often contain data of poor quality are called ________ systems. -controlled -legacy -database -mainframe

legacy

One disadvantage of file processing systems is: -reduced data duplication. -program-data independence. -limited data sharing. -enforcement of integrity constraints.

limited data sharing

A database is an organized collection of ________ related data. logically physically loosely badly

logically

Business policies and rules govern all of the following EXCEPT: managing employees. creating data. updating data. removing data.

managing employees

A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship. optional unidirectional mandatory link mandatory one

mandatory one

A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship. one-to-one many-to-many one-to-many strong

many-to-many

Data that describe the properties of other data are: relationships logical physical none of these

none of these

Which of the following is an entity type on which a strong entity depends? Owner Member Attribute None of these

none of these

All of the following are properties of metadata EXCEPT: -data definitions. -processing logic. -rules or constraints. -data structures.

processing logic

One of the most popular RAD methods is: -automated design. -structured walkthrough. -prototyping. -crafting.

prototyping

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.

providing an integrated development environment

Relational databases establish the relationships between entities by means of common fields included in a file called a(n): entity. relationship. relation. association.

relation

________ are established between entities in a well-structured database so that the desired information can be retrieved. Entities Relationships Lines Ties

relationships

A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n): -index. -data warehouse. -repository. -database management system.

repository

A knowledge base of information on facts about an enterprise is called a(n): -enterprise information system. -repository. -systems information unit. -database process.

repository

With the database approach, data descriptions are stored in a central location known as a: server. mainframe. PC. repository.

repository

An attribute that must have a value for every entity (or relationship) instance is a(n): composite attribute. required attribute. optional attribute. multivalued attribute.

required attribute

A workgroup database is stored on a central device called a: -client. -server. -remote PC. -network.

server

Another word for a data definition is a(n) entity. relationship. structural assertion. composite key.

structural assertion

A simultaneous relationship among the instances of three entity types is called a ________ relationship. ternary tertiary primary binary

ternary

A value that indicates the date or time of a data value is called a: value stamp. time stamp. checkpoint. check counter.

time stamp

In an E-R diagram, there are ________ business rule(s) for every relationship. two three one no

two

A relationship between the instances of a single entity type is called a(n) ________ relationship. ternary primary binary unary

unary

Because applications are often developed independently in file processing systems: -the data is always nonredundant. -unplanned duplicate data files are the rule rather than the exception. -data can always be shared with others. -there is a large volume of file I/O.

unplanned duplicate data files are the rule rather than the exception

Languages, menus, and other facilities by which users interact with the database are collectively called a(n): -client. -user interface. -icon. -development environment.

user interface

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

user view

A data warehouse derives its data from: -online transactions. -various operational databases. -reports. -a datamart.

various operational databases

An entity type whose existence depends on another entity type is called a ________ entity. strong weak codependent variant

weak

A good data definition will describe all of the characteristics of a data object EXCEPT: subtleties. examples. who determines the value of the data. who can delete the data.

who can delete the data.

A relatively small team of people who collaborate on the same project is called a: server group. workgroup. data collaborative. typical arrangement.

workgroup