Maintainence Management Analysis Volume 2 CDC 2r051

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 Magniciousx
M
Magniciousx
Community Contributor
Quizzes Created: 3 | Total Attempts: 975
| Attempts: 353 | Questions: 100
Please wait...
Question 1 / 100
0 %
0/100
Score 0/100
1. (206) 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 means that they would immediately send a message to inform the relevant personnel about the software problem, even before the official advisory notice is released. This allows for timely communication and potential mitigation of any issues that may arise from the software problem.

Submit
Please wait...
About This Quiz
Maintenance Management Quizzes & Trivia

This is the second volume of multiple choice CDC Volume 2 2R051

2. (202) The database manager must inform users when a batch program is scheduled to be run

Explanation

The correct answer is d. requiring the Integrated Maintenance Data System (IMDS) online processing to be down. This answer is correct because it states that the batch program being run will require the IMDS online processing to be down. This means that users will not be able to access the IMDS system during the time the batch program is running. Informing users of this downtime is important so that they are aware of the temporary unavailability of the system and can plan their work accordingly.

Submit
3. (216) 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, which organizes data in a hierarchical structure, and the relational model, which organizes data in tables with relationships between them. This combination allows for efficient storage and retrieval of data, as well as the ability to handle complex relationships between different data entities.

Submit
4. (222) 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, but the owner record does not have a direct link to the last member. This type of linkage allows for easy traversal of the chain starting from the owner record and going through each member in a sequential manner.

Submit
5. (201) 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 focuses on capturing and recording specific events, such as maintenance actions or repairs, rather than being centered around users, databases, or general information. The event-oriented approach ensures that all relevant information related to a specific event is properly documented and can be easily accessed and analyzed.

Submit
6. (202) Make sure your notification checklist includes the

Explanation

The correct answer is d. address and phone number of each user to be notified. This is because in order to notify users, their contact information such as address and phone number is necessary. The other options, a, b, and c, do not provide any relevant information for notifying users.

Submit
7. (204) How many days of history does program NFS760 retain on the database?

Explanation

The program NFS760 retains a maximum of 92 days of history on the database. This means that the program may retain fewer than 92 days of history, but it will not retain more than that.

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

Explanation

In the Relational Database Management System (RDMS) schema diagram, the tables in an area are drawn in boxes. This is because boxes are commonly used to represent tables in schema diagrams. Each box represents a table and contains the name of the table. The columns of the table are also shown within the box, along with their data types. This visual representation helps to easily identify and understand the structure of the database, making it easier to design and manage the database efficiently.

Submit
9. (204) Which program is used to verify program NFS760 runs each week?

Explanation

The correct answer is d. NFSRU0. The program NFSRU0 is used to verify program NFS760 runs each week.

Submit
10. (205) 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 can take over and ensure that the reporting of important data is not interrupted. This is crucial for maintaining an accurate and up-to-date record of reliability and maintainability information.

Submit
11. (211) In G081, when you see three asterisks (*) in a row, it means you need to press

Explanation

In G081, when you see three asterisks (*) in a row, it means you need to press enter to continue. This is because the question states that the three asterisks indicate a specific action that needs to be taken, and out of the given options, pressing enter is the correct action to continue.

Submit
12. (212) 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 needs to process the F9057 program, Terminal/User Master Record Update, in order to grant access to G081. This program is responsible for updating the master record of terminals and users, which includes creating new user IDs. Therefore, it is the appropriate program for the G081 manager to use in order to grant access.

Submit
13. (205) The two basic procedures for data recovery are processing

Explanation

The correct answer is c. pseudo remote and manual remote. This means that there are two basic procedures for data recovery: pseudo remote and manual remote. Pseudo remote refers to a method where data recovery is done using a remote connection, but not in real-time. Manual remote, on the other hand, involves physically accessing the device and recovering the data manually. Both procedures are commonly used in data recovery processes.

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

Explanation

