Term
| Which subsystem process does IMDS automate? |
|
Definition
|
|
Term
| What system best describes the operating concept of IMDS? |
|
Definition
|
|
Term
| The database manager must inform users when a batch program is scheduled to be run |
|
Definition
| requiring the IMDS online processing to be down |
|
|
Term
| When monitoring coputer maintenance as a database manager, your efforts must be directed toward |
|
Definition
| the analysis of unscheduled and scheduled downtime |
|
|
Term
| make sure your notification checklist includes the |
|
Definition
| address and phone number of each user to be notified |
|
|
Term
| Which utility program requires that the database be down when you run this program? |
|
Definition
| data management utility verifies |
|
|
Term
| How many days of history does program NFS760 retain on the database? |
|
Definition
|
|
Term
| Which program is used to verify program NFS760 runs each week? |
|
Definition
|
|
Term
| How many options are there for program NFS7U0? |
|
Definition
|
|
Term
When contacted by supply, which screen does the database manager (DBM) run for an
annual Standard Reporting Designator (SRD) reconciliation? |
|
Definition
|
|
Term
| Which is an option for off-line processing? |
|
Definition
| Creating input text files |
|
|
Term
| The two basic procedures for data recovery are processing |
|
Definition
| pseudo remote and manual remote |
|
|
Term
| Implement pseudo processing when |
|
Definition
| the system is unavailable for a long time |
|
|
Term
| What is the reason for establishing an alternate IMDS processing site? |
|
Definition
| continuous reporting of reliability and maintainability information system reportable job data documentation |
|
|
Term
| What document is used by the Field Assistance Service to communicate with field agencies? |
|
Definition
|
|
Term
| What does the 754th Electronic Systems Group (ELSG) send out to the field right away if a software problem is discovered but a system advisory notice (SAN) might be delayed? |
|
Definition
|
|
Term
For which situation may the user submit an Air Force IMT 3215, C4 Systems Requirements
Document regarding IMDS? |
|
Definition
| add new capabilities to IMDS |
|
|
Term
| A difficulty report (DIREP) in IMDS is used when |
|
Definition
| IMDS is not operating as designed |
|
|
Term
| A difficulty report (DIREP) is submitted when the |
|
Definition
| IMDS functional manager cannot provide a workaround for the problem |
|
|
Term
The responsibility for initializing Interactive Communication Interface (ICI) via screen
#891 lies with |
|
Definition
| the host data base manager (DBM) |
|
|
Term
Which Reliability and Maintainability Information System (REMIS) interface program
reschedules REMIS inventory reconciliations? |
|
Definition
|
|
Term
Which Reliability and Maintainability Information System (REMIS) interface program
provides a list of all files which have been received from or transmitted to REMIS within the last 72 hours? |
|
Definition
| Defense Data Network (DDN) Address record |
|
|
Term
| which option on the G081 Session Selection menu brings up the G081 Time Sharing Option (TSO) menu? |
|
Definition
|
|
Term
| In G081, when you see three asterisks (*) in a row, it means you need to press |
|
Definition
|
|
Term
Which option would you select on the Time Sharing Option (TSO) Primary Option Menu in
order to start the G081 User ID Maintenance Facility? |
|
Definition
|
|
Term
In addition to creating a new G081 User ID in the G081 User ID Maintenance Facility,
which program must the G081 manager process in order to grant access to G081? |
|
Definition
| F9057, Terminal/User Master Record Update |
|
|
Term
Which option of the virtual telecommunications access method (VTAM) Printing System
Virtual Machine Communications Facility (VMCF) F Printer Selection List is used to access a particular printer?s command page? |
|
Definition
|
|
Term
As the result of an aircraft mishap, an IMDS
database save tape expiration date is changed to |
|
Definition
|
|
Term
| What must you immediately do in G081 if there is an aircraft mishap? |
|
Definition
| secure the aircraft records |
|
|
Term
| What type(s) of database system(s) compose the IMDS central database? |
|
Definition
|
|
Term
The most distinguishing characteristic of a relational query language, like Structured Query
Language (SQL), is |
|
Definition
| its non-procedural language |
|
|
Term
Within the Relational Database Management System (RDMS) section of the central
database (CDB), reference tables that include equipment and aircraft are provided by |
|
Definition
| data from Reliability and Maintainability Information System (REMIS) |
|
|
Term
| What does the schema of a database describe? |
|
Definition
| physical layout of records and logical relationships between records |
|
|
Term
Which element under the area section of the IMDS
schema indicates how much space is left over? |
|
Definition
|
|
Term
| How many base level areas does the enterprise location code (ELC) database have? |
|
Definition
|
|
Term
Which clause in the record section of the IMDS
schema defines the areas where the records can be found? |
|
Definition
|
|
Term
Record placement in the IMDS database depends on
association, distribution, and |
|
Definition
|
|
Term
Within IMDS, a direct type of record has its
database key assigned and controlled by the |
|
Definition
| Electronic Systems Group (ELSG) database administrator |
|
|
Term
| Which type of records comprise a majority of the IMDS database? |
|
Definition
|
|
Term
| You can access via set records normally through |
|
Definition
| an entry point record and an owner record |
|
|
Term
| What types of records are defined when a hierarchical relationship is established by sets? |
|
Definition
|
|
Term
Which type of linkage would be present when the owner record points to the first member
record, the first member record points to the next member, and the last member points back to the owner? |
|
Definition
|
|
Term
What clause in the set section determines the logical placement of a new member record
added to a set? |
|
Definition
|
|
Term
| Which element of the database structure is not shown by the IMDS Data Management System (DMS) schematic? |
|
Definition
|
|
Term
When reading an IMDS Data Management System
(DMS) schematic, an off-page connector from another area is identified by an arrow pointing |
|
Definition
| from a circled number to a record |
|
|
Term
When viewing the rectangle box on an (IMDS
schematic, the area consisting of one schematic page is denoted by |
|
Definition
|
|
Term
| What is the first step in building an effective data model? |
|
Definition
| planning and requirments analysis |
|
|
Term
A column or combination of columns in a relational table that uniquely identifies a row is
called a |
|
Definition
|
|
Term
| In a relational database, the column selected as the primary key may not be |
|
Definition
|
|
Term
What type of key establishes the relationship with records in one table to records in another
table? |
|
Definition
|
|
Term
Which type of data relationship is represented when each row in a table is related to a single
row in another table? |
|
Definition
|
|
Term
| Which of the following data relationships cannot be represented in a relational database? |
|
Definition
|
|
Term
| A condition of a normalized table is for non-key items to be fully |
|
Definition
| dependent on the table?s primary key |
|
|
Term
| To normalize a database to first normal form, which of the following must be eliminated from a table? |
|
Definition
|
|
Term
| In a relational table, data in may change frequently within a |
|
Definition
|
|
Term
| Which table is part of the Relational Database Management System (RDMS) history tables? |
|
Definition
|
|
Term
Which table in the Relational Database Management System (RDMS) holds data supplied
by the Reliability and Maintainability Information System (REMIS)? |
|
Definition
|
|
Term
In what order are the tables arranged within the Relational Database Management System
(RDMS) schema? |
|
Definition
|
|
Term
| In the Relational Database Management System (RDMS) schema diagram, the tables in an area are drawn in |
|
Definition
|
|
Term
| A profile is a list of Transaction Identifier Codes (TRIC) that allows access to certain IMDS programs based on the user?s |
|
Definition
|
|
Term
The IMDS master profile Generic_User_Profile
contains |
|
Definition
| the basic TRICs that all users need. |
|
|
Term
Managing the Relational Database Management System (RDMS) tables is the responsibility
of the |
|
Definition
| Central database (CDB) database administrators (DBA) |
|
|
Term
| What are the two types of user-identification (User-ID) in the IMDS? |
|
Definition
| Transaction interface package (TIP) and DEMAND |
|
|
Term
The adding or subtracting of a transaction interface code (TRIC) with its respective options
and sub-options out of a loaded profile on an individual is known as |
|
Definition
|
|
Term
Up to how many user-identifications (User ID) can the enterprise location codes (ELC)
Profile Manager By Profile ID program load to a single Master Profile? |
|
Definition
|
|
Term
| What program can you use to display green screen authorizations? |
|
Definition
|
|
Term
| What are the two modes of operation for site management (SIMAN)? |
|
Definition
|
|
Term
| What command in site management (SIMAN) is used to update screens in screen mode? |
|
Definition
|
|
Term
What type of IMDS database errors cannot be
created by Transaction Interface Package (TIP) users? |
|
Definition
|
|
Term
| Which rollback error code normally indicates an aborted save from the night before? |
|
Definition
|
|
Term
Which database verify checks for proper placement of random records throughout a
database? |
|
Definition
|
|
Term
Which input is required to obtain a record printout of a random access locator record when
using the program random access locator (LAF)? |
|
Definition
|
|
Term
| Which of the following items is the File Inquiry (FIQ) program not able to list? |
|
Definition
|
|
Term
| How many methods of search are available through Database Look (DBLOOK)? |
|
Definition
|
|
Term
The Universal Data System Monitor (UDSMON) provides for an integrated software
environment for control and maintenance of |
|
Definition
|
|
Term
What option of the Universal Data System Monitor (UDSMON) provides the current
record, database key (DBK), and command being performed? |
|
Definition
| DMR status of individual run |
|
|
Term
What kind of problems does the IMDS/REMIS Reconciliation (RIS) program identify and
correct? |
|
Definition
|
|
Term
| The Query Language Processor (QLP) statement ESH-ENG-FLY-HRS = ?01000? represents |
|
Definition
|
|
Term
Which words in a Query Language Processor (QLP) syntax skeleton are mandatory if they
are underlined? |
|
Definition
|
|
Term
What character do you use at the end of a Query Language Processor (QLP) statement when
you want to continue the command to the next line? |
|
Definition
|
|
Term
| Query Language Processor (QLP) can be initialized online only in the |
|
Definition
|
|
Term
Which Query Language Processor (QLP) sign-off procedure purges all reports that were not
saved by use of the SAVE command? |
|
Definition
|
|
Term
Which Query Language Processor (QLP) clause allows you to specify only portions of a
data item as the selection criteria? |
|
Definition
|
|
Term
With what clause does the Query Language Processor (QLP) MACRO definition syntax
terminate? |
|
Definition
|
|
Term
| Query Language Processor (QLP) Procedures are invoked by the command |
|
Definition
|
|
Term
When printing a Query Language Processor (QLP) output, what command do you use to
activate a side-by printer? |
|
Definition
|
|
Term
The entry required to print a Query Language Processor (QLP) output to an enterprise
output manager printer with a device ID of DP0069 is the command OUTPUT TO |
|
Definition
|
|
Term
The Query Language Processor (QLP) clause that defines the explicit attributes of a derived
name is |
|
Definition
|
|
Term
The Query Language Processor (QLP) command that allows the user to specify an output
destination is |
|
Definition
|
|
Term
| An edited Query Language Processor (QLP) report is copied into the temporary savefile if |
|
Definition
| it was stored in the user or permanent savefile |
|
|
Term
Which Query Language Processor (QLP) savefile command is used to list all or specific
entities? |
|
Definition
|
|
Term
| In Structured Query Language (SQL), what clause completes the SELECT statement? |
|
Definition
|
|
Term
In Structured Query Language (SQL), what do you normally enter in the select list of a
SELECT statement? |
|
Definition
|
|
Term
In Structured Query Language (SQL), what special operator allows you to use wild card
characters in your condition criteria? |
|
Definition
|
|
Term
If used on a Query Language Processor (QLP) report, on what line do you enter the clause
FOR TRANSFER? |
|
Definition
|
|
Term
When entering SELECT statements in Interactive Processing Facility (IPF), what must
precede the SELECT statement? |
|
Definition
|
|
Term
What command is used to disconnect from the Relational Database Management System
(RDMS?2200) and end the IPF SQL session? |
|
Definition
|
|
Term
| Which FOCUS command is used to create a ?logical link? between two databases? |
|
Definition
|
|
Term
| Which G081 program is used to access, move, update, and change FOCUS reports? |
|
Definition
|
|
Term
| What option is entered in the ACT field of program F9029 to create a new FOCUS report? |
|
Definition
|
|
Term
| What IMDS programs are used to maintain an accurate account of maintenance manhours for an organization? |
|
Definition
|
|
Term
| What are examples of mainframe non-availablility causes? |
|
Definition
| Processing of classified data, Performing preventive maintenance, Corecting hardware or software, Performing computer housekeeping requirements, A terminal connected to the mainframe computer is not available |
|
|
Term
| When must a DBM provide alternate data documentation and processing plans? |
|
Definition
| In the case of system non-availability |
|
|
Term
| What are three basic methods of offline processing? |
|
Definition
| Copy IMDS screens, Input textfiles, create manual forms |
|
|
Term
| When the database comes back online who determines the recovery procedure based on the length of downtime |
|
Definition
|
|
Term
| What are the two basic procedures for data recovery once the mainframe comes back online? |
|
Definition
| manual remote and pseudo remote processing |
|
|
Term
| When the database comes back online what form ofprocessing should you use if it has only been offline for a short time? |
|
Definition
|
|
Term
| If IMDS will be unavailable for an indefinite time what must a DBM prepare and execute? |
|
Definition
|
|
Term
| What software package controls the interface between IMDS, SBSS and REMIS? |
|
Definition
|
|
Term
| Which screen is required to initiate ICI? |
|
Definition
|
|
Term
| According to AMC policies users requesting a GO81 user id for the ___ time may be required to get a letter to get a new ID. |
|
Definition
|
|
Term
| List the 5 steps that must be accomplished in IMDS in the case of an aircraft mishap procedure |
|
Definition
| Secure the Database, Run a database save, get specific aircraft details, run reports and inquiries, allow users back into the database |
|
|
Term
| After contacting the DECC what length should you request the save expiration date be changed to? |
|
Definition
|
|
Term
| What position is responsible for coordinating with functional users and affected agencies concerning loading of new system releases, special programs and changes to existing programs? |
|
Definition
|
|
Term
| What does ELSG stand for? |
|
Definition
|
|
Term
| List the 3 general functions of a DBM |
|
Definition
1. Update the database
2. Retrieve information from the database for local use
3. Reports data required by higher headquarters. |
|
|
Term
| What does "event oriented system" mean? |
|
Definition
| It means that data is entered to update the database because of an activity that occurred in the maintenance environment. |
|
|
Term
| What are the three ways a user may interface with the IMDS database? |
|
Definition
1. Remote terminals
2. Via Remote Jobe Entry Terminal Systems (RJETS)
3. Background batch programs |
|
|
Term
| What system did IMDS replace? |
|
Definition
| CAMS (Core Automated Maintenance System) |
|
|
Term
| What does REMIS stand for? |
|
Definition
| Reliability and Maintainability Information System |
|
|
Term
| What factors should be considered when developing a batch processing schedule? |
|
Definition
1. Shifts
2. Time of Day
3. Batch Program
4. DECC processing and preventative maintenance
5. Size of database
6. Support |
|
|
Term
| What are the different form of Batch programs? |
|
Definition
1. Update
2. Transfer
3. Retrieve |
|
|
Term
| What are the primary differences between NDA500 and DMU verify? |
|
Definition
NDA 500 is screen driven, DMU verify is response driven in IPF
NDA 500 is processed as a batch run DMU verify is run by the user
NDA 500 can be run with database up DMU verify cannot run with database up
NDA 500 is limited in corrections and may miss errors |
|
|
