GIS Geodatabase Design and Management 3

Question 1

What is the role of the 'GDB_ITEMS' system table in an enterprise geodatabase?

Accepted Answer

It acts as the central catalog of all geodatabase datasets and their metadata

Answer

GDB_ITEMS is the core system table that catalogs every item in the geodatabase, including feature classes, tables, domains, and topologies.

Question 2

A geodatabase subtype allows you to do which of the following?

Accepted Answer

Assign different default values and domains per category within one feature class

Answer

Subtypes partition a single feature class by a numeric code field, allowing different attribute defaults and domain restrictions per category without creating separate tables.

Question 3

Which privilege is required for a database user to create new feature classes inside an enterprise geodatabase owned by another user?

Accepted Answer

CREATE TABLE privilege in the DBMS

Answer

Creating new tables (feature classes) in a relational database requires the CREATE TABLE privilege granted at the DBMS level.

Question 4

What is the function of a 'network dataset' in a geodatabase compared to a geometric network?

Accepted Answer

Network datasets support turn features and multi-modal travel; geometric networks model flow direction in utility systems

Answer

Network datasets (used with Network Analyst) model transportation networks with turns and multi-modal connectivity, while geometric networks model directed flow in utility infrastructure.

Question 5

In an enterprise geodatabase, what does 'reconcile' accomplish in versioned editing?

Accepted Answer

It merges changes from the parent version into the current editing version

Answer

Reconciling a version incorporates changes that have occurred in the target (typically default) version into the edit version so conflicts can be identified and resolved.

GIS - Geographic Information System Practice Test

GIS - Geographic Information System Practice Test

GIS Geodatabase Design and Management 3