Option d. ATATS TSO brings up the G081 Time Sharing Option (TSO) menu.

Submit
15. (204) 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 a. 126. The annual Standard Reporting Designator (SRD) reconciliation is performed by the database manager (DBM) when contacted by supply. The specific screen used for this reconciliation is screen 126.

Submit
16. (231) 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

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 is determined by their assigned role. The role could be a job position or a specific level of authority within the organization.

Submit
17. (201) 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 information from aircrew members after a flight or mission. It helps to streamline the debriefing process and ensures that important data is recorded accurately and efficiently. By automating this subsystem process, IMDS can help to improve communication and analysis within the aviation maintenance system.

Submit
18. (202) When monitoring computer maintenance as a database manager, your efforts must be directed toward

Explanation

As a database manager, monitoring computer maintenance involves analyzing both unscheduled and scheduled downtime. Unscheduled downtime refers to unexpected disruptions or failures in the system, while scheduled downtime refers to planned maintenance activities. By analyzing both types of downtime, the database manager can identify patterns, root causes, and potential solutions to minimize disruptions and optimize system performance. This analysis helps in improving the overall efficiency and reliability of the computer system.

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

Explanation

A difficulty report (DIREP) is submitted when the Integrated Maintenance Data System functional manager cannot provide a workaround for the problem. This means that when the functional manager is unable to find a solution or temporary fix for the issue, a DIREP is submitted to report the problem and seek further assistance. This indicates that the DIREP is used as a means to escalate and address unresolved issues within the system.

Submit
20. (243) 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. Therefore, the correct answer is c. Uppercase. This means that when using the QLP, the words must be written in uppercase letters in order for the syntax to be correct.

Submit
21. (215) What must you immediately do in G081 if there is an aircraft mishap?

Explanation

In G081, if there is an aircraft mishap, the immediate action that must be taken is to secure the aircraft records. This is important to ensure that all relevant information regarding the aircraft is preserved and protected for investigation and analysis purposes. Securing the aircraft records will help in determining the cause of the mishap and taking appropriate measures to prevent similar incidents in the future.

Submit
22. (216) 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 instead of specifying how to retrieve the data, the user only needs to specify what data they want to retrieve. The database management system then determines the most efficient way to retrieve the data. This allows for a more declarative and intuitive approach to querying the database, as the user does not need to worry about the implementation details.

Submit
23. (207) 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) in order to add new capabilities to IMDS. This document allows the user to outline the specific requirements and details for the desired new capabilities that they want to integrate into the IMDS system. By submitting this document, the user is requesting the necessary changes and enhancements to be made to the IMDS system in order to accommodate the new capabilities.

Submit
24. (233) 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

The process described in the question, where a transaction interface code (TRIC) and its options and sub-options are added or subtracted from a loaded profile on an individual, is known as a DELTA.

Submit
25. (206) 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, updates, and alerts to the field agencies in a timely manner. They are typically used to address urgent issues or changes that require immediate attention or action from the field agencies.

Submit
26. (212) 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 for Security. This suggests that the G081 User ID Maintenance Facility is related to security functions or user ID management within the TSO system.

Submit
27. (214) 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 d. 1 year. In an aircraft mishap, the expiration date of the Integrated Maintenance Data System (IMDS) database save tape is changed to 1 year. This means that the data on the tape will remain valid and usable for a period of one year before it needs to be updated or replaced. This allows for sufficient time to analyze and investigate the mishap, as well as to ensure that the necessary maintenance and repairs are carried out.

Submit
28. (223) 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. a whole number. In the context of an Integrated Maintenance Data System (IMDS) schematic, the area consisting of one schematic page is denoted by a whole number. This means that the area code used to represent the schematic page is a complete number without any fractions or decimals. This helps in easily identifying and referencing specific schematic pages within the IMDS system.

