Air Force CDC 2r051 Volume 2

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Jhomsey
J
Jhomsey
Community Contributor
Quizzes Created: 3 | Total Attempts: 378
| Attempts: 92 | Questions: 100
Please wait...
Question 1 / 100
0 %
0/100
Score 0/100
1. 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?

Explanation

If a software problem is discovered but a system advisory notice (SAN) might be delayed, the 754th Electronic Systems Group (ELSG) sends out a Heads up message (HUM) to the field right away. This allows them to inform the relevant personnel about the issue immediately, even before the SAN is sent. The HUM serves as a quick notification to ensure that the necessary actions can be taken promptly to address the software problem.

Submit
Please wait...
About This Quiz
Air Force CDC 2r051 Volume 2 - Quiz

This Air Force CDC 2R051 Volume 2 quiz focuses on the Integrated Maintenance Data System (IMDS), covering its automation of aircrew debriefing, operational concepts, and database management. Essential for personnel involved in military maintenance and data system management.

Personalize your quiz and earn a certificate with your name on it!
2. In G081, when you see three asterisks (*) in a row, it means you need to press

Explanation

In G081, the three asterisks (*) in a row indicate that the user needs to press the "enter" key to continue. This is the correct answer because the question specifically mentions the meaning of three asterisks, and the given options include "enter to continue" as one of the choices.

Submit
3. Which words in a Query Language Processor (QLP) syntax skeleton are mandatory if they are underlined?

Explanation

In a Query Language Processor (QLP) syntax skeleton, the underlined words are mandatory. The question is asking which words are mandatory, and the correct answer is "Uppercase." This suggests that in the QLP syntax skeleton, the word "Uppercase" must be included and cannot be omitted.

Submit
4. In the Relational Database Management System (RDMS) schema diagram, the tables in an area are drawn in

Explanation

The tables in an RDMS schema diagram are typically drawn in boxes to represent their structure and organization. The use of boxes allows for clear separation and identification of each table, making it easier for users to understand the relationships and connections between them. The box shape also provides a standardized and consistent visual representation for tables in RDMS schema diagrams.

Submit
5. A profile is a list of Transaction Identifier Codes (TRIC) that allows access to certain Integrated Maintenance Data System (IMDS) programs based on the user's

Explanation

The correct answer is "role". A profile is a list of Transaction Identifier Codes (TRIC) that allows access to certain Integrated Maintenance Data System (IMDS) programs based on the user's role. This means that the user's access to specific programs within the IMDS system is determined by their assigned role or position within the organization.

Submit
6. Which subsystem process does Integrated Maintenance Data System (IMDS) automate?

Explanation

The Integrated Maintenance Data System (IMDS) automates the process of aircrew debriefing. This means that IMDS is responsible for collecting and organizing data related to the debriefing of aircrew members after their flights. It streamlines the process and allows for efficient data management and analysis, ensuring that important information from the debriefing is properly recorded and utilized for maintenance and operational purposes.

Submit
7. 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

Explanation

DELTA refers to the process of adding or subtracting a transaction interface code (TRIC) with its respective options and sub-options out of a loaded profile on an individual. This process allows for the modification of the individual's profile by either adding or removing certain transaction interface codes and their associated options and sub-options.

Submit
8. What system best describes the operating concept of Integrated Maintenance Data System (IMDS)?

Explanation

The operating concept of Integrated Maintenance Data System (IMDS) is best described as event-oriented. This means that the system is designed to focus on capturing and recording specific events or incidents related to maintenance activities. It emphasizes tracking and documenting events such as repairs, inspections, and maintenance schedules, rather than being user-oriented, database-centered, or information-centered.

Submit
9. The database manager must inform users when a batch program is scheduled to be run

Explanation

The correct answer is requiring the Integrated Maintenance Data System (IMDS) online processing to be down. This answer explains that the batch program being run will require the IMDS online processing to be temporarily unavailable. This suggests that users of the database manager should be informed about this scheduled downtime so that they are aware of the potential disruption in accessing the system during that time.

Submit
10. When monitoring computer maintenance as a database manager, your efforts must be directed toward

Explanation

As a database manager responsible for monitoring computer maintenance, it is important to focus on analyzing both unscheduled and scheduled downtime. This involves examining the reasons behind the downtime, whether it is due to hardware or software issues, and identifying ways to minimize and prevent such incidents in the future. By analyzing downtime, database managers can identify patterns, make necessary updates to hardware and software, and ensure that the system is functioning optimally. This helps in maintaining the overall efficiency and reliability of the database system.

Submit
11. What type(s) of database system(s) compose the Integrated Maintenance Data System (IMDS) central database?

Explanation

The Integrated Maintenance Data System (IMDS) central database is composed of both network and relational database systems. This means that the database utilizes both the network model for organizing and structuring data as well as the relational model for managing relationships between different data tables. This combination allows for efficient storage, retrieval, and manipulation of data within the IMDS system.

Submit
12. What does the schema of a database describe?

Explanation

