GAQM CITM-001 Exam Dumps

A foreign key is a column or a set of columns in one table that references the primary key of another table. It is used to create a link and relationship between tables in a relational database.A foreign key ensures that the values in the referencing table match the values in the referenced table, thus maintaining the referential integrity of the database12.A foreign key can also be used to implement constraints such as cascading updates or deletes3.Reference:1: CITM Study Guide, Chapter 3: Database Management Systems, Page 41.2:Types of Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign)3:Database Keys: The Complete Guide (Surrogate, Natural, Composite & More)

A macro virus is a virus that is written in a macro language, which is a programming language embedded inside a software application, such as word processors and spreadsheet applications. A macro virus can attach itself to a file or template and run automatically when the file is opened or closed, without the user's knowledge. A macro virus can infect any system that supports macros, regardless of the operating system.A macro virus can spread quickly by infecting other documents and templates, and may cause damage to the computer and its applications123Reference:

1: What is a Macro Virus? | Macro Virus Definition - Kaspersky

2: Macro virus - Wikipedia

3: What is a macro virus and how to help prevent them - Norton

Managerial control decisions are those that involve measuring and correcting the performance of activities of subordinates to ensure that the enterprise objectives and plans are being accomplished. Managerial control decisions fall between operational and strategic planning because they are concerned with both executing the strategy and tracking its progress. Operational control decisions are those that focus on the efficiency and effectiveness of specific processes, tasks, and functions. Strategic control decisions are those that evaluate the alignment of the strategy with the external and internal environment, and make adjustments if necessary.Reference:Managerial Control: Definition, Features, Scope, and Process,Types and Levels of Control -- Principles of Management,The Control Function of Management - MIT Sloan Management Review

Information derived from processing transaction reduces uncertainty about a firm's order backlog or financial position because it provides a quantitative and forward-looking measure of demand. Order backlog is the amount of orders that a firm has received but not yet fulfilled. It reflects the expected future revenue and cash flows of the firm, as well as its ability to meet customer needs and expectations. Order backlog can also indicate the competitive position and market share of the firm, as well as its operational efficiency and capacity utilization. Therefore, disclosing order backlog can help stakeholders such as investors, analysts, managers, and regulators to assess the firm's performance and prospects more accurately and reliably.Reference:Sample Exam - GAQM, page 4;Implications of Disclosing Order Backlog, page 1-2;Backlog Definition, Implications, and Real-World Examples - Investopedia

In a multi-user design, one group usually develops the systems for use by another group. This is because different groups of users may have different needs, preferences, and expectations for the system. For example, a system that is designed for the accounting department may not be suitable for the marketing department, or a system that is designed for the managers may not be user-friendly for the employees. Therefore, a multi-user design involves identifying the target users, analyzing their requirements, designing the system accordingly, and testing the system with the users. A multi-user design also requires coordination and communication among the developers and the users, as well as among different user groups, to ensure that the system meets the needs and expectations of all stakeholders.Reference:Multi-User Operating System - GeeksforGeeks;Multiple Group Design: Definition & Examples - Study.com;Chapter 10: Information Systems Development