Submit
29. (256) 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 data from multiple tables or databases to be combined based on a common field or key. By using the JOIN command, users can retrieve data from different databases and create a virtual table that contains information from both sources. This enables efficient data analysis and reporting by consolidating data from multiple sources into a single view.

Submit
30. (234) 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
31. (220) Record placement in the Integrated Maintenance Data System (IMDS) database depends on association, distribution, and

Explanation

The correct answer is b. volatility. Record placement in the Integrated Maintenance Data System (IMDS) database depends on volatility, which refers to how frequently the data is accessed or updated. The more volatile the data, the more frequently it needs to be accessed and updated, and therefore it may be placed in a location that allows for faster access. This ensures that frequently accessed or updated data is readily available and can be efficiently managed within the database.

Submit
32. (209) 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 data base manager (DBM). This means that the DBM is responsible for setting up and initiating the ICI through the screen #891. The DBM is in charge of managing and controlling the database, so it makes sense that it would be responsible for initializing the ICI.

Submit
33. (218) 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 includes information about how the data is organized, such as the tables, fields, and relationships between them. The schema defines the structure and organization of the database, allowing users to understand how the data is stored and how it can be accessed. It does not describe the user of the database or the location of the database, and it goes beyond just physical relationships between different areas.

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

Explanation

The correct answer is b. 11. The question is asking about the number of base level areas in the enterprise location code (ELC) database. The ELC database has a total of 11 base level areas.

Submit
35. (222) What clause in the set section determines the logical placement of a new member record added to a set?

Explanation

The clause in the set section that determines the logical placement of a new member record added to a set is the "Order" clause. This clause specifies the sequence in which the member records are organized within the set. By defining the order, the system knows where to place the new record in relation to the existing records in the set.

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

Explanation

The Integrated Maintenance Data System (IMDS) master profile Generic_User_Profile contains the basic TRICs that all users need. This means that the profile includes the essential transaction identifier codes (TRIC) that are required by all users of the IMDS system. These basic TRICs are necessary for users to perform their maintenance tasks effectively and efficiently. The profile does not include all the transaction identifiers codes (TRIC) in IMDS, the basic TRICs for maintenance analysts only, or all the enterprise location codes (ELC) in IMDS.

Submit
37. (205) Which is an option for off-line processing?

Explanation

Creating input text files is an option for off-line processing because it allows for the collection and storage of data that can be processed at a later time. By creating input text files, data can be gathered from various sources and organized in a format that can be easily read and manipulated by a computer program. This method is often used when there is a large volume of data to be processed or when the processing needs to be done at a different time or location from where the data is collected.

Submit
38. (210) 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 that reschedules REMIS inventory reconciliations. This program is responsible for managing the communication and data exchange between REMIS and the DDN, ensuring that inventory reconciliations are scheduled and completed accurately and on time.

Submit
39. (210) 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 allows users to track and monitor the data exchange between REMIS and other systems. It ensures that all files are properly transmitted and received, enhancing the reliability and maintainability of the REMIS system.

Submit
40. (224) 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 goals of the project, identifying the data that needs to be captured and analyzed, and determining the relationships and dependencies between different data elements. By conducting thorough planning and requirements analysis, the data model can be designed in a way that accurately represents the organization's data and supports its business objectives. This step is crucial in ensuring that the data model aligns with the organization's needs and sets a solid foundation for the rest of the data modeling process.

Submit
41. (226) Which of the following data relationships cannot be represented in a relational database?

Explanation

A many-to-many data relationship refers to a situation where multiple records in one table are associated with multiple records in another table. This type of relationship cannot be directly represented in a relational database because it violates the fundamental principle of relational databases, which is to have a single value in each cell of a table. To represent a many-to-many relationship, a junction table or an associative entity is used to break it down into two one-to-many relationships, which can be represented in a relational database.

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

Explanation

The correct answer is b. IMDS is not operating as designed. This means that when there is a problem with the Integrated Maintenance Data System (IMDS) and it is not functioning according to its intended design or specifications, a difficulty report (DIREP) is used to report and address the issue. This helps to identify and resolve any operational problems or malfunctions in the IMDS system. The other options are not relevant to the purpose of a DIREP in IMDS.

