Term
| What are the 4 classes of info in cignitive hierarchy? |
|
Definition
| Data, info, knowledge, understanding |
|
|
Term
| What must you do to data for it to become meaningful to the end user? |
|
Definition
| It must be processed and organized. |
|
|
Term
|
Definition
| used to describe how the data is structured using a prescribed syntax and to associated the data with semantics |
|
|
Term
|
Definition
| The act of learning of integrating from various pieces of information |
|
|
Term
| What is the objective of transparency? |
|
Definition
| To ensure that the process of transforming data into information used for decision making is traceable, auditable and demonstrably proven, and making it authoritative |
|
|
Term
| Content delivery services deliver info assets to end users. These sevices can be of 2 types, what are they? |
|
Definition
| Core data services and aggregation services |
|
|
Term
| What does Services Oriented Enterprise provide? |
|
Definition
| It provides a means of achieving IT agility and flexibility to support rapidly evolving mission processes and changing goals and objectives |
|
|
Term
| How are data elements obtained? |
|
Definition
| From data models and represent DOD data requirements |
|
|
Term
|
Definition
| something that is measurable and repeatable |
|
|
Term
|
Definition
| specialized format for organizing and storing data |
|
|
Term
| How are data structures organized? |
|
Definition
| with the capability to request or query only the info necessary to fulfill a requirement |
|
|
Term
|
Definition
| structured description of the records |
|
|
Term
| What are physical data structures concerned with? |
|
Definition
| How data resides in a database |
|
|
Term
| Difference between using linked and sequential lists. |
|
Definition
| linked lists use pointers. sequential lists use the natural order of items |
|
|
Term
| What do logical data structures allow users to do? |
|
Definition
| view stored data in the database |
|
|
Term
| How do tables and views differ? |
|
Definition
| A database table is a set of data elements that is organized using a model of horizontal rows and vertical columns. Views are also relational tables but their data is calculated at query time |
|
|
Term
| Parts of a hierarchical data structure |
|
Definition
| Parent node- the node on the top end of a branch. Child node- the node on the bottom of the branch. Root node- a special type of parent node; the top of a hierarchical tree |
|
|
Term
| What is special about having a network data structure? |
|
Definition
| The relationship from child-to-parent and the relationship from parent-to-child can be one too many |
|
|
Term
| What is the main purpose of a database? |
|
Definition
| to make data independent of the programs that uses it |
|
|
Term
|
Definition
| process of organizing data into tables in such a way that the results of using the database are unambiguous |
|
|
Term
| Describe the first 3 normal forms |
|
Definition
| 1st- each attribute of the entity occurs only once and there are no repeating groups of data. 2nd- an entity is in first normal form and each attribute is dependent on its entire primary key. 3rd- an entity is in second form and no attribute of the entity is dependent on another non-key attribute |
|
|
Term
| What permissions can the DBA (database administrator) grant? |
|
Definition
| access, insert, delete, and modify existing data |
|
|
Term
| Name 4 functions a DBA performs |
|
Definition
| managing the database structure and the DBMS; the data activity; and maintaining the data repository |
|
|
Term
| What are the symptoms of database fragmentation? |
|
Definition
| Slow response to on-line inquiries, report extracts that take longer than normal and abnormally large database files |
|
|
Term
| 3 steps of reorganization |
|
Definition
| 1. opy current records to another media. 2. initialize database. 3. reload database |
|
|
