Ch-9-StudyGuide

Ch-9-StudyGuide - Ch9 Study Guide True/False Indicate...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Ch9 –Study Guide True/False Indicate whether the statement is true or false. ____ 1. A distributed database is a single logical database that is physically divided among computers at several sites on a network. ____ 2. Accessing data using messages over a network is substantially slower than accessing data on a disk. ____ 3. Seek delay refers to the fixed amount of time that is required for every message. ____ 4. In a DDBMS, the site where the user is located is called the remote site. ____ 5. If users are unaware of fragmentation, the DDBMS has fragmentation transparency. ____ 6. A file server stores the files required by the users on a network. ____ 7. On a client/server network, the server is a computer that provides data to the clients. ____ 8. If the client only performs the presentation functions (and not the business functions), then the client is known as a fat client. ____ 9. An XML document should begin with an XML declaration. ____ 10. Access to a data warehouse is accomplished through the use of OLAP software. ____ 11. In order to view and analyze higher levels of aggregate data, you must drill down the data. ____ 12. When relational databases store complex objects, these special data types are known as SLOBs. ____ 13. The term class refers to the general structure of an object. ____ 14. The actions defined for a class are known as methods. ____ 15. One approach you can use to model all the various aspects of software development for object- oriented systems is known as UML. Multiple Choice Identify the choice that best completes the statement or answers the question. ____ 16. Computers in a network communicate through ____. a. tokens c. notes b. messages d. letters ____ 17. When users are unaware of the steps taken by the DDBMS to update the various copies of data, this characteristic of the DDBMS is called ____. a. location transparency c. replication transparency b. fragmentation transparency d. location site license ____ 18. Which of the following is an advantage of distributed databases? a. Local control of data b. Easier updates of replicated data c. More complex query processing d. More complex treatment of concurrent updates
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
____ 19. When a centralized database becomes unavailable for any reason, no users can continue pro- cessing. In contrast, if a local database in a distributed database becomes unavailable, only users who need that data are affected. Because of this, distributed databases have a(n) ____ advantage over a centralized database. a. local control of data c. system availability b. increasing database capacity d. added efficiency ____ 20. It is possible for local DBMSs to commit updates at some sites and undo updates at other sites. This inconsistency can be prevented by using a ____.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

Ch-9-StudyGuide - Ch9 Study Guide True/False Indicate...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online