Submit
43. (205) Implement pseudo processing when

Explanation

not-available-via-ai

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

Explanation

The reference tables that include equipment and aircraft in the RDMS section of the CDB are provided by the Reliability and Maintainability Information System (REMIS). This system is specifically designed to track and manage information related to the reliability and maintainability of equipment and aircraft. It is likely that REMIS collects and stores data from various sources, such as maintenance records and performance data, to provide accurate and up-to-date information for the reference tables in the RDMS.

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

Explanation

The correct answer is c. DEMAND mode. The Query Language Processor (QLP) can only be initialized online in DEMAND mode. This mode allows users to submit ad-hoc queries and retrieve data on-demand. It is a real-time mode that provides immediate results to user queries. The other options, such as EDIT mode, ECHO mode, and Transaction Interface Package (TIP) mode, do not support online initialization of the QLP.

Submit
46. (213) 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 is used to access a particular printer's command page in the VTAM Printing System VMCF F Printer Selection List.

Submit
47. (204) How many options are there for program NFS7U0?

Explanation

There are three options available for program NFS7U0.

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

Explanation

To activate a side-by printer when printing a Query Language Processor (QLP) output, the command to use is @@PRNT. This command is specific to QLP and is used to activate the side-by printer. The double @ symbol indicates that it is a special command in QLP. The other options (a, b, and c) are not the correct commands to activate a side-by printer in QLP.

Submit
49. (229) 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 and organized based on the names of the tables in ascending order, following the order of the letters in the alphabet. This arrangement helps in easily locating and accessing specific tables within the database, as well as maintaining a systematic and organized structure for the database management system.

Submit
50. (225) 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 two tables together by referencing the primary key of one table as a foreign key in another table. This allows for the establishment of relationships and maintains data integrity within a database system.

Submit
51. (238) 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 the used and unused event sequence numbers and the report control symbol (RCS) dates. However, it does not have the capability to list the work unit codes.

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

Explanation

In order to create a new FOCUS report, the option that needs to be entered in the ACT field of program F9029 is "A, ADD". This option indicates that a new report is being added to the system. The other options, such as "S, SAVE", "M, MOVE", and "U, UPDATE", are not relevant for creating a new report.

Submit
53. (243) 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 to indicate that the command should continue to the next line. It is a common convention in many programming languages and query languages to use the semicolon as a statement terminator. This allows for better readability and organization of the code by breaking the command into multiple lines without affecting its functionality. The other options, comma (,), ellipsis (...), and asterisk (*), do not serve the purpose of indicating continuation of the command to the next line.

Submit
54. (221) You can access via set records normally through

Explanation

To access set records normally, you need both an entry point record and an owner record. The entry point record serves as a starting point for accessing the set, while the owner record identifies the record that owns the set. By using both records, you can navigate through the set and retrieve the desired data items efficiently. Using key data items in the record, a database pointer, or a database key alone would not be sufficient for accessing set records normally.

Submit
55. (222) What types of records are defined when a hierarchical relationship is established by sets?

Explanation

When a hierarchical relationship is established by sets, two types of records are defined: owner and member. The owner record represents the higher-level entity in the hierarchy, while the member record represents the lower-level entity that is associated with the owner. This type of relationship allows for the organization and management of data in a hierarchical structure, where each member is linked to its respective owner.

Submit
56. (222) 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". The "Owner" record represents the parent or superior entity in the hierarchy, while the "Member" record represents the child or subordinate entity. This relationship allows for the organization and categorization of data in a hierarchical structure, with each member being associated with a specific owner.

Submit
57. (223) 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 indicates that the circled number represents a reference to another page or location, and the arrow is pointing towards the record that contains the detailed information. This helps in navigating the schematic and finding the relevant information easily.

