AS9 – Flashcard
67 test answers
Unlock all answers in this set
Unlock answers 67question
the data definition language is used to insert special database commands into application programs
answer
false
Unlock the answer
question
there is more than one conceptual view of the database
answer
false
Unlock the answer
question
in the database method of data management, access authority is maintained by systems programming
answer
false
Unlock the answer
question
the physical database is an abstract representation of the database
answer
false
Unlock the answer
question
a customer name and an unpaid balance is an example of a one-to-many relationship
answer
false
Unlock the answer
question
in the relational model, a data element is called a relation
answer
false
Unlock the answer
question
data normalization groups data attributes into tables in accordance with specific design objectives
answer
true
Unlock the answer
question
under the database approach, data is viewed as proprietary or owned by users
answer
false
Unlock the answer
question
the data dictionary describes all of the data elements in the database
answer
true
Unlock the answer
question
a join builds a new tables by creating links
answer
false
Unlock the answer
question
the deletion anomaly is the least important of the problems affecting unnormalized databases
answer
false
Unlock the answer
question
a deadlock is a phenomenon that prevents the processing of transactions
answer
true
Unlock the answer
question
timestamping is a control that is used to ensure database partitioning
answer
false
Unlock the answer
question
a lockout is a software control that prevents multiple users from simultaneous acces to data
answer
true
Unlock the answer
question
logical database design is the foundation of the conceptual design
answer
false
Unlock the answer
question
an entity is any physical thing about which the organization wishes to capture data
answer
false
Unlock the answer
question
an ER diagram is a graphical representation of a data model
answer
true
Unlock the answer
question
the term occurrence is used to describe the number of attributes or fields pertaining to a specific entity
answer
false
Unlock the answer
question
cardinality describes the number of possible occurrences in one table that are associated with a single occurrence in a related table
answer
true
Unlock the answer
question
a table in third normal form is free of partial dependencies, multiple dependencies and transitive dependencies
answer
false
Unlock the answer
question
improperly normalized databases are associated with three types of anomalies: the update anomaly, the insertion anomaly, and the deletion anomaly
answer
true
Unlock the answer
question
all of the following are basic data management tasks except
answer
data attribution
Unlock the answer
question
the task of searching the database to locate a stored record for processing is called
answer
data retrieval
Unlock the answer
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
Unlock the answer
question
which characteristic is associated with the database approach to data management
answer
data sharing
Unlock the answer
question
which characteristic is not associated with the database approach to data management?
answer
the inability to determine what data is available
Unlock the answer
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
Unlock the answer
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
Unlock the answer
question
a description of the physical arrangement of records in the database is
answer
the internal view
Unlock the answer
question
which of the following may provide many distinct views of the database
answer
the user view
Unlock the answer
question
users access the database
answer
by direct query
Unlock the answer
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
Unlock the answer
question
the data manipulation language
answer
enables application programs to interact with and manipulate the database
Unlock the answer
question
which statement is not correct? a query language like SQL
answer
requires user familiarity with COBOL
Unlock the answer
question
which duty is not the responsibility of the database administrator?
answer
to design application programs
Unlock the answer
question
in a hierarchical model
answer
the way to access data is by following a predefined data path
Unlock the answer
question
which term is not associated with the relation database model?
answer
collision
Unlock the answer
question
in the relational database model
answer
data is represented on two-dimensional tables
Unlock the answer
question
in the relational database model all of the following are true except
answer
only one-to-many relationships can be supported
Unlock the answer
question
in a relational database
answer
users perceive that they are manipulating a single table
Unlock the answer
question
the update anomaly in unnormalized databases
answer
occurs because of data redundancy
Unlock the answer
question
the most serious problem with unnormalized databases is the
answer
deletion anomaly
Unlock the answer
question
the deletion anomaly in unnormalized databases
answer
may result in the loss of important data
Unlock the answer
question
which statement is correct?
answer
connections between M:M tables are provided by a link table
Unlock the answer
question
which of the following is not a common form of conceptual database model
answer
sequential
Unlock the answer
question
which of the following is a relational algebra function?
answer
a. restrict b. project c. join d. ALL ARE RELATIONAL ALGEBRA FUNCTIONS***
Unlock the answer
question
which statement is false?
answer
the DBMS does not control access to the database
Unlock the answer
question
all of the following are elements of the DBMS which facilitate user access to the database except
answer
data access language
Unlock the answer
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***
Unlock the answer
question
an example of a distributed database is
answer
partitioned database
Unlock the answer
question
data currency is preserved in a centralized database by
answer
using a lockout procedure
Unlock the answer
question
which procedure will prevent two end users from accessing the same data element at the same time?
answer
data lockout
Unlock the answer
question
the advantages of a partitioned database include all of the following except
answer
data transmission volume is increased
Unlock the answer
question
a replicated database is appropriate when
answer
there exists a high degree of data sharing and no primary user
Unlock the answer
question
what control maintains complete, current, and consistent data at all information processing units?
answer
concurrency control
Unlock the answer
question
data concurrency
answer
is implemented using timestamping
Unlock the answer
question
entities are
answer
nouns that are depicted by rectangles on an entity relationship diagram
Unlock the answer
question
a user view
answer
defines how a particular user sees the database
Unlock the answer
question
all of the following are advantages of a partitioned database except
answer
deadlocks are eliminated
Unlock the answer
question
each of the following is a relational algebra function except
answer
link
Unlock the answer
question
a table is in first normal form when it is
answer
free of repeating group data
Unlock the answer
question
a table is in second normal form when it is
answer
free of partial dependencies
Unlock the answer
question
a table is in third normal form when it is
answer
free of transitive dependencies
Unlock the answer