The schema of a database describes the physical layout of records and the logical relationships between records. This means that it outlines how the data is organized and stored within the database, including the structure of tables, fields, and relationships between them. The schema defines the framework for data storage and retrieval, allowing users to understand how the data is structured and how different pieces of information relate to each other. It does not describe the user of the database or the location of the database.

Submit
13. Which is an option for off-line processing?

Explanation

An option for off-line processing is creating input text files. This involves preparing data in a format that can be easily read and processed by a computer system. Input text files can be created offline and then later loaded into the system for processing. This method is commonly used when large amounts of data need to be processed or when data needs to be prepared in advance before being inputted into a system.

Submit
14. For which situation may the user submit an Air Force IMT 3215, C4 Systems Requirements Document regarding Integrated Maintenance Data System (IMDS)?

Explanation

The user may submit an Air Force IMT 3215, C4 Systems Requirements Document regarding Integrated Maintenance Data System (IMDS) when they want to add new capabilities to IMDS.

Submit
15. 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?

Explanation

In a one-way circular linkage, 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. This creates a circular chain where each member is linked to the next one, forming a one-way flow. This type of linkage allows for efficient traversal of the records in a specific order, starting from the owner and following the chain of members.

Submit
16. What clause in the set section determines the logical placement of a new member record added to a set?

Explanation

The clause "Order" in the set section determines the logical placement of a new member record added to a set. This means that the new member record will be placed in a specific order within the set, based on the value specified in the "Order" clause.

Submit
17. The Integrated Maintenance Data System (IMDS) master profile Generic_User_Profile contains

Explanation

The correct answer is "the basic TRICs that all users need." This means that the Integrated Maintenance Data System (IMDS) master profile Generic_User_Profile includes the essential Transaction Identifier Codes (TRICs) that are required by all users of the system. These TRICs are likely fundamental to the functioning and operation of IMDS, and therefore, every user needs access to them.

Submit
18. How many base level areas does the enterprise location code (ELC) database have?

Explanation

The enterprise location code (ELC) database has 11 base level areas.

Submit
19. Which program is used to verify program NFS760 runs each week?

Explanation

NFSRU0 is the correct answer because it is the program that is used to verify program NFS760 runs each week.

Submit
20. Which type of records comprise a majority of the Integrated Maintenance Data System (IMDS) database?

Explanation

The majority of the Integrated Maintenance Data System (IMDS) database is comprised of "Via Set" records.

Submit
21. Which option on the G081 Session Selection menu brings up the G081 Time Sharing Option (TSO) menu?

Explanation

The option "ATATS TSO" on the G081 Session Selection menu brings up the G081 Time Sharing Option (TSO) menu.

Submit
22. What is the first step in building an effective data model?

Explanation

The first step in building an effective data model is planning and requirements analysis. This involves understanding the needs and objectives of the project, gathering and documenting the requirements, and identifying the scope and constraints of the data model. This step helps in determining the purpose and goals of the data model, and lays the foundation for the subsequent steps of schema design and adding attributes to the model. By conducting thorough planning and requirements analysis, the data model can be tailored to meet the specific needs of the project and ensure its effectiveness.

Submit
23. What are the two types of user-identification (User-ID) in the Integrated Maintenance Data System (IMDS)?

Explanation

not-available-via-ai

Submit
24. Which Query Language Processor (QLP) savefile command is used to list all or specific entities?

Explanation

The PRINT command in the Query Language Processor (QLP) is used to list all or specific entities. This command allows users to retrieve and display information from the QLP database. It is commonly used to view and analyze data in a structured format. The PRINT command can be used with various parameters to specify the entities or criteria for the listing.

Submit
25. Which FOCUS command is used to create a "logical link" between two databases?

Explanation

The JOIN command is used to create a "logical link" between two databases. This command allows the user to combine data from two or more tables based on a related column or key. By using the JOIN command, the user can retrieve data from multiple databases and create a single result set. This helps in organizing and analyzing data from different sources efficiently.

Submit
26. As the result of an aircraft mishap, an Integrated Maintenance Data System (IMDS) database save tape expiration date is changed to

Explanation

The correct answer is "1 year" because the expiration date of the Integrated Maintenance Data System (IMDS) database save tape is changed to 1 year after the aircraft mishap. This means that the database save tape will remain valid and usable for a period of 1 year before it needs to be replaced or renewed.

Submit
27. 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?

Explanation

The enterprise location codes (ELC) Profile Manager By Profile ID program can load up to 25 user-identifications (User ID) to a single Master Profile.

Submit
28. A difficulty report (DIREP) is submitted when the

Explanation

When the Integrated Maintenance Data System functional manager is unable to provide a workaround for the problem, a difficulty report (DIREP) is submitted. This suggests that the functional manager has exhausted all possible solutions or alternatives to address the problem, leading to the need for a formal report to document the issue and seek further assistance or resolution.

Submit
29. The most distinguishing characteristic of a relational query language, like Structured Query Language (SQL), is

Explanation