Submit
58. (225) In a relational database,

Explanation

In a relational database, the primary key is a column or a combination of columns that uniquely identifies each row in a table. It is used to ensure data integrity and enforce uniqueness. The primary key field cannot be null because it must have a value in order to uniquely identify each row. If the primary key field allows null values, it would defeat the purpose of having a primary key. Therefore, option b is the correct answer.

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

Explanation

The CALC key is required to obtain a record printout of a random access locator record when using the program random access locator (LAF). This suggests that the CALC key performs a calculation or operation that retrieves and prints the desired record. The other options, such as the transaction identification code key, database key, and control key, do not seem to be directly related to obtaining a record printout in this context.

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

Explanation

not-available-via-ai

Submit
61. (245) 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 the Query Language Processor (QLP) allows you to specify only portions of a data item as the selection criteria. This means that you can choose specific parts of a data item to be included in the selection process, rather than selecting the entire item. This can be useful when you only need to work with certain attributes or fields within a larger data item. The LIST, SORT, and LIST IN COLUMN clauses do not have this capability.

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

Explanation

The special operator "Like" in Structured Query Language (SQL) allows you to use wild card characters in your condition criteria. With the "Like" operator, you can search for patterns in the data by using wild card characters such as "%" (matches any sequence of characters) and "_" (matches any single character). This operator is commonly used in conjunction with the "Where" clause to filter and retrieve specific data based on pattern matching.

Submit
63. (235) 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 used to save any changes or updates made to the screens and make them permanent. By using the "COMMIT" command, any modifications made to the screens will be saved and reflected in the system.

Submit
64. (232) 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 falls on the Central database (CDB) database administrators (DBA). This means that the DBAs who are in charge of the central database are responsible for managing and maintaining the tables within the RDMS. The other options, such as the Unit DBM, ELC DBM, and AEF user, do not have the authority or role to manage the RDMS tables.

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

Explanation

In the Integrated Maintenance Data System (IMDS), a direct type of record has its database key assigned and controlled by the Electronic Systems Group (ELSG) database administrator. This means that the ELSG database administrator is responsible for managing and assigning the unique identifier for each direct record in the IMDS database. They have the authority and control over the database key, ensuring that it is properly assigned and maintained within the system.

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

Explanation

The IMDS Data Management System (DMS) schematic does not show the element "Page" of the database structure. The schematic likely displays the other elements such as Sets, Areas, and Records, which are commonly used in database organization. However, the absence of "Page" suggests that the IMDS DMS does not utilize a page-based storage system for data management.

Submit
67. . (203) Which utility program requires that the database be down when you run this program?

Explanation

The data management utility verifies the integrity and consistency of the database. In order to perform these checks, the utility needs exclusive access to the database, meaning that it cannot be running or being accessed by any other programs or users. Therefore, the database needs to be down when running this program.

Submit
68. (219) 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. This suggests that "Load" represents the amount of data or resources that have been allocated or used within a specific area. It can be used to determine the remaining capacity or availability of space within that area.

Submit
69. (219) 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 IMDS schema defines the areas where the records can be found. The data identifier is a unique identifier assigned to each record, and it helps to locate and access specific records within the system. This clause allows for efficient organization and retrieval of records based on their designated areas or categories.

Submit
70. (248) 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 b. DEVICE DP0069. This is because the command "DEVICE" is used to specify the output device in the Query Language Processor (QLP). In this case, the device ID is DP0069, so the correct command would be "DEVICE DP0069". This command tells the QLP to print the output to the specified device, which is the enterprise output manager printer with the device ID DP0069.

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

Explanation

The correct answer is c. DECLARE. In Query Language Processor (QLP), the DECLARE clause is used to define the explicit attributes of a derived name. This clause allows the user to specify the name, data type, and length of a derived attribute. It is used to create new attributes based on calculations or transformations of existing attributes in the database. The DECLARE clause is an important component of QLP as it helps in defining and manipulating derived attributes effectively.

