GIS: Networks (compiled from various
chapters) Questions with Correct Answers
What do DBMSs provide? Data management for agencies, universities, companies, etc.
What are DBMSs designed for? Multi-user environments with enhanced security needs
What do DBMSs focus on? Data tables with tools for queries, reporting, graphing, etc.
List three qualities of a flat file DBMS: 1. stores data as rows of information in files
2. simple and robust
3. inefficient for search and query
List five qualities of hierarchical DBMS: 1. stores data in multiple tables
2. tables have defined parent-child relationships
3. pre-set hierarchy of table relationships designed for specific queries
4. very efficient for specific requirements
5. range of queries limited by structure
, List five qualities of relational DBMS: 1. stores data in multiple tables
2. table relationships are defined as needed
3. very flexible
4. ideal for open-ended applications when queries are not known beforehand
5. most common type used in GIS applications
What is a query? A query extracts certain records from a table based on a specified
condition
Structured Query Language Used to write queries that work in multiple DBMS
environments; can be saved and reused, are nearly always case-sensitive
What is a join? Joins are temporary relationships between tables used by a relational
DBMS
In a join, tables must share a common ______ field (key)
chapters) Questions with Correct Answers
What do DBMSs provide? Data management for agencies, universities, companies, etc.
What are DBMSs designed for? Multi-user environments with enhanced security needs
What do DBMSs focus on? Data tables with tools for queries, reporting, graphing, etc.
List three qualities of a flat file DBMS: 1. stores data as rows of information in files
2. simple and robust
3. inefficient for search and query
List five qualities of hierarchical DBMS: 1. stores data in multiple tables
2. tables have defined parent-child relationships
3. pre-set hierarchy of table relationships designed for specific queries
4. very efficient for specific requirements
5. range of queries limited by structure
, List five qualities of relational DBMS: 1. stores data in multiple tables
2. table relationships are defined as needed
3. very flexible
4. ideal for open-ended applications when queries are not known beforehand
5. most common type used in GIS applications
What is a query? A query extracts certain records from a table based on a specified
condition
Structured Query Language Used to write queries that work in multiple DBMS
environments; can be saved and reused, are nearly always case-sensitive
What is a join? Joins are temporary relationships between tables used by a relational
DBMS
In a join, tables must share a common ______ field (key)
