System Analysis And Design Exam! Hardest Trivia Quiz

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 Kilikika
K
Kilikika
Community Contributor
Quizzes Created: 7 | Total Attempts: 33,720
| Attempts: 3,952 | Questions: 88
Please wait...
Question 1 / 88
0 %
0/100
Score 0/100
1. What is an outside person, unit, system, or organization that interacts with a system called?

Explanation

An external agent refers to an outside person, unit, system, or organization that interacts with a system. This can include individuals or entities that provide input, receive output, or perform actions within the system. External agents play a crucial role in the functioning of a system as they contribute to its overall operation and may influence its behavior or outcomes.

Submit
Please wait...
About This Quiz
System Analysis And Design Exam! Hardest Trivia Quiz - Quiz

System analysis refers to the procedure of gathering and clarifying facts, recognizing the difficulty or issues, and disintegration of a system into its parts. It improves the system,... see moreand the parts work efficiently. Whereas, system design is the process of replacing a system by describing the part or modules. This quiz has been designed to test your knowledge about the process. Let's try to out the quiz. All the best!

see less

2. What is the act of breaking a system into sub components called?

Explanation

Decomposition is the act of breaking a system into sub-components. This process involves dividing a complex system into smaller, more manageable parts, which can then be analyzed, designed, and implemented separately. Decomposition helps to simplify the system and allows for better understanding and control of its components. It is an essential step in system design as it enables the identification of individual elements and their relationships within the system. Feasibility analysis, data conservation, and system design are not directly related to the act of breaking a system into sub-components.

Submit
3. The act of breaking a system into its component subsystems, processes, and subprocesses is known as __

Explanation

Decomposition refers to the act of breaking down a system into its component subsystems, processes, and subprocesses. This process helps in understanding the system better and analyzing its functionality at a granular level. By decomposing a system, we can identify the different parts and their relationships, which ultimately aids in designing and managing complex systems effectively.

Submit
4. Which of the following is an external entity?

Explanation

account transactions is a data store, monthly account statements is also a data store and payment is a data flow

Submit
5. What is a process called that handles a given event in the event response list?

Explanation

An event handler is a process that handles a given event in the event response list. It is responsible for executing the necessary actions or functions when a specific event occurs. It is commonly used in programming and software development to define the behavior or response to events such as button clicks, mouse movements, or keyboard inputs. The event handler receives the event as input and performs the desired actions or invokes the appropriate functions to respond to that event.

Submit
6. Which tool depicts the flow of data through a system and the work or processing performed by that system?

Explanation

A data flow diagram is a tool that visually represents the flow of data through a system and the processing or work performed by that system. It uses various symbols to depict the different components and processes involved in the system, such as data sources, processes, data stores, and data flows. This diagram helps to understand how data moves within a system, identify potential bottlenecks or inefficiencies, and analyze the overall flow of information. It is commonly used in system analysis and design to model and document the data flow within a system.

Submit
7. Which of the following is the definition of an entity

Explanation

An entity refers to a class of persons, places, objects, events, or concepts about which we need to capture and store data. This definition implies that entities are the fundamental building blocks of a data model, representing the various categories or types of information that we want to track and manage. By capturing and storing data about these entities, we can organize and analyze information in a structured manner, enabling effective data management and decision-making processes.

Submit
8. An entity can be all of the following EXCEPT

Explanation

An entity can refer to a person, place, object, or event, as these are all tangible or observable entities. However, relationships are not physical entities themselves but rather the connections or associations between entities. Therefore, relationships are not considered as one of the possible options for an entity.

Submit
9. What is a context diagram?

Explanation

A context diagram is a diagram that is used to document the scope for a system. It provides a high-level overview of the system and its surrounding environment, showing the interactions between the system and external entities. It helps to define the boundaries and interfaces of the system, allowing stakeholders to understand the context in which the system operates. This diagram does not provide detailed information about the system's design or implementation, but rather focuses on capturing the overall scope and context of the system.

Submit
10. When data is at "rest" it is most likely an:

Explanation

When data is at "rest," it refers to the state where the data is not being actively processed or transmitted. In this state, the data is typically stored in a data store, such as a database or a file system. A data store is specifically designed to securely store and manage data, making it the most suitable option for data at rest. Therefore, the correct answer is data store.

Submit
11. What do rounded rectangles represent in data flow diagrams?

Explanation

Rounded rectangles in data flow diagrams represent processes. Processes are the activities or transformations that occur within a system. They can be manual or automated and are responsible for taking inputs, performing actions, and producing outputs. The rounded rectangle shape is used to visually represent these processes in the diagram.

Submit
12. What is the merger of multiple data flows into a single data flow called?

Explanation