Submit
72. (226) 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, and vice versa. This type of relationship is often used when the two tables have a unique identifier that links them together, such as a primary key and foreign key.

Submit
73. (228) 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 Relational Database Management System (RDMS) that holds data supplied by the Reliability and Maintainability Information System (REMIS) is the "Reference" table. This table likely stores information that is used as a point of reference or lookup for other data in the database. It may contain data such as codes, standards, guidelines, or other reference materials that are relevant to the REMIS system.

Submit
74. (257) Which G081 program is used to access, move, update, and change FOCUS reports?

Explanation

The correct answer is d. F9029. The F9029 program is used to access, move, update, and change FOCUS reports.

Submit
75. (242) 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 because it is comparing the value of the variable ESH-ENG-FLY-HRS with the string '01000'. Relational expressions are used to compare values and determine if they are equal, not equal, greater than, less than, etc. In this case, the statement is checking if the value of ESH-ENG-FLY-HRS is equal to '01000'.

Submit
76. (252) 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) savefile is used to list all or specific entities. This command allows users to retrieve and display information from the savefile, either for all entities or for specific ones. It is commonly used to view the contents of a savefile and obtain a list of entities stored within it. The other options, SAVE, COPY, and PURGE, do not provide the functionality of listing entities in the savefile.

Submit
77. (227) A condition of a normalized table is for non-key items to be fully

Explanation

In a normalized table, non-key items should be fully dependent on the table's primary key. This means that the values of non-key items should be determined by the value of the primary key. This ensures that each attribute in the table is functionally dependent on the key, which helps to eliminate redundancy and maintain data integrity. Therefore, option a is the correct answer.

Submit
78. (236) 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 attempt to save data or changes was not successful and had to be rolled back. The code 14 specifically refers to a "savepoint rollback" error, which occurs when a transaction is rolled back to a savepoint that was created earlier. This can happen due to various reasons such as system errors, conflicts with other transactions, or manual intervention.

Submit
79. (255) 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. This command terminates the current SQL thread and releases any associated resources. It is the correct command to use in this scenario as it specifically ends the SQL session and disconnects from the RDMS.

Submit
80. (225) A column or combination of columns in a relational table that uniquely identifies a row is called a

Explanation

A column or combination of columns in a relational table that uniquely identifies a row is called a key. A key is used to ensure that each row in a table is unique and can be used to establish relationships between tables. It is an essential component in maintaining data integrity and facilitating efficient data retrieval and manipulation operations in a database system.

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

Explanation

TIP users are not able to create pointer errors in the IMDS database. Pointer errors occur when a pointer, which is a variable that stores the memory address of another variable, is incorrectly assigned or used. Since TIP users do not have the ability to directly manipulate or modify the memory addresses in the database, they cannot create pointer errors.

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

Explanation

The correct answer is d. Status and inventory. In a Relational Database Management System (RDMS), status and inventory tables are commonly used to track and manage the status of various items and their inventory levels. These tables provide important information about the availability and quantity of different items, allowing organizations to efficiently manage their resources and make informed decisions. The status and inventory tables are crucial components of an RDMS as they help in monitoring and controlling the flow of goods and services within an organization.

Submit
83. (237) Which database verify checks for proper placement of random records throughout a

Explanation

The correct answer is d. CALC. In the given question, the database verify checks for the proper placement of random records throughout a CALC database. The other options, IPF, SET, and AREA, are not relevant to the context of the question. Therefore, the correct answer is CALC.

Submit
84. (227) 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 of data refer to multiple occurrences of the same set of attributes within a single record. This violates the principle of atomicity, which states that each attribute in a table should contain only a single value. By eliminating repeating groups, the table can be organized in a way that each attribute holds a single value, ensuring data integrity and efficiency in database operations.

Submit
85. (227) In a relational table, data in may change frequently within a

Explanation