The most distinguishing characteristic of a relational query language like SQL is its non-procedural language. This means that in SQL, the user specifies what data they want to retrieve or manipulate, rather than specifying how to retrieve or manipulate it. In other words, the user focuses on the desired outcome, and the database management system takes care of the actual steps or procedures to achieve that outcome. This non-procedural approach allows for greater flexibility and simplicity in querying and manipulating data.

Submit
30. Make sure your notification checklist includes the

Explanation

The correct answer is to include the address and phone number of each user to be notified in the notification checklist. This is important because when notifying users, it is necessary to have their contact information in order to reach out to them effectively. Including their address and phone number ensures that the notification can be sent through multiple channels and increases the chances of reaching the users in a timely manner.

Submit
31. When contacted by supply, which screen does the database manager (DBM) run for an annual Standard Reporting Designator (SRD) reconciliation?

Explanation

The correct answer is 126. This suggests that when contacted by supply, the database manager (DBM) runs screen 126 for an annual Standard Reporting Designator (SRD) reconciliation.

Submit
32. The two basic procedures for data recovery are processing

Explanation

The correct answer is pseudo remote and manual remote. These two procedures are used for data recovery. Pseudo remote refers to a method where the recovery process is done remotely, but not in real-time. It involves accessing a system or device remotely to recover the data. Manual remote, on the other hand, involves physically accessing the system or device to recover the data. Both methods are commonly used to retrieve lost or corrupted data.

Submit
33. What document is used by the Field Assistance Service to communicate with field agencies?

Explanation

The Field Assistance Service uses Heads up messages (HUM) to communicate with field agencies. These messages serve as a way to provide important information or updates to the field agencies in a timely manner. They are likely to contain urgent or time-sensitive information that needs to be communicated quickly and efficiently. The use of HUM allows for effective communication and coordination between the Field Assistance Service and the field agencies.

Submit
34. Record placement in the Integrated Maintenance Data System (IMDS) database depends on association, distribution, and

Explanation

The correct answer is "volatility". In the context of the Integrated Maintenance Data System (IMDS) database, record placement depends on the volatility of the data. Volatility refers to how frequently the data in the database changes or is updated. If the data is volatile, it may require more frequent placement or redistribution within the database to optimize performance and access.

Submit
35. Which of the following items is the File Inquiry (FIQ) program not able to list?

Explanation

The File Inquiry (FIQ) program is not able to list Work Unit Codes (WUC). The FIQ program is designed to provide information about various items, such as used event sequence numbers, unused event sequence numbers, and report control symbol (RCS) dates. However, it does not have the capability to list Work Unit Codes (WUC).

Submit
36. Which option would you select on the Time Sharing Option (TSO) Primary Option Menu in order to start the G081 User ID Maintenance Facility?

Explanation

To start the G081 User ID Maintenance Facility on the Time Sharing Option (TSO) Primary Option Menu, you would select Option S Security. This option is chosen because the User ID Maintenance Facility is related to security functions, such as creating, modifying, and deleting user IDs, and managing user access rights and permissions.

Submit
37. 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?

Explanation

The G081 manager must process the F9057 program, Terminal/User Master Record Update, in order to grant access to G081. This program is responsible for updating the terminal and user master records, which are necessary for granting access to the G081 system. Processing this program ensures that the necessary updates are made to the user IDs and terminals, allowing users to access G081.

Submit
38. Which type of data relationship is represented when each row in a table is related to a single row in another table?

Explanation

A one-to-one data relationship is represented when each row in a table is related to a single row in another table. This means that for every record in one table, there is only one corresponding record in the other table. It is a direct and unique relationship between the two tables, where each record in one table is associated with only one record in the other table.

Submit
39. Which Query Language Processor (QLP) clause allows you to specify only portions of a data item as the selection criteria?

Explanation

The MASK clause in Query Language Processor (QLP) allows you to specify only portions of a data item as the selection criteria. This means that you can define specific conditions or patterns that need to be matched in order for the data item to be included in the query results. The MASK clause is useful when you only want to retrieve certain parts of a data item rather than the entire item.

Submit
40. When printing a Query Language Processor (QLP) output, what command do you use to activate a side-by printer?

Explanation

The command @@PRNT is used to activate a side-by printer when printing a Query Language Processor (QLP) output.

Submit
41. Which element under the area section of the Integrated Maintenance Data System (IMDS) schema indicates how much space is left over?

Explanation

The element "Load" under the area section of the Integrated Maintenance Data System (IMDS) schema indicates how much space is left over. It suggests that the system is currently loaded with certain data or information, and by analyzing the load, one can determine how much space is still available in the system.

Submit
42. How many days of history does program NFS760 retain on the database?

Explanation

The program NFS760 retains no more than 92 days of history on the database.

Submit
43. You can access via set records normally through

Explanation

An entry point record and an owner record are used to access set records normally. The entry point record serves as the starting point for accessing the set records, while the owner record provides information about the set and its relationship to other records. By using these two records, one can navigate through the set records and retrieve the desired information.