Converging data flow refers to the process of merging multiple data flows into a single data flow. It involves bringing together different streams of data or information into one unified pathway. This can be beneficial in situations where data from various sources needs to be combined and processed together for analysis or decision-making purposes. By converging the data flows, it becomes easier to manage and manipulate the information effectively.

Submit
13. What is the language syntax for specifying the logical of a process called?

Explanation

Structured English is a language syntax used to specify the logical flow of a process. It is a method of writing pseudocode that follows a set of rules resembling the English language. It allows programmers to describe the steps and logic of a program in a more structured and readable manner, making it easier to understand and follow. By using structured English, programmers can effectively communicate and document the intended behavior of a process, facilitating collaboration and maintenance of the code.

Submit
14. Which of the following is the definition for a composite data flow?

Explanation

A composite data flow refers to a data flow that is composed of multiple other data flows. This means that it is a higher-level data flow that includes or combines several smaller data flows within it. It can be seen as a way to organize and structure data flows, making them more manageable and understandable. By breaking down complex processes into smaller, interconnected data flows, it becomes easier to analyze and design systems. This definition emphasizes the composition aspect of composite data flows, highlighting their hierarchical nature.

Submit
15. Which of the following is a type of data flow that splits into multiple data flows?

Explanation

A diverging data flow is a type of data flow that splits into multiple data flows. This means that a single input or process is divided into multiple outputs or paths, allowing data to flow in different directions. This can occur when there are multiple branches or decision points in a system or process, and the data needs to be distributed or processed differently based on certain conditions or criteria.

Submit
16. Which of the following is the best definition for an iteration structure in Structured English?

Explanation

An iteration structure in Structured English is best defined as a set of steps that should be repeated based on a stated condition. This means that the structure allows for the repetition of a specific set of steps until a certain condition is met. It provides a way to automate repetitive tasks and streamline processes by defining the conditions under which the steps should be repeated.

Submit
17. Which of the following is a process that handles a given event?

Explanation

An event handler is a process that is responsible for handling a given event. It is the component that receives and processes events triggered by user actions or system events. The event handler is designed to perform specific actions or tasks in response to the event, such as updating data, displaying information, or executing a function. It is an essential part of event-driven programming and allows for the execution of code based on specific events occurring.

Submit
18. Which of the following is a language syntax for specifying the logic of a process?

Explanation

Structured English is a language syntax used to specify the logic of a process. It is a method of writing software specifications using natural language statements that are structured in a way that resembles programming language syntax. This allows for clear and unambiguous communication of the process logic, making it easier to understand and implement. It is commonly used in software development to describe the steps and conditions of a process in a more human-readable format.

Submit
19. What is a class of data that can be stored in an attribute called?

Explanation

The correct answer is "data type." In programming, a data type refers to the classification of data that determines the type of values it can hold and the operations that can be performed on it. It defines the size and format of the data stored in an attribute. Different data types include integers, floating-point numbers, strings, booleans, etc. By specifying the data type of an attribute, we can ensure that only compatible values are stored in it and perform appropriate operations on the data.

Submit
20. What does CASE stand for?

Explanation

The acronym CASE stands for Computer Aided System Engineering. This term refers to the use of computer-based tools and techniques to assist in the development, analysis, and maintenance of software systems. CASE tools provide support for various activities in the software development life cycle, such as requirements gathering, design, coding, testing, and documentation. These tools help improve productivity, quality, and consistency in software development processes by automating tasks, facilitating collaboration, and providing a structured approach to system engineering.

Submit
21. What is data model called that utilizes several notations to depict data in terms of the entities and relationships described by that data?

Explanation

An entity relationship diagram is a data model that utilizes several notations to depict data in terms of the entities and relationships described by that data. It is a visual representation that shows how different entities are related to each other in a database. This diagram helps to understand the structure of the database and the relationships between entities, making it easier to design and manage the database effectively.

Submit
22. Which of the following is NOT considered a compound attribute

Explanation

Gender is not considered a compound attribute because it represents a single characteristic or property of an entity. Compound attributes are composed of multiple sub-attributes that provide more detailed information. In this case, both name and address can have multiple sub-attributes such as street, city, and state, while phone number can have sub-attributes like country code and area code. However, gender does not have any sub-attributes and is therefore not considered a compound attribute.

Submit
23. What is a candidate key called that is not selected to become the primary key?

Explanation

An alternate key is a candidate key that is not selected to become the primary key. It is an alternative option for the primary key and can uniquely identify records in a database table. While the primary key is chosen as the main identifier for a table, an alternate key can also serve as a unique identifier if needed.

Submit
24. What is a tabular form of presentation that specifies a set of conditions and their corresponding actions called?

Explanation

A decision table is a tabular form of presentation that specifies a set of conditions and their corresponding actions. It is commonly used in decision-making processes to systematically analyze different combinations of conditions and determine the appropriate actions to be taken. This table helps in organizing complex logic and simplifying the decision-making process by providing a clear and structured representation of all possible scenarios and their outcomes.

