################################################################################
SDE Administration Section 3 Exercise Solutions
################################################################################

Question 1:
How many layers are in the PADEP database (i.e. owned by the
PADEP user)?  What is the name of each layer and it's spatial column?

sdelayer -o describe -O padep -u student1 -p passwd1 -i esri_sde -s hawking


Question 2:
How many area features are in the COUNTBND layer?

sdelayer -o stats -l padep.countbnd,shape -u student1 -p passwd1 \
-i esri_sde -s hawking


Question 3:
How many attribute columns does the HOUSBND layer have?

sdetable -o describe -t padep.housbnd -u student1 -p passwd1 -i esri_sde \
-s hawking


Question 4:
On what date was this version of SDE cut?

sdeversion -o list -u sde
(Note: you must be on the server, and you must log in as the SDE user, a DBA
user, or someone to whom SDE has granted access on the VERSION table)


Question 5:
What is the average number of points per feature in the MAJRIVRS layer?

sdelayer -o stats -l padep.majrivrs,shape -u student1 -p passwd1 \
-i esri_sde -s hawking


Question 6:
What is the name of the table that contains the actual coordinates (BLOB)
for the DAMS layer?

INFORMIX, DATA JOINER

	"PADEP.DAMS"


ORACLE, SQL SERVER, DB/2 UDB

	sdelayer -o describe -l padep.dams,shape -u student1 -p passwd1 \
	-i esri_sde -s hawking

	Get the layer ID from the output of this command.

	"PADEP.F<layer_id>"

SYBASE

	sdelayer -o describe -l padep.dams,shape -u student1 -p passwd1 \
	-i esri_sde -s hawking

	Get the layer ID from the output of this command.

	"PADEP.P<layer_id>"


Question 7:
If you added a second-level spatial index grid to the MAJRRDS layer (keeping
the same first-level grid), how many features would be promoted?

sdelayer -o si_stats -l padep.majrrds,shape -u student1 -p passwd1 \
-i esri_sde -s hawking

Any features that occupy more than 4 grid cells would get promoted.


Question 8:
What is the maximum number of client connections that the server will allow?

The lesser of:
	o Number of SdeClient licenses
	o "Max. Server Connections" from 'sdemon -o info -I config'
	o Number of RDBMS licenses (1 license for each SdeClient feature
	  - gsrvr connections to RDBMS - plus 1 license for each SdeServer
	  feature - giomgr connections to RDBMS)


Question 9:
What is the MCDTYPE of the minor civil division (a feature in the MCD layer)
who's MCDNAME is BARREE?

sdetable -o list -t padep.mcd -c mcdname -v "'BARREE'" -u student1 \
-p passwd1 -i esri_sde -s hawking

################################################################################
END
################################################################################