Submit
44. The responsibility for initializing Interactive Communication Interface (ICI) via screen #891 lies with

Explanation

The responsibility for initializing Interactive Communication Interface (ICI) via screen #891 lies with the host database manager (DBM). This means that it is the responsibility of the host DBM to initiate the Interactive Communication Interface through screen #891.

Submit
45. 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?

Explanation

Option C of the VTAM Printing System VMCF F Printer Selection List is used to access a particular printer's command page.

Submit
46. Which of the following data relationships cannot be represented in a relational database?

Explanation

A many-to-many data relationship cannot be represented in a relational database because it violates the rules of normalization. In a many-to-many relationship, multiple records from one table are associated with multiple records from another table. In a relational database, this would require creating a separate table to represent the relationship, known as a junction or join table. This table would contain foreign keys from both tables involved in the relationship. Without this additional table, it would not be possible to accurately represent and maintain the many-to-many relationship in a relational database.

Submit
47. In a relational table, data in may change frequently within a

Explanation

In a relational table, a key field is a unique identifier for each record and is used to establish relationships between tables. The data in a key field is typically stable and does not change frequently. On the other hand, a non-key field is any other field in the table that is not used as a unique identifier. The data in a non-key field may change frequently as it represents the actual information being stored in the table. Therefore, the correct answer is non-key field.

Submit
48. In what order are the tables arranged within the Relational Database Management System (RDMS) schema?

Explanation

The tables within the Relational Database Management System (RDMS) schema are arranged in alphabetical order. This means that the tables are sorted based on their names in ascending order, following the order of the letters in the alphabet. This arrangement makes it easier to locate and access specific tables within the database, as they are organized in a logical and consistent manner.

Submit
49. What option is entered in the ACT field of program F9029 to create a new FOCUS report?

Explanation

To create a new FOCUS report in program F9029, the option "A, ADD" is entered in the ACT field. This indicates that the user wants to add a new report to the program.

Submit
50. What must you immediately do in G081 if there is an aircraft mishap?

Explanation

In the event of an aircraft mishap in G081, the immediate action that must be taken is to secure the aircraft records. This is important to ensure that all relevant information and data regarding the aircraft are protected and preserved for further investigation and analysis. By securing the aircraft records, it helps to maintain the integrity of the information and prevents any unauthorized access or tampering, which could potentially hinder the investigation process.

Submit
51. What type of Integrated Maintenance Data System (IMDS) database errors cannot be created by Transaction Interface Package (TIP) users?

Explanation

Pointer errors in an Integrated Maintenance Data System (IMDS) database cannot be created by Transaction Interface Package (TIP) users. Pointer errors occur when a database pointer, which is used to locate specific data in the database, is incorrect or points to invalid or non-existent data. TIP users do not have the ability to directly manipulate or modify database pointers, so they cannot create pointer errors.

Submit
52. What is the reason for establishing an alternate Integrated Maintenance Data System (IMDS) processing site?

Explanation

The reason for establishing an alternate Integrated Maintenance Data System (IMDS) processing site is to ensure continuous reporting of reliability and maintainability information system reportable job data documentation. This means that even if the primary processing site experiences any issues or downtime, the alternate site will be able to continue the reporting process without interruption. This helps to maintain the accuracy and availability of important data and documentation related to reliability and maintainability.

Submit
53. When reading an Integrated Maintenance Data System (IMDS) Data Management System (DMS) schematic, an off-page connector from another area is identified by an arrow pointing

Explanation

In an Integrated Maintenance Data System (IMDS) Data Management System (DMS) schematic, an off-page connector from another area is identified by an arrow pointing from a circled number to a record. This means that the circled number represents the off-page connector, indicating that the record is located on another page or in another area. The arrow shows the direction of the connection, from the circled number to the record. This helps in understanding the flow of information and connections between different parts of the schematic.

Submit
54. When viewing the rectangle box on an Integrated Maintenance Data System (IMDS) schematic, the area consisting of one schematic page is denoted by

Explanation

The correct answer is a whole number. This means that the area consisting of one schematic page is represented by a complete number, without any fractions or decimals.

Submit
55. The Query Language Processor (QLP) statement ESH-ENG-FLY-HRS = '01000' represents

Explanation

The QLP statement ESH-ENG-FLY-HRS = '01000' represents a relational expression. This is because it compares the value of the variable ESH-ENG-FLY-HRS with the string '01000' using the "=" operator, which is a relational operator. A relational expression is used to compare two values and determine their relationship, such as equality or inequality.

Submit
56. Query Language Processor (QLP) can be initialized online only in the

Explanation

In the given question, the correct answer is "DEMAND mode". This means that a Query Language Processor (QLP) can only be initialized online in DEMAND mode. This mode allows users to submit queries and retrieve information from a database on demand. It is different from other modes like EDIT mode, ECHO mode, and Transaction Interface Package (TIP) mode, which have different functionalities and purposes.

Submit
57. With what clause does the Query Language Processor (QLP) MACRO definition syntax terminate?