Submit
25. All of the following are synonyms for the term "Attribute" EXCEPT:

Explanation

The term "attribute" refers to a characteristic or quality of something. Out of the options provided, "child" does not directly relate to this definition. In the context of data or programming, "element," "property," and "field" can all be used synonymously with "attribute" to describe different aspects or features of an object or entity. However, "child" typically refers to a subordinate or dependent element within a hierarchical structure, rather than a synonym for "attribute."

Submit
26. Which statement below is true about data flow diagrams (DFDs)?

Explanation

A data flow diagram (DFD) is a tool used to illustrate how data moves through a system and the processing or work performed by that system. It is considered a process model because it focuses on the flow of data and the processes involved in a system. Therefore, the correct answer is "a & b."

Submit
27. Which of the following terms describes the smallest piece of data that has meaning to the users and the business?

Explanation

A data attribute is a term that describes the smallest piece of data that has meaning to the users and the business. It refers to a specific characteristic or property of a data entity that provides information and context. Data attributes are essential for organizing and categorizing data, allowing users and businesses to understand and interpret the information effectively.

Submit
28. You will find all of the following in use cases EXCEPT:

Explanation

In use cases, actors, events, inputs, and outputs are all commonly found elements. Actors refer to the individuals or systems interacting with the system being described in the use case. Events represent the actions or triggers that occur within the system. Inputs are the data or information provided to the system, while outputs are the results or responses produced by the system. However, "members" is not typically included in use cases as it does not directly relate to the interactions or functionality of the system.

Submit
29. The CRUD in a CRUD matrix stands for?

Explanation

The correct answer is "create, read, update, delete". The acronym CRUD stands for these four basic operations that can be performed on data in a database or any other storage system. "Create" refers to the action of adding new data, "read" is about retrieving or viewing existing data, "update" involves modifying or changing the existing data, and "delete" is the process of removing or deleting data from the system. These operations are fundamental for managing data and maintaining its integrity and usability.

Submit
30. With respect to data structures, what does the "=" mean?

Explanation

The "=" symbol in data structures represents the relationship of "consists of" or "is composed of". It signifies that one element is made up of or includes another element.

Submit
31. Which word is a synonym for "logical model"?

Explanation

A "logical model" refers to a representation of a system or concept that focuses on the logical relationships and structure. The term "conceptual model" also refers to a representation of a system or concept, but it emphasizes the overall concepts and ideas rather than the specific implementation details. Therefore, "conceptual model" is a synonym for "logical model" as both terms describe a high-level representation of a system or concept.

Submit
32. Data flows can be described in terms of all of the following types of data structures EXCEPT:

Explanation

Data flows can be described in terms of a sequence or group of data attributes that occur one after another, the selection of one or more attributes from a set of attributes, and the repetition of one or more attributes. However, the absence of one or more attributes does not describe a data structure in data flows.

Submit
33. Which of the following is the best definition of a decision table?

Explanation

A decision table is a tabular presentation that specifies a set of conditions and their corresponding actions. It is used to represent complex business rules or logic in a structured and organized manner. The table consists of rows representing different combinations of conditions and columns representing the corresponding actions to be taken. This format allows for easy understanding and analysis of the decision-making process, making it a valuable tool for designing and implementing systems or processes.

Submit
34. One of a number of keys that may serve as the primary key of an entity is an __

Explanation

A candidate key is one of the potential choices for the primary key of an entity. It is a unique identifier that can be used to uniquely identify each record in a table. In other words, it is a column or a combination of columns that can uniquely identify a row in a table. The candidate key is chosen from a set of attributes that could potentially serve as the primary key.

Submit
35. What is an attribute called that assumes a unique value for each entity instance?

Explanation

The attribute that assumes a unique value for each entity instance is called a key. A key is used to uniquely identify each entity in a database table. It ensures that no two entities have the same value for the key attribute, allowing for efficient retrieval and manipulation of data.

Submit
36. What is the property of an attribute called that defines what values the attribute can legitimately take on?

Explanation

The property of an attribute that defines what values it can legitimately take on is called the domain. The domain specifies the range or set of values that are valid for the attribute. It helps to ensure data integrity and restricts the attribute to only accept appropriate values within a specified range or set.

Submit
37. Which of the following is the best definition for an iteration structure in structured English?

Explanation

An iteration structure in structured English is a specification that defines a set of steps to be repeated based on a stated condition. This means that the specified steps will be executed repeatedly until the condition is no longer true. It allows for the automation of repetitive tasks and provides a way to control the flow of the program based on specific conditions.

Submit
38. Which of the following terms is defined as a concept that requires that data flow diagrams at different levels of detail reflect consistency and completeness?

