Quiz
Chapter 7
Erstelle ein kostenloses Konto, um dieses Quiz zu beenden
Speichere deinen Fortschritt und sieh dir dein Endergebnis an.
oder mit deiner E-Mail registrieren
Schon ein Konto? Anmelden
Fragen in diesem Quiz (45)
1A major advantage of relational databases is:
- AAll records are stored together
- BNo pointers are used
- CThe ability to add tables and relationships after the database becomes operational
- DIt closely resembles a flat file
2In recent years many businesses have formed a common information source within their business organization called a database. One of the advantages of building databases is the simultaneous updating of files with common data elements. Another major advantage of the database concept is that:
- ADatabase systems can be used in microcomputers as well as on large computers
- BDatabase systems are simple to install and maintain
- CDatabase systems are generally less expensive than separate file systems
- DMore duplication of data occurs with a database system
- EFewer skilled people are required to run a database system than another system
3Within a database context, the relationship between “natural parent” and “child” would most likely be:
- AOne-to-one
- BOne-to-many
- CMany-to-one
- DMany-to-many
4Within a database context, the relationship between “military officer” and “private” would most likely be:
- AOne-to-one
- BOne-to-many
- CMany-to-one
- DMany-to-many
5Within a database context, the relationship between “students” and “classes” would most likely be:
- AOne-to-one
- BOne-to-many
- CMany-to-one
- DMany-to-many
6Within a database context, the relationship between “assigned parking space” and "car" would most likely be:
- AOne-to-one
- BOne-to-many
- CMany-to-one
- DMany-to-many
7Within a database context, the relationship between “doctor” and “patient” would most likely be:
- AOne-to-one
- BOne-to-many
- CMany-to-one
- DMany-to-many
8This item helps developers document a database:
- AData documentation detailer (DDD)
- BData dictionary
- CDatabase schema system
- DData OLAP system
9An example of a transitive dependency in a database is:
- AStudent-> grade
- BTelephone area code -> phone number
- CAirline -> flight number
- DParking Code -> parking fine amount
10An example of a transitive dependency in a database is:
- AStudent -> university course number
- BParking ticket code -> total of student parking fines
- CProduct number -> product price
- DAge -> social security number
11In the REA framework, a database designer should create a ____ for each entity.
- ARecord
- BTable
- CSecondary key
- Dall of these
12In the E-R model, this symbol represents a database entity such as a customer:
- ADiamond
- BRectangle
- CArrow
- DParallelogram
13This type of database structure enables users to create relationships after the database has been created and implemented:
- AHierarchical
- BNetwork
- CStar
- DRelational
14The REA accounting framework is most closely associated with which of the following?
- ASQL
- BAn enterprise-wide view of accounting processes
- CNormalization of accounting data for recording and query purposes
- DAn example of a data manipulation language
15Which of these would be an example of an “agent” in the REA framework?
- ASalesperson
- BCustomer
- CManager
- Dall of these are possibilities
16Which of these would be an example of a “resource” in the REA framework?
- AEquipment
- BInventory
- CCash
- Dall of these are possible examples of resources
17In the REA framework, which of these would be recorded as an “event?”
- AHiring a new president of the company
- BTaking an initial sales order from a customer
- CBuying a piece of equipment for cash
- Dall of these would be recorded as events
18In the REA framework, an account receivable would be classified as a(n):
- AAsset
- BEvent
- CResource
- Dnone of these
19All of the following are items within the data hierarchy except:
- ADatabase
- BData field
- CRecord
- Dall of these items are part of the data hierarchy
20The letter “M” in the acronym DBMS stands for “management.”
- ARichtig
- BFalsch
21An accounting information system database is a collection of facts and figures that serves the accounting information needs of one or more organizational subsystems.
- ARichtig
- BFalsch
22The correct order of elements, from smallest to largest, in the data hierarchy is data field, record, file (table), database.
- ARichtig
- BFalsch
23The smallest unit of information in the data hierarchy is a data field.
- ARichtig
- BFalsch
24The data field that distinguishes one computer record from another on a computer file is called the primary record key.
- ARichtig
- BFalsch
25A Social Security number is a good example of a useful primary record key.
- ARichtig
- BFalsch
26A foreign key is a data field in the records of one file that references a primary key in the records of another file.
- ARichtig
- BFalsch
27Three database concerns when creating large databases are “data integrity,” “processing accuracy,” and “data security.”
- ARichtig
- BFalsch
28A data dictionary is a computer file describing the data items of an accounting database.
- ARichtig
- BFalsch
29The term “transaction control” refers to the requirement that a database system either process a transaction entirely, or not at all.
- ARichtig
- BFalsch
30The idea behind concurrency control is to deny several users access to the same database record at the same time.
- ARichtig
- BFalsch
31The idea behind view controls is to allow users access to only that information that they need to see.
- ARichtig
- BFalsch
32“Protecting privacy” is an important goal in data modeling.
- ARichtig
- BFalsch
33“Reducing data redundancy” is an important goal in data modeling.
- ARichtig
- BFalsch
34The E-R model refers to the “entity-relationship” model.
- ARichtig
- BFalsch
35An example of a database cardinality is “one-to-many.”
- ARichtig
- BFalsch
36An example of a database cardinality is “one-to-one.”
- ARichtig
- BFalsch
37An example of a “one-to-one” relationship is “employee to assigned parking stall.”
- ARichtig
- BFalsch
38An advantage of relational databases is that additional indexes can be added at later points of time as new data processing requirements dictate.
- ARichtig
- BFalsch
39Databases cannot store more than one value in the same data field of the same record.
- ARichtig
- BFalsch
40A database is in first normal form if all of its record’s data fields are well defined and the information can thus be stored as a flat file.
- ARichtig
- BFalsch
41A database is in third normal form if all of its records are in second normal form, and there are no transitive dependencies.
- ARichtig
- BFalsch
42An example of a transitive relationship in a parking-tickets application is the one between “ticket code” and “fine amount.”
- ARichtig
- BFalsch
43An example of a transitive relationship in a medical application is the one between “medical procedure code” and “cost of treatment.”
- ARichtig
- BFalsch
44Big data refers to data that are of large volumes and are unstructured.
- ARichtig
- BFalsch
45A sale is an example of an event in the REA accounting framework.
- ARichtig
- BFalsch
Informationen
- Beschreibung
- Quiz am Chapter 7, erstellt von Rebecca Escobar am 06/11/2016.
- Autor
- Rebecca Escobar
- Sprache
- English
- Aufrufe
- 10
- Schlagwörter
- Bewertung
- Noch keine Bewertungen Bewerte dieses Quiz