Explanation

The Query Language Processor (QLP) MACRO definition syntax terminates with the clause "END-MACRO". This indicates the end of the macro definition and allows the processor to proceed with executing the rest of the query.

Submit
58. In Structured Query Language (SQL), what do you normally enter in the select list of a SELECT statement?

Explanation

In the select list of a SELECT statement in SQL, you typically enter column names. The select list specifies the columns that you want to retrieve from the table or tables specified in the FROM clause. By specifying the column names, you can control which data is returned in the result set.

Submit
59. Which clause in the record section of the Integrated Maintenance Data System (IMDS) schema defines the areas where the records can be found?

Explanation

The data identifier clause in the record section of the Integrated Maintenance Data System (IMDS) schema defines the areas where the records can be found. This clause provides a unique identifier for each record, allowing users to easily locate and access specific records within the system. The data identifier serves as a reference point for organizing and retrieving records based on their assigned identifier.

Submit
60. Which database verify checks for proper placement of random records throughout a database?

Explanation

The database verify check for proper placement of random records throughout a database is CALC.

Submit
61. What types of records are defined when a hierarchical relationship is established by sets?

Explanation

When a hierarchical relationship is established by sets, the types of records that are defined are "Owner" and "member". In this context, the "Owner" record represents the higher-level entity or set, while the "member" record represents the lower-level entity or set that is associated with the owner. This relationship allows for the organization and representation of data in a hierarchical structure, where each owner can have multiple members.

Submit
62. 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

Explanation

The correct answer is "DEVICE DP0069" because the command "DEVICE" is used to specify the device to which the output should be sent, and "DP0069" is the device ID for the enterprise output manager printer.

Submit
63. 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?

Explanation

The Defense Data Network (DDN) Address Record interface program provides a list of all files that have been received from or transmitted to REMIS within the last 72 hours. This program is specifically designed to track and manage the communication between REMIS and other systems, ensuring the reliability and maintainability of the information being transmitted. By using the DDN Address Record interface program, users can easily monitor the flow of files and identify any potential issues or errors that may have occurred during the transmission process.

Submit
64. In a relational database,

Explanation

In a relational database, the primary key field is a unique identifier for each row in a table. It ensures that each row has a distinct identity and cannot be null. This means that the column selected as the primary key field cannot have missing or null values.

Submit
65. What type of key establishes the relationship with records in one table to records in another table?

Explanation

A foreign key is a type of key that establishes the relationship between records in one table to records in another table. It is used to link the primary key of one table to the foreign key of another table, creating a relationship between the two tables. This allows for data integrity and ensures that the relationship between the tables is maintained.

Submit
66. Implement pseudo processing when

Explanation

When the system is unavailable for a long time, it is necessary to implement pseudo processing. Pseudo processing refers to simulating the processing of transactions or data entries without actually performing them in real-time. This allows the system to continue functioning and accepting inputs even when the actual processing is not possible. Pseudo processing can be used as a temporary solution until the system comes back online or the issue causing the unavailability is resolved.

Submit
67. Which rollback error code normally indicates an aborted save from the night before?

Explanation

Rollback error code 14 typically indicates an aborted save from the night before. This means that a previous save operation was interrupted or not completed successfully, leading to the need for a rollback. The specific error code 14 is commonly associated with this type of situation, indicating that the save process was halted or failed during the previous night's operation.

Submit
68. Within the Relational Database Management System (RDMS) section of the central database (CDB), reference tables that include equipment and aircraft are provided by 

Explanation

not-available-via-ai

Submit
69. A difficulty report (DIREP) in Integrated Maintenance Data System (IMDS) is used when

Explanation

The correct answer is IMDS is not operating as designed. This means that a difficulty report (DIREP) in Integrated Maintenance Data System (IMDS) is used when the system is not functioning according to its intended design and there is a need to address and resolve the issue. This could include errors, bugs, or malfunctions in the IMDS software or hardware that need to be reported and fixed.

Submit
70. To normalize a database to first normal form, which of the following must be eliminated from a table?

Explanation

To normalize a database to first normal form, repeating groups of data must be eliminated from a table. Repeating groups occur when multiple values are stored in a single attribute, violating the atomicity principle of database normalization. By removing repeating groups and storing each value in a separate attribute, the table can be organized in a more structured and efficient manner. This helps to eliminate data redundancy and improve data integrity in the database.

Submit
71. An edited Query Language Processor (QLP) report is copied into the temporary savefile if

Explanation

The edited Query Language Processor (QLP) report is copied into the temporary savefile if it was stored in the user or permanent savefile.

Submit
72. In Structured Query Language (SQL), what special operator allows you to use wild card characters in your condition criteria?

Explanation

The "Like" operator in SQL allows you to use wild card characters in your condition criteria. This operator is used in conjunction with the "%" symbol to match patterns in the data. The "%" symbol represents any sequence of characters, while "_" represents a single character. This operator is commonly used in conjunction with the "Where" clause to filter data based on specific patterns or conditions.