Explanation

Balancing, in the context of data flow diagrams, refers to the concept of ensuring consistency and completeness across different levels of detail. It means that the data flow diagrams should accurately represent the flow of data and processes at various levels, without any missing or redundant information. This ensures that the diagrams are reliable and can be used effectively for analysis and design purposes.

Submit
39. All of the following are the types of events that are associated with inputs on the context diagram EXCEPT:

Explanation

The context diagram is a visual representation of a system that shows the interactions between the system and its external entities. It focuses on the inputs and outputs of the system. External events, temporal events, and state events are all types of events that can be associated with inputs on the context diagram. However, national events do not typically have a direct association with inputs on the context diagram. These events are usually broader in scope and may not directly impact the system being represented.

Submit
40. Which of the following describes a set of rules that governs how a process it to be completed?

Explanation

A policy is a set of rules that govern how a process is to be completed. Policies provide guidelines and instructions for individuals or organizations to follow in order to achieve specific objectives or outcomes. They outline the expected behavior, procedures, and protocols that need to be followed in order to ensure consistency, efficiency, and compliance in completing a process. Policies can be implemented at various levels, such as organizational, departmental, or project-specific, and they help in maintaining order and standardization in the completion of tasks or activities.

Submit
41. When mapping data requirements, it is important to ask all of the following questions EXCEPT:

Explanation

When mapping data requirements, it is important to ask questions related to level of access, creating instances of the entity, updating existing instances, and deleting instances. However, the question of "will we have compatibility issues" is not directly related to data requirements and therefore does not need to be asked.

Submit
42. What is a process model used to document the scope for a system called?

Explanation

A context data flow diagram is a process model used to document the scope for a system. It provides a high-level overview of the system and its interactions with external entities. It shows the flow of data between the system and external entities, without going into too much detail about the internal processes. This diagram helps to define the boundaries of the system and understand how it interacts with its environment.

Submit
43. What concept requires that data flow diagrams at different levels of detail reflect consistency and completeness?

Explanation

Balancing is the concept that requires data flow diagrams at different levels of detail to reflect consistency and completeness. Balancing ensures that the inputs and outputs of a system are properly accounted for and that all data flows are balanced, meaning that no data is lost or created in the process. This concept helps to maintain the accuracy and integrity of the data flow diagrams, ensuring that they accurately represent the system being analyzed.

Submit
44. What is an analysis tool for finding and identifying business events and responses called?

Explanation

A use case is an analysis tool that helps in finding and identifying business events and responses. It describes the interactions between a system and its users, outlining the steps and actions required to achieve a specific goal. Use cases are commonly used in system analysis to understand the requirements and functionalities of a system and to ensure that it meets the needs of the users. They help in identifying the actors involved, the flow of events, and the expected outcomes in a business scenario.

Submit
45. Which of the following is a data model that includes all entities, attributes, relationships, subsetting criteria, and precise cardinalities?

Explanation

A fully attributed data model is a data model that includes all entities, attributes, relationships, subsetting criteria, and precise cardinalities. This means that it provides a comprehensive representation of the data, including all the necessary details and specifications. It is a complete and detailed representation of the data structure, allowing for a thorough understanding and analysis of the data.

Submit
46. Which of the event types are triggered on the basis of time, or something that merely happens?

Explanation

Temporal events are triggered on the basis of time. They are events that occur at specific points in time or within a specified time frame. These events are not dependent on external factors or changes in the system's state. Instead, they are triggered solely based on the passage of time or predetermined schedules. Therefore, temporal events are the correct answer as they are specifically related to events triggered by time.

Submit
47. What is the work performed by a system in response to incoming data flows or conditions called?

Explanation

The work performed by a system in response to incoming data flows or conditions is called a process. A process refers to a series of steps or activities that are performed in order to achieve a specific goal or outcome. In this context, the system is actively processing the incoming data or conditions, which involves analyzing, transforming, or responding to them in some way. The other options, such as value stream, activity, or task, do not capture the comprehensive nature of the work performed by the system in this scenario.

Submit
48. What is the technique that compares the lifetime profitability of alternative solutions?

Explanation

Return on investment analysis is a technique that compares the lifetime profitability of alternative solutions. It measures the return or profit generated from an investment relative to its cost. By calculating the return on investment, businesses can evaluate the financial viability of different solutions and determine which one provides the highest profitability. This analysis takes into account the time value of money and considers the cash flows generated over the entire lifespan of the investment. It is a widely used method for decision-making in business and investment scenarios.

Submit
49. Which of the following is not a common synonym for "logical model"?

Explanation