In a relational table, data in non-key fields may change frequently. Non-key fields are the columns in a table that are not used to uniquely identify each row. These fields contain data that can be modified or updated regularly, such as customer names, addresses, or phone numbers. Key fields, on the other hand, are used to uniquely identify each row and are typically not subject to frequent changes. Therefore, the correct answer is b. non-key field.

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

Explanation

If the edited Query Language Processor (QLP) report was stored in the user or permanent savefile, it will be copied into the temporary savefile. This means that if the report was previously saved by the user or permanently stored, it will be copied into the temporary savefile.

Submit
87. 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. This means that it focuses specifically on problems related to the status of equipment (C-E status) and the inventory of items. It does not address other types of issues such as core automated maintenance (CAM) and REMIS interface problems or general IMDS maintenance.

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

Explanation

In Interactive Processing Facility (IPF), the SELECT statement must be preceded by "SQL". This is because IPF is a tool that allows users to interact with a database using SQL commands. By specifying "SQL" before the SELECT statement, it indicates that the user wants to execute a SQL command to retrieve data from the database.

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

Explanation

The correct answer is d. EXIT. The EXIT command is used to terminate the Query Language Processor (QLP) session. When the QLP session is terminated using the EXIT command, all unsaved reports are purged and not saved. This means that any reports that were not saved using the SAVE command will be lost.

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

Explanation

The correct answer is a. 4. This means that there are four methods of search available through Database Look (DBLOOK). However, the specific methods are not mentioned in the question, so we cannot provide further details about each method.

Submit
91. (234) What program can you use to display green screen authorizations?

Explanation

The Delta Table report program can be used to display green screen authorizations.

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

Explanation

In a SELECT statement in SQL, the select list is where you specify the columns that you want to retrieve from a table. Therefore, the correct answer is c. Column names.

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

Explanation

The correct answer is b. FROM. In SQL, the SELECT statement is used to retrieve data from a database. The FROM clause is used to specify the table or tables from which the data should be retrieved. It is required in every SELECT statement to indicate the source of the data. The other options, such as ALL, WHERE, and GROUP BY, are used for different purposes in SQL queries but do not complete the SELECT statement.

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

Explanation

The correct answer is b. DMR status of individual run. This option of the Universal Data System Monitor (UDSMON) provides information about the Data Management Routine (DMR) status of an individual run. It includes details such as the current record, database key (DBK), and command being performed for that specific run. This information helps in monitoring and managing the data processing tasks efficiently.

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

Explanation

The correct answer is d. GENERATE. The GENERATE command in the Query Language Processor (QLP) allows the user to specify an output destination. This command is used to generate the desired output from the query and send it to the specified destination, such as a file or a printer. The GENERATE command is commonly used in database systems to control the output format and destination of query results.

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

Explanation

QLP Procedures are invoked by the command "CALL". This command is used to call or execute a procedure in a Query Language Processor. The CALL command allows the program to transfer control to the specified procedure and execute the statements within it. Therefore, option b. "CALL" is the correct answer.

Submit
97. (235) 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) to perform real-time operations and view information. On the other hand, in the batch mode, users can submit multiple tasks or jobs to be processed in the background without any user interaction. This allows for automated and scheduled processing of tasks, increasing efficiency and reducing the need for manual intervention.

Submit
98. (240) 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 that is designed to control and maintain user databases. It is not specifically related to the data management utility (DMU) processor, executive system software, or Air Force data systems. Therefore, the correct answer is d. user databases.

Submit
99. (246) 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 "EXIT-MACRO." This clause is used to indicate the end of the MACRO definition and to exit the MACRO processing.

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

Explanation

On a Query Language Processor (QLP) report, the clause FOR TRANSFER should be entered on the line that specifies the REPORT. This indicates that the transfer of data should occur at the report level, allowing the data to be transferred to another location or system.

Submit
View My Results

Quiz Review Timeline (Updated): Mar 21, 2023 +

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

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

Advertisement