Quiz 1

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.

An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called: • CASE. • CAD. • RAD. • MST.

RAD

A data model is a graphical system used to capture the nature and relationships among data. True or False

True

A data warehouse contains summarized and historical information. True or False

True

A modern database management system automates more of the backup and recovery tasks than a file system. True or False

True

A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory. True or False

True

An enterprise resource planning system integrates all functions of the enterprise. True or False

True

E. F. Codd developed the relational data model during the 1970s. True or False

True

In prototyping, implementation and maintenance activities are repeated as necessary until the product is correct. True or False

True

Information is processed data. True or False

True

Separation of metadata from application programs that use the data is called data independence. True or False

True

The systems development life cycle is the traditional methodology used to develop, maintain, and replace information systems. True or False

True

CASE is a class of tools that: • assists the database administrator in maintaining a database. • provides guidelines for the physical design of a database. • provides management reporting tools. • automates the design of databases and application programs.

automates the design of databases and application programs.

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

decision support.

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

entity.

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

processing logic.

Cost and complexity are just two of the disadvantages of database processing. True or False

True

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.

Because applications are often developed independently in file processing systems: • the data is always non-redundant. • 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.