A "logical model" refers to a representation of a system or concept that focuses on the logical relationships and structure. It is not concerned with the physical aspects or implementation details. A "physical model," on the other hand, represents the physical implementation or representation of a system. Therefore, a physical model is not a common synonym for a logical model, as it emphasizes the physical rather than the logical aspects. The other options, essential model, business model, and conceptual model, all relate to different types of logical models used in various contexts.

Submit
50. What is the legitimate values for an attribute called?

Explanation

The term "domain" refers to the set of permissible values that an attribute can take. In the context of this question, "domain" is the correct answer as it accurately describes the legitimate values for an attribute. The other options, such as "type," "flow," and "structure," do not specifically relate to the range of values an attribute can have.

Submit
51. Which of the following is the definition of a domain?

Explanation

A domain is a property of an attribute that defines what values the attributes can legitimately take on. This means that a domain specifies the range of acceptable values for a particular attribute. It helps to ensure data integrity and validity by restricting the type of data that can be stored in the attribute.

Submit
52. What is the practice of ensuring that a data flow contains only data needed by the receiving process called?

Explanation

Data conservation refers to the practice of ensuring that a data flow contains only the necessary data required by the receiving process. This involves minimizing the amount of unnecessary data being transmitted or stored, which can help improve efficiency, reduce storage costs, and enhance data security. By conserving data, organizations can focus on transmitting and storing only the relevant information, optimizing resources and ensuring that data is handled in a more streamlined and effective manner.

Submit
53. Which normal form would correspond to an entity whose non key attributes are dependent on the full primary key?

Explanation

2NF (Second Normal Form) would correspond to an entity whose non-key attributes are dependent on the full primary key. In 2NF, a table must first satisfy the conditions of 1NF and then additionally ensure that all non-key attributes are fully dependent on the entire primary key, rather than just a part of it. This means that each non-key attribute must depend on the entire primary key, and not on just a subset of the key attributes. Therefore, 2NF is the correct answer in this case.

Submit
54. All of the following is true about structured english except

Explanation

Structured English is a method of writing program specifications using a combination of natural language and programming constructs. It aims to make the specifications more readable and understandable for both technical and non-technical stakeholders. While structured English should use strong, imperative verbs, a sequence of simple, declarative sentences, and only names that have been defined in the project dictionary, it does not involve the use of pseudocode. Pseudocode is a more informal and less structured way of representing algorithms and is not typically used in structured English.

Submit
55. Which type of normal form looks for transitive dependencies?

Explanation

The third normal form looks for transitive dependencies. This means that in a table, if there is a dependency between two non-key attributes through another non-key attribute, it violates the third normal form. To achieve the third normal form, such transitive dependencies need to be removed by decomposing the table into multiple tables.

Submit
56. What does a data structure contain?

Explanation

A data structure contains attributes, which are the characteristics or properties associated with the data. These attributes define the structure and behavior of the data and allow for efficient storage, retrieval, and manipulation of the data.

Submit
57. Which of the following is not part of a data flow diagram?

Explanation

A data flow diagram is a graphical representation of the flow of data within a system. It consists of processes, external agents, data stores, and data flows. While rounded rectangles represent processes, squares represent external agents, and open-ended boxes represent data stores, a circle representing an entity is not part of a data flow diagram. Entities are typically represented as rectangles or ovals in entity-relationship diagrams, which are used to model the relationships between entities in a database.

Submit
58. Which of the following is an example of a derived attribute?

Explanation

A derived attribute is an attribute that can be calculated or derived from other attributes. In this case, GPA (Grade Point Average) is an example of a derived attribute because it is calculated based on the grades received in different courses. It is not directly provided as input but is derived by applying a specific calculation or formula to the grades.

Submit
59. All of the following are stages of logical data model development EXCEPT:

Explanation

The correct answer is "data requirements by location communication model." This is because the stages of logical data model development typically include building a fully attributed model, discovering and defining entities, building a context data model, and building a key-based data model. However, the "data requirements by location communication model" does not fit into the typical stages of logical data model development.

Submit
60. Which of the following best describes second normal form?

Explanation

Second normal form (2NF) is a database normalization rule that states that an entity should be in 1NF and all non-primary key attributes should be dependent on the full primary key. This means that each non-primary key attribute in the entity should be functionally dependent on the entire primary key, and not on any subset of the primary key. This helps to eliminate redundancy and ensures that data is stored efficiently and accurately in the database.

Submit
61. Which of the following best describes first normal form?

Explanation

First normal form (1NF) is a property of a relational database table. It states that each attribute in a table must contain only atomic (indivisible) values, meaning that it cannot be further broken down into smaller components. In other words, each attribute should have only one value for each instance of the entity it belongs to. This eliminates the possibility of having multiple values or repeating groups within a single attribute. Therefore, the correct answer is "an entity whose attributes have no more than one value for a single instance of that entity."

Submit
62. All of the following are part of process models EXCEPT:

