Data Management Layer Design Complete Test Bank Chapter 9

Chapter 09 Data Management Layer Design
Testbank

Multiple Choices

1. Data may be stored in the following formats _____.

a. databases

b. entities

c. entities and files

d. files

e. files and databases

1. A(n) _____ is less expensive and easier for novice users to use, but it does not have the features that are necessary to support mission-critical or large scale systems.

a. database

b. database management system

c. end-user database administrative system

d. end-user database management system

e. enterprise database management system

1. A(n) _____ can support large volumes of data and support applications that run an entire company.

a. database

b. database management system

c. end-user database administrative system

d. end-user database management system

e. enterprise database management system

1. A(n) _____ is basically an electronic list of information that is stored on a disk.

a. sequential access file

b. unordered sequential access file

c. ordered sequential access file

d. random access file

e. transaction file

1. SQL operates on _____.

a. rows of data at a time

b. columns of data at a time

c. tables of data at a time

d. the entire database

e. any of the above

1. Which of the following is NOT a characteristic of current object-relational databases?

a. storage of objects in the relational table structure

b. good support for typical data management operations

c. SQL support

d. support for inheritance

e. all of these are characteristics of object-relational databases

1. In an object-oriented database, an extent is the equivalent to a(n) _____ in a relational database.

a. attribute

b. row

c. table

d. relationship

e. unique identifier

1. The type of database that is most capable of supporting complex data types is _____.

a. sequential files

b. relational DBMS

c. object-oriented DBMS

d. object-relational DBMS

e. random access files

1. The process of ensuring that values linking tables together through the primary and foreign keys are valid and correctly synchronized is _____.

a. hierarchical integrity

b. primary integrity

c. table integrity

d. referential unity

e. referential integrity

1. A relational database may be optimized for _____.

a. data type and storage efficiency

b. relational type

c. speed of access

d. storage efficiency

e. storage efficiency and speed of access

1. A simple rule to follow when creating problem domain classes and data access and manipulation classes is that there should be ______________.

a. One data access and manipulation class for each concrete problem domain class

b. Two data access and manipulation classes for each concrete problem domain class

c. N data access and manipulation classes for each concrete problem domain class, where N is the number of methods in the problem domain class

d. N data access and manipulation classes for each concrete problem domain class, where N is the number of subclasses of the problem domain class

e. none of these

1. Which one in the following list is an example of NOSQL data store?

a. Oracle

b. SQL Server

c. Access

d. OODBMS

e. Google’s Big Table

1. Most NoSQL data stores were created to address problems associated with storing large amounts of distributed data in __________.

a. SQL Server

b. ORDBMSs

c. OODBMSs

d. RDDBMSs

e. MySQL

1. _________ is primarily designed for supporting the decision making systems.

a. Rational DBMS

b. Object Relational DBMS

c. Object-Oriented DBMS

d. Microsoft SQL Server

e. NoSQL

1. Key-value data stores essentially provide a distributed index (primary key) to where a(n) __________________ is stored.

a. BLOB (binary, large object)

b. field

c. entity

d. attribute

True/False

