Database Design

Question 1

Schema

Answer 1

Structure or design of the database or database object (table, index, view stored procedure, and trigger). The work includes defining the tables, fields in each table, and relationships between fields. A schema will include information on which field have domains and what those domains are

Question 2

Data Dictionary

Answer 2

Catalog or table containing information about the datasets stored in a database.

Question 3

Domain

Answer 3

The range of values for a particular metadata element.

Question 4

Attribute Domain

Answer 4

enforces data integrity, identify what values are allowed in a field in a feature class

Question 5

Coded Value Domain

Answer 5

Attribute domain that defines a set of permissible values for an attribute in a geodatabase. It has a code and its equivalent value.

Question 6

Range Domain

Answer 6

A type of attribute domain that defines the range of permissible value for a numeric attribute

Question 7

Spatial Domain

Answer 7

The allowable range for x, y coordinates, m, and z values.

Question 8

Tables

Answer 8

A collection or related data held in structured format within a database, contains fields and rows.

Question 9

Views

Answer 9

The result set of a stored query on the data. Users can query. A virtual table is computed dynamically from data when the view is accessed.

Question 10

Sequences

Answer 10

Ordered collection of objects in which repetitions are allowed (finite or infinite). The number of elements is the length of the sequence.

Question 11

Synonyms

Answer 11

Alias or alternate name for a table, view, sequence or other object.

Question 12

Indexes

Answer 12

The data structure improves the speed of data retrieval operations in a database table. It causes more storage space and additional writes. It can quickly locate data in the database. It can be on multiple rows.

Question 13

Cluster

Answer 13

It can either be multiple serves share one storage (typically used to handle user load balancing), or the database distributed to different serves using replication (this is typically used if you have multiple users utilizing the same data in different physical locations, and there is a master database that the replica databases sync between.)

Question 14

Database Link

Answer 14

Data stored in a different database but accessible by the database currently being accessed

Question 15

Snapshot

Answer 15

State of a system at a particular point in time (which can be a backup).

Question 16

Procedure

Answer 16

Subordinate available to applications that access a relational database system (data validation, and access control mechanisms)

Question 17

Trigger

Answer 17

Procedural code automatically executed in response to certain events on a particular table or view in a database.

Question 18

Functions (subroutine)

Answer 18

Sequence of program instructions that perform a specific task

Question 19

Package

Answer 19

Built from source with one of the available package management systems

Question 20

Non-schema Object

Answer 20

Users, roles, contexts, directory objects.

Question 21

Database Design

Answer 21

The process of producing a detailed data model of a database

Question 22

Design Process

Answer 22

Conceptual Schema, Logical Data Model, Physical Database Design

Question 23

Conceptual Schema

Answer 23

Determine where relationships and dependency is within the data.

Question 24

Logical Data Model

Answer 24

Arrange data in a logical structure that can be mapped into the storage objects supported by the database management system

Question 25

Physical Database Design

Answer 25

The physical configuration of the database on the storage media. The detailed specification of data elements, data types, indexing options, and other parameters residing in the DBMS data dictionary, as well as the modules, hardware and software.

Question 26

Field Types

Answer 26

The proper field type will secure data and make databases more efficient

Question 27

Short Integer

Answer 27

Between -32768 to 32768 (5 digits integers, positive and negative)

Question 28

Long Integer

Answer 28

Between +/- 2147483648 ( 10 digits integers, postive and negative)

Question 29

Float

Answer 29

Single-precision floating-point numbers （seven digits after the point)

Question 30

Double

Answer 30

Double-precision floating-point numbers (15 digits after the point)

Question 31

Text

Answer 31

Could be a coded value that is assigned to integer through a domain

Question 32

Dates

Answer 32

A calendar date and sometimes a time is associated

Question 33

BLOBs

Answer 33

Data is stored as a long sequence of binary numbers. ArcGIS stores annotation and dimensions as BLOBs (images, multimedia, and bits of code)

Question 34

Object Identifier

Answer 34

Unique IDs, and FIDs

Question 35

Global Identifier

Answer 35

Global ID, and GUID. Data types stored registry type string, which contains 36 characters enclosed in curly brackets.

Question 36

Raster Field Type

Answer 36

Raster files can be stored within the geodatabase.

Question 37

Geometry

Answer 37

Point, line, polygon, multipoints, and multiparts.

Question 38

Data Owner

Answer 38

User who creates tables, feature classes and who owns the datasets.

Question 39

User Access

Answer 39

The database must verify the user accounts that connect to it.

Question 40

Authentication

Answer 40

The database checks the list of users to make sure a user is allowed to make a connection.

Question 41

Groups

Answer 41

Grants users based on their common functions

Question 42

Public Role

Answer 42

Rights granted to anyone connected to the database