Explanation

The question asks for an exception among the given options, which are external agents, data stores, process concepts, data flows, and system users. Among these options, system users are not part of process models. Process models typically represent the flow of activities and interactions within a system, including external agents, data stores, process concepts, and data flows. System users, on the other hand, refer to the individuals or entities who interact with the system but are not represented within the process model itself.

Submit
63. What is a data entity called that derives one or more attributes from another entity?

Explanation

A child entity is a data entity that derives one or more attributes from another entity. It is called a child entity because it inherits attributes from a parent entity. This allows for the organization and categorization of data, as the child entity represents a subset or specialization of the parent entity.

Submit
64. What is a data model called that includes entities and relationships but no attributes?

Explanation

A context data model is a type of data model that includes entities and relationships, but does not include attributes. It focuses on the overall structure and connections between entities without specifying any specific data values or characteristics. This type of data model is often used to provide a high-level understanding of the system or process being modeled, without delving into the specific details of the data attributes.

Submit
65. What is the practice of ensuring that a data flow contains only data needed by the receiving process called?

Explanation

Data conservation refers to the practice of ensuring that a data flow contains only the necessary data needed by the receiving process. This means that any unnecessary or redundant data is eliminated or filtered out, reducing the amount of data being transferred and improving efficiency. By conserving data, organizations can optimize their data flows, reduce storage and processing requirements, and enhance overall data management practices.

Submit
66. What is a data flow?

Explanation

Data in motion refers to the movement of data from one location to another, either within a system or between different systems. This can include data being transmitted over a network, transferred between devices, or exchanged between applications. Data in motion is typically associated with real-time or near real-time data processing and communication. It is important in ensuring the timely and accurate transfer of information, enabling various processes and applications to access and utilize the data effectively.

Submit
67. All of the following are properties for the values for each attribute EXCEPT:

Explanation

The question is asking about the properties for the values of each attribute, and it is asking for the property that is NOT included. The properties listed are data type, domain, null value, and default value. The correct answer is "null value" because it is the only property that is not typically associated with the values of an attribute. Data type refers to the type of data that can be stored in the attribute, domain refers to the set of possible values for the attribute, and default value refers to the value that is automatically assigned if no other value is specified.

Submit
68. Which of the following defines a relationship that exists between instances of the same entity?

Explanation

A recursive relationship is a type of relationship that exists between instances of the same entity. In this type of relationship, an entity can be related to itself. This means that an instance of the entity can have a relationship with another instance of the same entity. This allows for complex relationships and hierarchies within the entity. For example, in a database of employees, a recursive relationship could be used to represent the relationship between managers and their subordinates, where a manager can also be an employee and have subordinates who are also employees.

Submit
69. Data flows can be described in terms of all of the following data structures EXCEPT:

Explanation

The given answer states that data flows can be described in terms of all of the following data structures except for a single attribute that is representative of a group of attributes. This means that data flows can be described as a sequence or group of data attributes that occur one after another, the selection of one or more attributes from a set of attributes, or the repetition of one or more attributes. However, a single attribute that represents a group of attributes is not a valid way to describe data flows.

Submit
70. All of the following are examples of elementary process names EXCEPT

Explanation

The given question asks for an example of an elementary process name that is NOT included in the options. The options provided are "process online order," "check product availability," "calculate order cost," and "check customer credit." Since the question asks for an example that is NOT included, the correct answer is "process online order." This means that "process online order" is an example of an elementary process name.

Submit
71. All of the following are valid rules for data flows EXCEPT

Explanation

The given correct answer states that all processes do not need to have at least one input and one output data flow. This means that it is not necessary for every process to receive data from another process or send data to another process. In some cases, a process may only have input data or output data, but not both. This is an exception to the valid rules for data flows, as all other options mentioned are valid rules.

Submit
72. Which one of the following is a synonym of candidate key?

Explanation

A candidate key is a unique identifier for a record in a database table. It is a synonym for a candidate identifier because both terms refer to the same concept of a unique key that can be used to identify records in a table. The other options, secondary key, inversion entry, and composite attribute, do not accurately describe a candidate key.

Submit
73.   What is the purpose of logical models?

Explanation

Logical models are used to show "what" a system does. These models provide a high-level representation of the system's functionality and behavior, without getting into the specifics of how it is physically and technically implemented. They help in understanding the system's purpose, its components, and the relationships between them. Logical models are often used in the early stages of system development to communicate and document the system's requirements and design to stakeholders.

Submit
74. Data models are superior for all of the following reasons EXCEPT:

Explanation

The given correct answer states that data models are not less expensive to construct than process models. This means that data models are not superior to process models in terms of cost-effectiveness. However, the other options mentioned in the question highlight the advantages of data models, such as their ability to quickly identify business vocabulary, the inclusion of less high-level detail compared to process models, and their generally quicker construction time.

