question

the data base approach to data management is sometimes called the flat file approach

answer

false

question

the database management system provides a controlled environment for accessing the database

answer

true

question

to the user, data processing procedures for routine transactions, such as entering sales orders, appear to be identical in the database environment and in the traditional environment

answer

true

question

an important feature associated with the traditional approach to data management is the ability to produce ad hoc reports

answer

false

question

the data definition language is used to insert special database commands into application programs

answer

false

question

there is more than one conceptual view of the database

answer

false

question

in the database method of data management, access authority is maintained by systems programming

answer

false

question

the physical database is an abstract representation of the database

answer

false

question

a customer name and an unpaid balance is an example of a one-to-many relationship

answer

false

question

in the relational model, a data element is called a relation

answer

false

question

data normalization groups data attributes into tables in accordance with specific design objectives

answer

true

question

under the database approach, data is viewed as proprietary or owned by users

answer

false

question

the data dictionary describes all of the data elements in the database

answer

true

question

a join builds a new tables by creating links

answer

false

question

the deletion anomaly is the least important of the problems affecting unnormalized databases

answer

false

question

a deadlock is a phenomenon that prevents the processing of transactions

answer

true

question

timestamping is a control that is used to ensure database partitioning

answer

false

question

a lockout is a software control that prevents multiple users from simultaneous acces to data

answer

true

question

logical database design is the foundation of the conceptual design

answer

false

question

an entity is any physical thing about which the organization wishes to capture data

answer

false

question

an ER diagram is a graphical representation of a data model

answer

true

question

the term occurrence is used to describe the number of attributes or fields pertaining to a specific entity

answer

false

question

cardinality describes the number of possible occurrences in one table that are associated with a single occurrence in a related table

answer

true

question

a table in third normal form is free of partial dependencies, multiple dependencies and transitive dependencies

answer

false

question

improperly normalized databases are associated with three types of anomalies: the update anomaly, the insertion anomaly, and the deletion anomaly

answer

true

question

all of the following are basic data management tasks except

answer

data attribution

question

the task of searching the database to locate a stored record for processing is called

answer

data retrieval

question

which of the following is not a problem usually associated with the flat-file approach to data management?

answer

restricting access to data to the primary user

question

which characteristic is associated with the database approach to data management

answer

data sharing

question

which characteristic is not associated with the database approach to data management?

answer

the inability to determine what data is available

question

the textbook refers to four interrelated components of the database concept. which of the following is not one of the components?

answer

the conceptual database

question

which of the following is not a responsibility of the database management system?

answer

ensure that the internal schema and external schema are consistent

question

a description of the physical arrangement of records in the database is

answer

the internal view

question

which of the following may provide many distinct views of the database

answer

the user view

question

users access the database

answer

by direct query

question

the data definition language

answer

identifies, for the database management system, the names and relationships of all data elements, records, and files that comprise the database

question

the data manipulation language

answer

enables application programs to interact with and manipulate the database

question

which statement is not correct? a query language like SQL

answer

requires user familiarity with COBOL

question

which duty is not the responsibility of the database administrator?

answer

to design application programs

question

in a hierarchical model

answer

the way to access data is by following a predefined data path

question

which term is not associated with the relation database model?

answer

collision

question

in the relational database model

answer

data is represented on two-dimensional tables

question

in the relational database model all of the following are true except

answer

only one-to-many relationships can be supported

question

in a relational database

answer

users perceive that they are manipulating a single table

question

the update anomaly in unnormalized databases

answer

occurs because of data redundancy

question

the most serious problem with unnormalized databases is the

answer

deletion anomaly

question

the deletion anomaly in unnormalized databases

answer

may result in the loss of important data

question

which statement is correct?

answer

connections between M:M tables are provided by a link table

question

which of the following is not a common form of conceptual database model

answer

sequential

question

which of the following is a relational algebra function?

answer

a. restrict b. project c. join d. ALL ARE RELATIONAL ALGEBRA FUNCTIONS***

question

which statement is false?

answer

the DBMS does not control access to the database

question

all of the following are elements of the DBMS which facilitate user access to the database except

answer

data access language

question

which of the following is a level of the database that is defined by the data definition language?

answer

a. user view b. schema c. internal view d. ALL ARE LEVELS OR VIEWS OF THE DATABASE***

question

an example of a distributed database is

answer

partitioned database

question

data currency is preserved in a centralized database by

answer

using a lockout procedure

question

which procedure will prevent two end users from accessing the same data element at the same time?

answer

data lockout

question

the advantages of a partitioned database include all of the following except

answer

data transmission volume is increased

question

a replicated database is appropriate when

answer

there exists a high degree of data sharing and no primary user

question

what control maintains complete, current, and consistent data at all information processing units?

answer

concurrency control

question

data concurrency

answer

is implemented using timestamping

question

entities are

answer

nouns that are depicted by rectangles on an entity relationship diagram

question

a user view

answer

defines how a particular user sees the database

question

all of the following are advantages of a partitioned database except

answer

deadlocks are eliminated

question

each of the following is a relational algebra function except

answer

link

question

a table is in first normal form when it is

answer

free of repeating group data

question

a table is in second normal form when it is

answer

free of partial dependencies

question

a table is in third normal form when it is

answer

free of transitive dependencies

AS9 – Flashcard

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards