gis attribute data

Question 1

table

Answer 1

data stored as an array of rows and columns, with each row representing an object or feature and each column representing an attribute or property of that object

Question 2

record

Answer 2

row in a table that contains one object

Question 3

attribute field

Answer 3

column in a table containing information about spatial features

Question 4

attribute table

Answer 4

table containing rows of information for features

Question 5

standalone table

Answer 5

a table of information not linked to spatial data features

Question 6

flat file database

Answer 6

data that stores data in simple files

Question 7

hierarchical database

Answer 7

database that stores information in tables with permanent links between them

Question 8

relational database

Answer 8

database that stores information in tables and constructs temporary relationships between them

Question 9

join

Answer 9

temporary combination of data from two tables based on a common attribute field or location

Question 10

query

Answer 10

an operation to extract records from a database according to a specified set of criteria

Question 11

logical expression

Answer 11

a statement composed of fieldnames, operators, and values that specifies criteria used to select records or values from a layer or table

Question 12

selected set

Answer 12

a set of features that have been extracted prior to another operation; the result of a query

Question 13

key

Answer 13

an attribute field that is used to extract or match records in a table

Question 14

source table

Answer 14

table that provides information that is being appended to another table in a join

Question 15

destination table

Answer 15

the table that receives data from another table during a join operation

Question 16

cardinality

Answer 16

The relationship between records in two tables:

Question 17

Rule of Joining

Answer 17

each record in the destination table must have only one matching record in the source table

Question 18

relate

Answer 18

a temporary association between two tables based on a common field whereby fields may be selected based on whether they match selected records in the other table

Question 19

summarize

Answer 19

a function that groups records in a table according to one categorical field and calculates statistics for each group

Question 20

field definition

Answer 20

parameters specified when creating an attribute field, including type of data, field length, precision and scale

Question 21

field length

Answer 21

the maximum number of characters that can be stored in a text attribute field

Question 22

precision

Answer 22

the number of digits allotted to store a numeric value

Question 23

scale

Answer 23

ratio of the size of features on the map to their size on the ground

Question 24

byte

Answer 24

a unit of data storage in base two containing eight zeroes or ones and holding a number from 0 to 255

Question 25

ASCII

Answer 25

international code used to store simple text letters, numbers, and symbols: synonymous with text file

Question 26

binary

Answer 26

numeric data stored in base 2 as a series of ones and zeroes; a computer’s native data storage

Question 27

mantissa

Answer 27

the part of an exponential number that stores the significant digit

Question 28

single-precision

Answer 28

numeric value stored using eight bytes of information

Question 29

double-precision

Answer 29

a numeric value stored using 16 bytes of information

Question 30

alias

Answer 30

alternate name displayed for a field in a table that does not have to follow length and character restrictions

Question 31

event layer

Answer 31

map layer of points created from a series of coordinate pairs in a table