Multiple choice questions

Try the multiple choice questions below to test your knowledge of this chapter.

There are two main types of MCQ: those where there is only one correct answer and those where there is more than one possible answer. See example.

Once you have finished the questions, click on the 'Submit Answers for Grading' button to get your results.

This activity contains 14 questions.

	What does the abbreviation DBMS stand for?   Digital Base Mapping System. Database Manipulation Software. Data Borrowing and Movement Software. Database Management System.

	The advantages of Standard Query Language (SQL) include which of the following in relation to GIS databases?   It is good at handling geographical concepts. It is widely used. It uses a pseudo-English style of questioning. It is simple and easy to understand.

	Which of the following are characteristics of an RDBMS?   Tables are linked by common data known as keys. Queries are possible on individual or groups of tables. Data are organized in a series of two-dimensional tables each of which contains records for one entity. It cannot use SQL. Keys may be unique or have multiple occurrences in the database.

	What is a 'tuple'?   Another name for a table in an RDBMS. A row or record in a database table. An attribute attached to a record. Another name for the key linking different tables in a database.

	Which of the following are issues to be considered by users of large corporate GIS databases?   The need for multiple views or different windows into the same databases. The need for concurrent access and multi-user update. The need for multiple copies of the same data and subsequent merging after separate updates. The need to manage long transactions. The need for manual transfer of records to paper.

	Which of the following are features of the object-oriented approach to databases?   The ability to develop more realistic models of the real world. The ability to represent the world in a non-geometric way. The need to split objects into their component parts. The ability to develop database models based on location rather than state and behaviour. The ability to develop databases using natural language approaches.

	Redundancy is minimised with a computer based database approach.    True  False

	The relational database model is based on concepts proposed in the 1960s and 1970s.    True  False

	A row in a database can also be called a domain.    True  False

	A first step in database creation should be needs analysis.    True  False

	In entity attribute modelling a many to many relationship is represented by M:M.    True  False

	In a networked web based GIS all communications must go through an internet map server.    True  False

	In an OO database approach 'object = attributes + behaviour'.    True  False

	In an OO database objects may inherit some or all of the characteristics of other objects.    True  False

Copyright © 1995-2006 Pearson Education. All rights reserved. Legal and Privacy Notice