Submit
73. Which G081 program is used to access, move, update, and change FOCUS reports?

Explanation

F9029 is the correct answer because it is the G081 program that is used to access, move, update, and change FOCUS reports. This program provides users with the necessary functionality to interact with FOCUS reports and make any necessary modifications or updates to them.

Submit
74. What command in site management (SIMAN) is used to update screens in screen mode?

Explanation

The command "COMMIT" in site management (SIMAN) is used to update screens in screen mode. This command is typically used when making changes or updates to the screens and ensures that the changes are applied and saved. It confirms and finalizes the modifications made to the screens, making them effective and visible to users.

Submit
75. What kind of problems does the Integrated Maintenance Data Systems/Reliability and Maintainability Information System (IMDS)/(REMIS) Reconciliation (RIS) program identify and correct?

Explanation

The Integrated Maintenance Data Systems/Reliability and Maintainability Information System (IMDS)/(REMIS) Reconciliation (RIS) program identifies and corrects C-E status and inventory issues.

Submit
76. Which element of the database structure is not shown by the Integrated Maintenance Data System (IMDS) Data Management System (DMS) schematic?

Explanation

The Integrated Maintenance Data System (IMDS) Data Management System (DMS) schematic does not show the element of "Page" in the database structure.

Submit
77. 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?

Explanation

In a Query Language Processor (QLP) statement, the semicolon (;) is used at the end of the statement when you want to continue the command to the next line. This allows for better readability and organization of the code by breaking long commands into multiple lines. The semicolon acts as a delimiter, indicating the end of one command and the start of the next one.

Submit
78. Which Query Language Processor (QLP) sign-off procedure purges all reports that were not saved by use of the SAVE command?

Explanation

The EXIT command is used to exit the Query Language Processor (QLP). When the EXIT command is executed, it terminates the QLP session and any unsaved reports are purged. Therefore, the correct answer is EXIT.

Submit
79. A condition of a normalized table is for non-key items to be fully

Explanation

In a normalized table, the non-key items should be fully dependent on the table's primary key. This means that the values of the non-key items should be determined solely by the value of the primary key and not by any other factors. This ensures that each attribute in the table is directly related to the primary key and eliminates any redundancy or inconsistency in the data. By being fully dependent on the primary key, the non-key items can be uniquely identified and retrieved from the table.

Submit
80. How many options are there for program NFS7U0?

Explanation

There are 3 options for program NFS7U0.

Submit
81. Which Reliability and Maintainability Information System (REMIS) interface program reschedules REMIS inventory reconciliations?

Explanation

The Defense Data Network (DDN) address record is the correct answer because it is the interface program in the Reliability and Maintainability Information System (REMIS) that reschedules REMIS inventory reconciliations. This program is responsible for managing and updating the DDN address records, which are essential for maintaining the accuracy and reliability of the REMIS inventory system.

Submit
82. What command is used to disconnect from the Relational Database Management System (RDMS–2200) and end the IPF SQL session?

Explanation

The command 'SQL END THREAD' is used to disconnect from the Relational Database Management System (RDMS-2200) and end the IPF SQL session.

Submit
83. What program can you use to display green screen authorizations?

Explanation

Delta Table report is the correct answer because this program can be used to display green screen authorizations. The other options, Device Maintenance, Master Profile report, and Master Profile manager, do not specifically mention the ability to display green screen authorizations.

Submit
84. A column or combination of columns in a relational table that uniquely identifies a row is called a

Explanation

A key in a relational table is a column or combination of columns that uniquely identifies a row. It is used to ensure the uniqueness of each row in the table and to establish relationships between tables. Keys can be primary keys, which uniquely identify each row in a table, or they can be foreign keys, which establish a relationship between two tables. In this context, the correct answer is "key".

Submit
85. The Query Language Processor (QLP) command that allows the user to specify an output destination is

Explanation

The correct answer is "GENERATE" because it is the QLP command that allows the user to specify an output destination. This command is used to generate output files or reports and the user can specify the destination where the generated output should be stored.

Submit
86. Managing the Relational Database Management System (RDMS) tables is the responsibility of the

Explanation

The responsibility of managing the Relational Database Management System (RDMS) tables lies with the Central Database (CDB) database administrators (DBA). They are responsible for maintaining and ensuring the smooth functioning of the database tables within the central database. This includes tasks such as creating, modifying, and deleting tables, as well as optimizing database performance and ensuring data integrity. The CDB DBAs have the necessary expertise and authority to manage the database tables effectively.

Submit
87. What option of the Universal Data System Monitor (UDSMON) provides the current record, database key (DBK), and command being performed?

Explanation

The DMR status of individual run in the Universal Data System Monitor (UDSMON) provides the current record, database key (DBK), and command being performed. This option allows users to track and monitor the status of each individual run in the system, providing information about the specific record being processed, the corresponding database key, and the command that is being executed. By accessing the DMR status of individual run, users can gain insights into the real-time progress and details of each run in the system.