Submit
75. Which of the following is not a reason why systems analysts focus on logical system models?

Explanation

Logical models are not necessarily simple to create and require less time. In fact, creating logical system models can be a complex and time-consuming process. The main reasons why systems analysts focus on logical system models are that they remove bias, improve communication, and reduce the risk of missing requirements.

Submit
76. Which of the following is a synonym for logical model?

Explanation

A logical model refers to a representation of a system or process that focuses on the logical relationships and interactions between its components. A business model, on the other hand, describes how an organization creates, delivers, and captures value. Both terms involve the concept of modeling, but they are not synonymous. A business model encompasses broader aspects of an organization's operations, while a logical model specifically focuses on the logical structure and relationships within a system. Therefore, the correct answer is business model.

Submit
77. Which of the following is not a reason why system analysts focus on logical system models?

Explanation

System analysts focus on logical system models to remove biases that are the result of the way the current system is implemented, reduce the risk of missing business requirements, and allow us to communicate with end users in nontechnical or less technical languages. However, reflecting technology choices and the limitations of those technology choices is not a reason why system analysts focus on logical system models.

Submit
78. Each event process should be described to the CASE repository with all of the following properties EXCEPT:

Explanation

The given question asks about the properties that should be described for each event process in the CASE repository, except for one. The correct answer is "documentation requirements." This means that all other properties, such as throughput requirements, response time requirements, security, audit, and control requirements, and archival requirements, should be described for each event process in the CASE repository. However, documentation requirements do not need to be explicitly described for each event process.

Submit
79. Which of the following is NOT true of an external agent?

Explanation

An external agent refers to anything outside the system that interacts with it, such as a person, unit, system, or organization. It is also known as an external entity. Processes can become external agents, meaning that they can interact with other systems. However, external agents cannot access a data store directly on a Data Flow Diagram (DFD). Data stores are internal components of the system and can only be accessed by processes. Therefore, the statement "External agents can access a data store directly on a DFD" is not true.

Submit
80. Categories of Entities include all of the following EXCEPT:

Explanation

The given question asks for an exception among the categories of entities. The categories listed are place, person, objects, systems, and concepts. The correct answer is "systems" because it does not fit into the typical categories of entities. While places, persons, objects, and concepts can all be considered as entities, systems refer to a collection of interconnected elements or components working together to achieve a specific purpose, rather than being individual entities themselves.

Submit
81. Which class of data shows the communication between a system and its environment?

Explanation

Data flow is the class of data that shows the communication between a system and its environment. This class of data represents the movement of data between various components of a system, including inputs, processes, and outputs. It illustrates how data is transmitted, transformed, and received within a system, providing insights into the flow of information between different entities. Data flow diagrams are commonly used to visualize and analyze the data flow within a system, helping to identify potential bottlenecks, inefficiencies, or vulnerabilities in the communication process.

Submit
82. All of the following diagrams are used to model processes during systems analysis EXCEPT

Explanation

A component diagram is not used to model processes during systems analysis. Instead, it is used to represent the physical components of a system and their relationships. In systems analysis, other diagrams like context data flow diagrams, event diagrams, primitive diagrams, and system diagrams are used to model processes and interactions within a system.

Submit
83. What is application data model?

Explanation

The correct answer is "a data model for a complete, single information system." This means that an application data model is a representation of the structure and organization of data within a specific information system. It encompasses all the entities, relationships, and attributes necessary to fully describe the data and its relationships within that system. It is designed to provide a comprehensive view of the data and ensure that all the necessary information is captured and organized effectively.

Submit
84. What type of data flow diagram depicts the elementary processes, data stores, and data flows for a single event?

Explanation

A primitive diagram is a type of data flow diagram that depicts the elementary processes, data stores, and data flows for a single event. It focuses on the specific details of the event and breaks it down into its basic components. This diagram is used to analyze and understand the flow of data within a system for a particular event or process.

Submit
85. What is the logical unit of work that must be completed as a whole called?

Explanation

An event is the logical unit of work that must be completed as a whole. It represents a specific action or occurrence that triggers a response or a series of actions. Events can be used to organize and manage the flow of a system or program, ensuring that tasks are executed in the correct order and that dependencies are properly handled.

Submit
86. The types of logical processes include all of the following EXCEPT

Explanation

The given question asks for the type of logical processes that are NOT included among the options provided. The options given are function, event, elementary process, and sequence. Among these options, sequence is the correct answer because it is indeed a type of logical process. Therefore, the correct answer is sequence.

Submit
87. Which of the following is NOT a process model?

Explanation

