Question 1

Which three are the advantages of Distributed Database? (Choose three)

Accepted Answer

A, B, D

Explanation: A distributed database system offers several key advantages over a centralized one. 1. Increased Availability (A): Data is often replicated across multiple sites (nodes). If one site fails due to a hardware or network issue, the system can continue to operate using data from other available sites, significantly enhancing fault tolerance and overall availability. 2. Easier Expansion (B): The architecture is modular. To increase storage or processing capacity, new servers can be added to the network without requiring a complete system overhaul. This concept, known as modular or incremental growth, makes expansion more manageable and cost-effective. 3. Improved Performance (D): Performance is enhanced in two main ways. First, data can be stored physically closer to the users who access it most frequently, reducing network latency (data localization). Second, complex queries can be broken down and executed in parallel across multiple machines, reducing the total query response time.

Question 2

_______________ interdependence occurs when two organizations depend on each other.

Accepted Answer

B

Explanation: Reciprocal interdependence, as defined in organizational theory, describes the most complex relationship where the outputs of one unit or organization serve as the inputs for another, and vice-versa. This creates a mutual, two-way dependency. The actions of each entity directly and immediately impact the other, necessitating a high degree of communication, mutual adjustment, and coordination to manage the relationship effectively. This concept is a cornerstone of James D. Thompson's work on organizational design and technology.

Question 3

Which of the following is a sixth step in Systems Design Life Cycle?

Accepted Answer

B

Explanation: The Systems Design Life Cycle (SDLC) is a conceptual model used in project management that describes the stages involved in an information system development project. While models can vary, a widely accepted seven-phase model is: 1. Planning, 2. Analysis, 3. Design, 4. Development (Building), 5. Testing, 6. Implementation (Installation), and 7. Operations & Maintenance. The sixth phase, Implementation or Installation, involves deploying the tested system into the live production environment. This includes activities like data migration, user training, and the physical installation of hardware and software.

Question 4

Information derived from processing transaction reduces uncertainty about a firm's order backlog or financial position.

Accepted Answer

A

Explanation: The statement is correct. Transaction Processing Systems (TPS) capture and process the day-to-day operational data of a firm, such as sales orders, payroll, and shipping. The output of this processing is detailed, up-to-date information. When this information is aggregated and summarized, it provides managers with a clear and accurate picture of key business metrics, including the exact status of the order backlog or the firm's current financial standing (e.g., accounts receivable, cash flow). This availability of precise, timely data directly reduces uncertainty and provides a solid foundation for managerial control and decision-making.

Question 5

Which two management departments are responsible for the success of information processing? (Choose two)

Accepted Answer

B, C

Explanation: The success of an organization's information processing capabilities is a shared responsibility, primarily driven by strategic direction and tactical implementation. Top Management is responsible for setting the overall strategy, aligning information technology (IT) with business goals, and approving the necessary resources and investments. Their commitment is crucial for championing IT initiatives. Middle Management is responsible for executing this strategy by managing IT projects, overseeing the implementation of new systems within their departments, and ensuring that these systems meet the specific needs of business units. The synergy between top management's vision and middle management's execution is fundamental to achieving successful information processing.

Question 6

In a database, each row is called a

Accepted Answer

A

Explanation: In the context of a relational database, a table is structured into rows and columns. Each row represents a single, complete data entry or item within the table. This horizontal grouping of related data is formally known as a "tuple" in relational model theory, but is most commonly referred to as a "record." For example, in a table of employees, each row would be a record containing all the information about one specific employee (e.g., their ID, name, and position).

Question 7

How many techniques are available to the design team for collecting data?

Accepted Answer

C

Explanation: In the context of systems analysis and design, there are five commonly recognized and fundamental techniques for collecting data and determining system requirements. These methods are: 1. Interviews: One-on-one or small group discussions with stakeholders to gather in-depth information. 2. Questionnaires: Written sets of questions distributed to a large number of people to collect data on attitudes, beliefs, and characteristics. 3. Observation: Watching users perform their jobs to understand existing processes and identify problems or opportunities for improvement. 4. Document Analysis: Reviewing existing business documents, forms, reports, and system manuals to understand the current system. 5. Joint Application Design (JAD): Highly structured group meetings or workshops involving users, managers, and analysts to jointly define system requirements.

Question 8

_____________ occurs because the data we want may not be directly under the read-write heads.

Accepted Answer

B