1. A master file holds information temporarily so that it can be used to update other master files.
2. Most object-oriented programming languages support sequential and random access files.
3. Finding a specific object in a sequential access file is relatively easy to do.
4. An object-relational database is used primarily to support multimedia applications.
5. It is likely easier today to find expertise in OODBMS than in RDBMS.
6. Mapping between the problem domain objects and an OODBMS is a straightforward one-to-one mapping.
7. Mapping from the problem domain to the data management objects in an RDBMS format is a straightforward one-to-one mapping.
8. In terms of storage space, the most efficient tables in a relational database have redundant data and many null values.
9. Update anomalies occur when some instances of redundantly stored data are overlooked when an update occurs.
10. A file contains an electronic list of information that is formatted for a particular transaction, and the information is changed and manipulated by programs that are written for those purposes.
11. Look-up files store core information that is important to the business and to the application, and are usually kept for long periods of time with new records appended to the end of the file.
12. The most efficient tables in a relational database in terms of storage space have no redundant data and very few null values because the presence of these suggest that space is being wasted, and more data to store means higher data storage hardware costs.
13. Optimization is a process whereby a series of rules are applied to a logical data model to determine how well-formed it is; these rules help analysts identify entities that are not represented correctly.
14. Sequential access files are very efficient for operations such as report writing.
15. When looking for a specific object of interest, on average 25% of a sequential access file will have to be searched in order to find that object.
16. A transaction file is primarily used to update a master file.
17. Joanne, a systems analyst trained at this university, has been asked to lead a team that will recommend a new data storage system for her company. After careful analysis of the five divisions that comprise the entire $35 million company, Joanne’s team should recommend an end-user database management system.
18. A master file stores core information that is important to the business, is normally kept for long periods of time, and is regularly updated.
19. A file that stores core information important to the business is an audit file.
20. A file that stores static values used for reference and validation is a look-up file.
21. A file that stores information on who, when, and how data was altered is an audit file.
22. An image file stores past transactions that may no longer be needed, is usually stored off-line, and can be accessed on an as-needed basis.
23. An audit file contains information about how data changes over time; it records before and after images of data as it is altered so that it can be validated later.
24. SQL, the standard language for accessing data in tables in relational databases, stands for Standard Query Language.
25. Up until recently, an object-oriented database is mainly used to support multimedia applications or complex systems involving graphics, video and sound.
26. Nicole and her team of skillful systems analysts have been hired to create a database system for an educational software package that supports the study of medicine and the human body. A sample application will include a narrative exploration and graphical “tour” of the heart. As part of Nicole’s team, the type of database that you would you recommend is a relational database.
27. The leader in the database market and a system that can handle diverse data needs is the relational DBMS.
28. It is difficult to find professionals with the necessary skill set for RDBMS.
29. Lauren and her team have been hired to create a transaction system for Mike’s Motorcycles. Mike’s is a medium size shop with 10 employees that sells motorcycle parts and does repair on motorcycles, lawn mowers, and other small engine systems (boats, dune buggies, tractors, etc.) As part of Lauren’s team, you need to recommend relational database management system.
30. The object persistence format that supports simple data types only is OODBMS.
31. The accountants at the Sears store in a local city have noticed that the appliance department is regularly short when items sold are compared to sales. The accountants feel that something is wrong and these systems must be checked for accuracy. The audit file system will reveal if appliances may have been stolen.
32. The two primary dimensions to optimize a relational database are storage efficiency and future needs.
33. The data stores that are described as NoSQL typically support SQL.
34. The applicability of NOSQL data stores is limited and they are NOT applicable to traditional business transaction processing systems.
35. Key-value data stores is a type of NOSQL data stores, and they essentially provide a distributed index (primary key) to where a BLOB (binary, large object) is stored
36. There are many different types of NoSQL data stores including key-value stores, document stores, column-oriented stores, object databases, and RDBMSs.
37. The Object Relational DBMS has all advantages from both the Relational DBMS and the Object-Oriented DBMS.
38. The Relational DBMS only supports simple data types, but the Object Relational DBMS supports both simple and complex data types.

Short Answer

1. Explain the object persistence format type known as files.
2. Explain the object persistence format type known as Relational databases.
3. Explain the object persistence format type known as Object-relational databases.
4. Explain the object persistence format type known as Object Oriented Databases.
5. Information systems consultants, Drew and Becky, have just visited the site of a potential customer. Video-Audio-Images Extra, Inc., is an old established organization that was one of the first companies to videotape weddings, high school musicals, and church presentations. Today they have transformed into a multinational company that performs audio and video recording and mixing, digital re-mastering, and computer graphics for feature films, MTV videos, commercials and video games. During the interview Becky learned that the company has a legacy database system that should soon be replaced. The new system should be able to handle only accounting, purchasing, human resources, and inventory control for the company. What object persistence format would you recommend to Becky and Drew? Support your answer.
6. Explain the difference in the way Structured Query Language processes data compared to traditional programs.
7. What is the role of the following file types: master, look-up, transaction, audit, and history?
8. What is the concept of referential integrity? Why is it important in databases?
9. Describe the differences between an ORDBMS and an OODBMS, and list the advantages of using an OODBMS over an OODBMS.

Being based on established technology, the systems tend to be more mature and have a broader range of personnel with appropriate skill sets.

1. Describe the differences between Relational DB and NoSQL Data Store.
2. When implementing the object persistence in an ORDBMS, what types of issues must you address?
3. Why should the object persistent classes be dependent on the associated problem domain classes instead of the other way around?