A temporal system data flow diagram is not a process model because it does not depict the flow of processes or activities within a system. Instead, it focuses on the temporal aspects of data flow, such as the timing and sequencing of data inputs and outputs. Process models, on the other hand, represent the flow of processes and activities within a system, showing how data moves through different stages or steps. The other options listed - context data flow diagram, functional decomposition diagram, external event diagram, and use case list - are all examples of process models commonly used in software engineering and system analysis.

Submit
88. What is a relationship called in which each participating entity has its own independent primary key?

Explanation

A nonidentifying relationship is a type of relationship in which each participating entity has its own independent primary key. This means that each entity in the relationship can exist independently without relying on the other entity's primary key. In this type of relationship, the primary key of each entity is not used as a foreign key in the other entity. This allows for flexibility and independence between the entities involved in the relationship.

Submit
View My Results

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

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

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Feb 05, 2009
    Quiz Created by
    Kilikika
Cancel
  • All
    All (88)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
What is an outside person, unit, system, or organization that...
What is the act of breaking a system into sub components called?
The act of breaking a system into its component subsystems, processes,...
Which of the following is an external entity?
What is a process called that handles a given event in the event...
Which tool depicts the flow of data through a system and the work or...
Which of the following is the definition of an entity
An entity can be all of the following EXCEPT
What is a context diagram?
When data is at "rest" it is most likely an:
What do rounded rectangles represent in data flow diagrams?
What is the merger of multiple data flows into a single data flow...
What is the language syntax for specifying the logical of a process...
Which of the following is the definition for a composite data flow?
Which of the following is a type of data flow that splits into...
Which of the following is the best definition for an iteration...
Which of the following is a process that handles a given event?
Which of the following is a language syntax for specifying the logic...
What is a class of data that can be stored in an attribute called?
What does CASE stand for?
What is data model called that utilizes several notations to depict...
Which of the following is NOT considered a compound attribute
What is a candidate key called that is not selected to become the...
What is a tabular form of presentation that specifies a set of...
All of the following are synonyms for the term "Attribute" EXCEPT:
Which statement below is true about data flow diagrams (DFDs)?
Which of the following terms describes the smallest piece of data that...
You will find all of the following in use cases EXCEPT:
The CRUD in a CRUD matrix stands for?
With respect to data structures, what does the "=" mean?
Which word is a synonym for "logical model"?
Data flows can be described in terms of all of the following types of...
Which of the following is the best definition of a decision table?
One of a number of keys that may serve as the primary key of an entity...
What is an attribute called that assumes a unique value for each...
What is the property of an attribute called that defines what values...
Which of the following is the best definition for an iteration...
Which of the following terms is defined as a concept that requires...
All of the following are the types of events that are associated with...
Which of the following describes a set of rules that governs how a...
When mapping data requirements, it is important to ask all of the...
What is a process model used to document the scope for a system...
What concept requires that data flow diagrams at different levels of...
What is an analysis tool for finding and identifying business events...
Which of the following is a data model that includes all entities,...
Which of the event types are triggered on the basis of time, or...
What is the work performed by a system in response to incoming data...
What is the technique that compares the lifetime profitability of...
Which of the following is not a common synonym for "logical model"?
What is the legitimate values for an attribute called?
Which of the following is the definition of a domain?
What is the practice of ensuring that a data flow contains only data...
Which normal form would correspond to an entity whose non key...
All of the following is true about structured english except
Which type of normal form looks for transitive dependencies?
What does a data structure contain?
Which of the following is not part of a data flow diagram?
Which of the following is an example of a derived attribute?
All of the following are stages of logical data model development...
Which of the following best describes second normal form?
Which of the following best describes first normal form?
All of the following are part of process models EXCEPT:
What is a data entity called that derives one or more attributes from...
What is a data model called that includes entities and relationships...
What is the practice of ensuring that a data flow contains only data...
What is a data flow?
All of the following are properties for the values for each attribute...
Which of the following defines a relationship that exists between...
Data flows can be described in terms of all of the following data...
All of the following are examples of elementary process names EXCEPT
All of the following are valid rules for data flows EXCEPT
Which one of the following is a synonym of candidate key?
  What is the purpose of logical models?
Data models are superior for all of the following reasons EXCEPT:
Which of the following is not a reason why systems analysts focus on...
Which of the following is a synonym for logical model?
Which of the following is not a reason why system analysts focus on...
Each event process should be described to the CASE repository with all...
Which of the following is NOT true of an external agent?
Categories of Entities include all of the following EXCEPT:
Which class of data shows the communication between a system and its...
All of the following diagrams are used to model processes during...
What is application data model?
What type of data flow diagram depicts the elementary processes, data...
What is the logical unit of work that must be completed as a whole...
The types of logical processes include all of the following EXCEPT
Which of the following is NOT a process model?
What is a relationship called in which each participating entity has...
Alert!

Advertisement