Explanation: In a hard disk drive (HDD), data is stored in sectors on spinning platters. The total time to access data is composed of seek time, rotational delay, and transfer time. Rotational delay, also known as rotational latency, is the time required for the platter to spin so that the beginning of the desired data sector is positioned directly under the read-write head. This delay occurs after the head has already moved to the correct track (seek time) and is a direct consequence of the disk's rotational speed.

Question 9

The requirements for managerial control decisions fall between Operational and Strategic planning.

Accepted Answer

A

Explanation: The statement is correct. In management theory, decision-making and control are typically structured in a three-level hierarchy. At the top is Strategic Planning, which involves long-range, high-level decisions about the organization's objectives. At the bottom is Operational Control, which concerns the efficient and effective execution of specific, day-to-day tasks. Managerial Control (also known as Tactical Control) occupies the middle level. Its primary function is to ensure that resources are obtained and used effectively and efficiently to accomplish the organization's strategic objectives. It translates broad strategic goals into specific plans and policies for operational units, thus falling squarely between strategic and operational activities.

Question 10

Which of the following symbol represents flow of data in Data Flow Diagram?

Accepted Answer

C

Explanation: In Data Flow Diagrams (DFDs), the flow of data is universally represented by a directed line, or an arrow. The arrowhead indicates the direction of data movement. This symbol connects other DFD components, such as external entities, processes, and data stores, illustrating the path data takes through a system. The arrow is labeled with the name of the data it carries. This notation is standard across different DFD methodologies, including both Gane & Sarson and Yourdon/DeMarco.

Question 11

Which of the following points has to be considered when deciding on system alternatives? (Choose three)

Accepted Answer

B, D, E

Explanation: When deciding on system alternatives, a formal feasibility analysis is conducted to evaluate and compare the options. This analysis traditionally focuses on three key areas. Technological Feasibility (B) assesses whether the required technology and expertise are available to build the solution. Organizational Impact (D), also known as operational feasibility, evaluates how the proposed system will affect the organization's processes, culture, and personnel, and whether it will be used effectively. Financial Constraints (E), or economic feasibility, involves a cost-benefit analysis to determine if the solution is affordable and provides a worthwhile return on investment. These three pillars provide a comprehensive framework for selecting the most viable system alternative.

Question 12

The smallest unit of data storage is the _______

Accepted Answer

A

Explanation: A byte is the most common fundamental unit of data storage in computing. While the absolute smallest unit of data is a bit, it is not provided as an option. Among the choices given, a byte, which typically consists of eight bits, is the smallest unit. In most modern computer architectures, the byte is also the smallest individually addressable unit of memory, meaning the CPU can retrieve data from memory in chunks of one or more bytes, but not smaller than a single byte.

Question 13

One of the main reasons for building a data warehouse is to undertake data mining.

Accepted Answer

A

Explanation: The statement is true. A primary purpose of a data warehouse is to serve as a foundational platform for business intelligence and decision support systems. Data warehouses consolidate, clean, and structure vast amounts of historical data from disparate sources, creating an optimized environment for complex analytical queries. Data mining, the process of discovering non-obvious patterns and knowledge from large datasets, relies heavily on this high-quality, integrated data. Therefore, enabling effective data mining to uncover strategic insights is a key driver and a major justification for the significant investment required to build and maintain a data warehouse.

Question 14

Which one of the following is the second step in System Analysis?

Accepted Answer

A

Explanation: In a typical, sequential System Development Life Cycle (SDLC) model, the process begins with a preliminary investigation or problem identification (Step 1). The logical subsequent step is the Feasibility Study (Step 2). This study is a critical checkpoint that evaluates the project's viability based on technical, economic, legal, operational, and scheduling (TELOS) factors. It is conducted before committing significant resources to detailed requirements gathering and system design to determine if the project should proceed. Therefore, it is considered the second major step in the overall system analysis and development process.

Question 15

Choose the malicious code which can distribute itself without using having to attach to a host file.

Accepted Answer

C

Explanation: A computer worm is a standalone malicious program designed to replicate itself and spread to other computer systems, typically across a network. Its defining characteristic, which distinguishes it from a virus, is its ability to propagate without requiring a host file or human intervention. Worms exploit vulnerabilities in operating systems or applications to travel from one machine to another. This self-sufficiency in distribution and lack of dependency on a host program directly matches the criteria specified in the question.

Free GAQM CITM-001 Actual Exam Questions