Marine GIS Practicum Exam

The analytical technique of finding and processing data to create a new dataset using SQL is called

• Query

• Query Builder

• Structured Query Language

• Data table

Query function used to search is called

• LIKE

• AND

• NOT

• IF

Query function that connects two other functions is called

• LIKE

• AND

• NOT

• IF

Query function as negation or not is called

• LIKE

• AND

• NOT

• IF

The first stage in calculating the area in the shp format data is

• Setting up an empty field (column)

• Change the coordinate system according to the UTM zone division

• Calculate geometry

• Choose the unit you want

How to write the syntax on Select by Attribute when you want to find "area" less than 1000 is

• “Area” < 1000

• “Area” <= 1000

• “Area” > 1000

• “Area” >= 1000

How to write the syntax for Select by Attribute when you want to find "area" less than 1000 and more than equal to 500 is

• “Area” < 1000 AND “Area” >= 500

• “Area” < 1000 OR “Area” >= 500

• “Area” < 1000 AND “Area” > 500

• “Area” < 1000 OR “Area” > 500

How to write the syntax for Select by Attribute when you want to search for “Kecamatan” starting with B is

• “District” LIKE 'B'

• “District” FIND 'B'

• “District” FIND 'B%'

• “District” LIKE 'B%'

How to write the syntax for Select by Attribute when you want to search for “Kecamatan” Dramaga and Ciampea is

• “Kecamatan” = 'Dramaga' AND “Kecamatan” = 'Ciampea'

• “District” = 'Dramaga' OR “Kecamatan” = 'Ciampea'

• “Kecamatan” OR 'Dramaga' = “Kecamatan” OR 'Ciampea'

• “Kecamatan” AND 'Dramaga' = “Kecamatan” AND 'Ciampea'

Software ArcGIS was released in…

• 2000

• 2001

• 2002

• 2003