Data descriptions are stored in a central location called the depository.
Answer: B
Correct answer: False
The central store of data descriptions is a repository. Depository is not the term used, and the distinction matters because the repository is a real component with a defined role - holding the metadata that gives the data its meaning.
Please log in or register to report this question.
Which of the following types of databases are the most common?
Answer: C
Correct answer: Department
Departmental databases outnumber the others because most information needs are departmental: a size that justifies a proper shared database but not an enterprise-wide one. Personal databases are numerous but trivial, and enterprise databases are few because there are few enterprises relative to departments.
Please log in or register to report this question.
The source of the data is sometimes called the system of record.
Answer: A
Correct answer: True
The system of record is the authoritative source for a piece of data - the place where it is first captured and against which any disagreement is settled. Naming it explicitly matters in an environment with copies in warehouses, marts and reports, since without it there is no way to say which copy is right.
Please log in or register to report this question.
An enterprise data model is a relational model that shows the high-level entities for the organization and associations among those entities.
Answer: B
Correct answer: False
An enterprise data model is a graphical model, usually in entity-relationship form, showing high-level entities and their associations. Calling it relational confuses the conceptual level with the logical one: the relational model is a later stage, arrived at when the conceptual model is mapped to tables.
Please log in or register to report this question.
Data quality problems currently cost U.S. businesses some $60 million each year (Hudica, 2003).
Answer: B
Correct answer: False
The figure usually cited is some 60 billion dollars a year, not 60 million. The order of magnitude is the point of the statistic: data quality is a problem of the scale of a national industry rather than a rounding error, which is what justifies treating it as a management programme.
Please log in or register to report this question.
Which of the following database activities allow for the actual retrieval and use of a database?
Answer: D
Correct answer: Database implementation
Implementation is where the design becomes a working system loaded with data and reachable by applications, so it is the first stage at which anything can actually be retrieved and used. Enterprise modelling, logical design and physical design all produce specifications rather than a usable database.
Please log in or register to report this question.
Another name for multimedia data is unstructured data.
Answer: A
Correct answer: True
Multimedia content - images, audio, video, free text - is unstructured because it has no fields the DBMS can compare or search on. It can be stored and retrieved as a whole, but locating a particular thing within it requires quite different techniques from those a query language provides.
Please log in or register to report this question.
An advantage of the database approach is the creation of maximum data redundancy.
Answer: B
Correct answer: False
Minimum redundancy is the advantage, not maximum. Duplication is what allows copies to disagree and formats to diverge, so the database approach stores each fact once and lets applications share it. A little controlled redundancy is sometimes introduced deliberately for performance, but that is a considered exception.
Please log in or register to report this question.
Structured data may include which of the following?
Answer: C
Correct answer: Dates
Structured data has a defined type and format that a database can operate on - numbers, dates, codes, fixed-length text. Images and video are unstructured: they can be stored, but the DBMS cannot search or compare their content in the way it can compare two dates.
Please log in or register to report this question.
Stored representations of objects and events that have meaning and importance in the user's environment are known as a database.
Answer: B
Correct answer: False
Stored representations of objects and events that have meaning in the user’s environment are the definition of data. A database is an organised collection of logically related data, which adds the organisation and the relationships. The statement has given one definition under the other name.
Please log in or register to report this question.
