An interactive command that can be used to dynamically control a user session for appropriate integrity measures is: a. rollback. b. rollforward. c. set autocommit. d. expunge.

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

A shared collection of logically related data designed to meet the information needs of multiple users in an organization best defines: a. application b. database c. information d. data group

UPDATE tablename ***** [WHERE conditionlist]; The _____ command replaces the ***** in the syntax of the UPDATE command, shown above. a. b. c. d.

When a. b. c. d. SET columnname = expression expression = columnname columnname = expression LET columnname = expression designing a database, you should _____. make sure that entities are in normal form before table structures are created create table structures then normalize the database only normalize the database when performance problems occur consider more important issues such as performance before normalizing

In the member of only one subtype. context of total completeness, in a(n) _____, every supertype occurrence is a a. foreign key constraint b. nonunique constraint c. overlapping constraint d. disjoint constraint

Which of the following is a true statement regarding a data store? a. Data can move directly from one data store to another data store. b. Data can move directly from a sink to a data store. c. A data store has a noun phrase label. d. Data can move from an outside source to a data store

When a regular entity type contains a multivalued attribute, one must: a. create a single relation with multiple lines for each instance of the multivalued attribute. b. create two new relations, one containing the multivalued attribute. c. create two new relations, both containing the multivalued attribute. d. none of the above

Referring to Figure below, which of the following is NOT true? a. A component is part of an item. b. A component is always used in only one item. c. A component can be part of an item. d. A component may be used in many items.

If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a _____ relationship a. self b. self-referring c. looping d. recursive

A(n) _____ specifies the number of instances of one entity that can be associated with each instance of another entity. a. degree b. cardinality constraint c. counter constraint d. limit

The complex organizational process through which computer-based information systems are developed and maintained best defines: a. information systems analysis and design b. joint application design c. prototyping d. none of the above

On a data flow diagram, you may: a. repeat data stores b. repeat sources/sinks c. repeat processes d. bothaandb

Techniques developed to keep the analysis effort minimal, yet still effective include: a. JAD b. interviewing c. observations d. quiz sessions