Submit
88. Which input is required to obtain a record printout of a random access locator record when using the program random access locator (LAF)?

Explanation

To obtain a record printout of a random access locator record when using the program random access locator (LAF), the input required is the CALC key. The CALC key is used to calculate and retrieve the specific record from the database. It allows the program to locate and access the desired record for printing. The transaction identification code key, database key, and control key are not specifically mentioned as inputs for obtaining a record printout in this context.

Submit
89. The Query Language Processor (QLP) clause that defines the explicit attributes of a derived name is

Explanation

not-available-via-ai

Submit
90. Which utility program requires that the database be down when you run this program?

Explanation

A data management utility verifies the integrity and consistency of a database by performing various checks and validations. In order to ensure accurate results, it is necessary for the database to be offline or down when running this program. This is because any changes made to the database while it is online could affect the verification process and lead to inaccurate results. Therefore, the data management utility requires the database to be offline before it can be run.

Submit
91. Which table in the Relational Database Management System (RDMS) holds data supplied by the Reliability and Maintainability Information System (REMIS)?

Explanation

The table in the RDMS that holds data supplied by the REMIS is the "Reference" table. This table is specifically designed to store and manage reference data, which is information that is used as a standard or point of comparison. In the context of the REMIS, it is likely that the reference table would hold data such as industry standards, guidelines, or benchmarks that are used to assess the reliability and maintainability of systems.

Submit
92. In Structured Query Language (SQL), what clause completes the SELECT statement?

Explanation

The FROM clause completes the SELECT statement in SQL. This clause specifies the table or tables from which the data will be retrieved. It is used to specify the source of the data for the query.

Submit
93. When entering SELECT statements in Interactive Processing Facility (IPF), what must precede the SELECT statement?

Explanation

In Interactive Processing Facility (IPF), the SELECT statement is used to retrieve data from a database. In order to properly execute the SELECT statement, the keyword "SQL" must precede it. This is because "SQL" is the language used to interact with the database and perform operations such as querying and retrieving data. Therefore, in IPF, before entering a SELECT statement, the keyword "SQL" must be included to indicate that it is an SQL command.

Submit
94. How many methods of search are available through Database Look (DBLOOK)?

Explanation

DBLOOK provides four methods of search in a database.

Submit
95. Within Integrated Maintenance Data System (IMDS), a direct type of record has its database key assigned and controlled by the

Explanation

The correct answer is Electronic Systems Group (ELSG) database administrator. Within the Integrated Maintenance Data System (IMDS), a direct type of record has its database key assigned and controlled by the ELSG database administrator.

Submit
96. What are the two modes of operation for site management (SIMAN)?

Explanation

The two modes of operation for site management (SIMAN) are screen and batch. In the screen mode, users interact with the system through a graphical user interface (GUI) where they can input and view data in real-time. This mode allows for immediate feedback and is useful for tasks that require quick response and decision-making. In the batch mode, users can submit multiple tasks or jobs to be processed in the background without immediate user interaction. This mode is suitable for tasks that can be automated and do not require real-time user input.

Submit
97. Query Language Processor (QLP) Procedures are invoked by the command

Explanation

The correct answer is "CALL". QLP procedures are typically invoked by using the CALL command. This command is used to execute a specific procedure or subroutine within the Query Language Processor. The CALL command allows the program to transfer control to the specified procedure and execute the code within it. This is a common way to execute QLP procedures and is the correct answer in this context.

Submit
98. Which table is part of the Relational Database Management System (RDMS) history tables?

Explanation

The "Status and inventory" table is part of the Relational Database Management System (RDMS) history tables. This table keeps track of the status and inventory information within the RDMS, allowing for historical analysis and monitoring of changes over time. It is an essential component of the RDMS system support and provides valuable data for managing and optimizing the database.

Submit
99. The Universal Data System Monitor (UDSMON) provides for an integrated software environment for control and maintenance of

Explanation

The Universal Data System Monitor (UDSMON) is a software system that allows for the control and maintenance of various components, including the data management utility (DMU) processor, executive system software, Air Force data systems, and user databases. Therefore, the correct answer is user databases, as UDSMON is designed to provide an integrated software environment for managing and maintaining user databases.

Submit
100. If used on a Query Language Processor (QLP) report, on what line do you enter the clause FOR TRANSFER?

Explanation

The clause FOR TRANSFER is entered on the line of the REPORT command when used on a Query Language Processor (QLP) report.

Submit
View My Results

Quiz Review Timeline (Updated): Dec 14, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Dec 14, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Sep 25, 2013
    Quiz Created by
    Jhomsey
Cancel
  • All
    All (100)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
What does the 754th Electronic Systems Group (ELSG) send out to the...
In G081, when you see three asterisks (*) in a row, it means you need...
Which words in a Query Language Processor (QLP) syntax skeleton are...
In the Relational Database Management System (RDMS) schema diagram,...
A profile is a list of Transaction Identifier Codes (TRIC) that allows...
Which subsystem process does Integrated Maintenance Data System (IMDS)...
The adding or subtracting of a transaction interface code (TRIC) with...
What system best describes the operating concept of Integrated...
The database manager must inform users when a batch program is...
When monitoring computer maintenance as a database manager, your...
What type(s) of database system(s) compose the Integrated Maintenance...
What does the schema of a database describe?
Which is an option for off-line processing?
For which situation may the user submit an Air Force IMT 3215, C4...
Which type of linkage would be present when the owner record points to...
What clause in the set section determines the logical placement of a...
The Integrated Maintenance Data System (IMDS) master profile...
How many base level areas does the enterprise location code (ELC)...
Which program is used to verify program NFS760 runs each week?
Which type of records comprise a majority of the Integrated...
Which option on the G081 Session Selection menu brings up the G081...
What is the first step in building an effective data model?
What are the two types of user-identification (User-ID) in the...
Which Query Language Processor (QLP) savefile command is used to list...
Which FOCUS command is used to create a "logical link" between two...
As the result of an aircraft mishap, an Integrated Maintenance Data...
Up to how many user-identifications (User ID) can the enterprise...
A difficulty report (DIREP) is submitted when the
The most distinguishing characteristic of a relational query language,...
Make sure your notification checklist includes the
When contacted by supply, which screen does the database manager (DBM)...
The two basic procedures for data recovery are processing
What document is used by the Field Assistance Service to communicate...
Record placement in the Integrated Maintenance Data System (IMDS)...
Which of the following items is the File Inquiry (FIQ) program not...
Which option would you select on the Time Sharing Option (TSO) Primary...
In addition to creating a new G081 User ID in the G081 User ID...
Which type of data relationship is represented when each row in a...
Which Query Language Processor (QLP) clause allows you to specify only...
When printing a Query Language Processor (QLP) output, what command do...
Which element under the area section of the Integrated Maintenance...
How many days of history does program NFS760 retain on the database?
You can access via set records normally through
The responsibility for initializing Interactive Communication...
Which option of the virtual telecommunications access method (VTAM)...
Which of the following data relationships cannot be represented in a...
In a relational table, data in may change frequently within a
In what order are the tables arranged within the Relational Database...
What option is entered in the ACT field of program F9029 to create a...
What must you immediately do in G081 if there is an aircraft mishap?
What type of Integrated Maintenance Data System (IMDS) database errors...
What is the reason for establishing an alternate Integrated...
When reading an Integrated Maintenance Data System (IMDS) Data...
When viewing the rectangle box on an Integrated Maintenance Data...
The Query Language Processor (QLP) statement ESH-ENG-FLY-HRS = '01000'...
Query Language Processor (QLP) can be initialized online only in the
With what clause does the Query Language Processor (QLP) MACRO...
In Structured Query Language (SQL), what do you normally enter in the...
Which clause in the record section of the Integrated Maintenance Data...
Which database verify checks for proper placement of random records...
What types of records are defined when a hierarchical relationship is...
The entry required to print a Query Language Processor (QLP) output to...
Which Reliability and Maintainability Information System (REMIS)...
In a relational database,
What type of key establishes the relationship with records in one...
Implement pseudo processing when
Which rollback error code normally indicates an aborted save from the...
Within the Relational Database Management System (RDMS) section of the...
A difficulty report (DIREP) in Integrated Maintenance Data System...
To normalize a database to first normal form, which of the following...
An edited Query Language Processor (QLP) report is copied into the...
In Structured Query Language (SQL), what special operator allows you...
Which G081 program is used to access, move, update, and change FOCUS...
What command in site management (SIMAN) is used to update screens in...
What kind of problems does the Integrated Maintenance Data...
Which element of the database structure is not shown by the Integrated...
What character do you use at the end of a Query Language Processor...
Which Query Language Processor (QLP) sign-off procedure purges all...
A condition of a normalized table is for non-key items to be fully
How many options are there for program NFS7U0?
Which Reliability and Maintainability Information System (REMIS)...
What command is used to disconnect from the Relational Database...
What program can you use to display green screen authorizations?
A column or combination of columns in a relational table that uniquely...
The Query Language Processor (QLP) command that allows the user to...
Managing the Relational Database Management System (RDMS) tables is...
What option of the Universal Data System Monitor (UDSMON) provides the...
Which input is required to obtain a record printout of a random access...
The Query Language Processor (QLP) clause that defines the explicit...
Which utility program requires that the database be down when you run...
Which table in the Relational Database Management System (RDMS) holds...
In Structured Query Language (SQL), what clause completes the SELECT...
When entering SELECT statements in Interactive Processing Facility...
How many methods of search are available through Database Look...
Within Integrated Maintenance Data System (IMDS), a direct type of...
What are the two modes of operation for site management (SIMAN)?
Query Language Processor (QLP) Procedures are invoked by the command
Which table is part of the Relational Database Management System...
The Universal Data System Monitor (UDSMON) provides for an integrated...
If used on a Query Language Processor (QLP) report, on what line do...
Alert!

Advertisement