INSY CHAPTER 9-11 EXAM QUESTIONS ANSWERED CORRECTLY LATEST UPDATE 2026

INSY CHAPTER 9-11 EXAM QUESTIONS ANSWERED CORRECTLY LATEST UPDATE 2026 True - AnswersHuman errors are mistakes made by computer operators True - AnswersIterative SDLCs are often referred to as "agile methods" because they allow flexibility as development progresses. False - AnswersHorizontal market software is designed to meet the needs of a single industry while vertical market software meets the needs of many different industries - customer support - Sales - Marketing - AnswersWhich of the following is a core CRM system Convert Data - AnswersThe maintenance phase of a SDLC includes all of the following except _________. False - AnswersFraud alerts interfere with your ability to receive instant credit False- DSS does not make the actual decision - AnswersA DSS manipulates the data needed to make a decision as well as making a decision False - AnswersDetailed application specifications can be developed before or after selecting the hardware and software for an information system True - AnswersA major source of data for CRM is produced by loyalty programs. False - AnswersAs the design phase of a SDLC begins, programming languages, development tools, and application software needed for the new information system are purchased, installed, and tested to ensure that they work correctly. - computers, communications networks, and data - people and products - policies and procedures ALL OF THE ABOVE - AnswersThe scope of an information system includes which of the following? TQM - AnswersWhich business practice is a technique initiated by top management that involves all employees and all departments, and focuses on quality assurance in every product and service offered to customers? False- this would be a procedure handbook - AnswersSystem documentation contains step-by-step instructions for performing specific tasks. - Study the current system - Determine system requirements - Write requirements report - AnswersWhich of the following is a part of the analysis phase of a SDLC? organization - AnswersA(n) _____________ is a group of people working together to accomplish a goal. True - AnswersAt an ecommerce site, the merchant's ecommerce application carries out only the first and last stages of the payment process. True - AnswersData centers are designed to proactively reduce the risk of data loss that might occur as a result of a disaster. CRM - Answers_______ applications provide optimal information when they encompass customer support, marketing, and sales. supply chain - AnswersA(n) ___________ is the sequence of organizations, people, activities, information, and resources involved in moving a product or service from supplier to customer Deterrents - AnswersWhich type of security measure reduces the likelihood of a deliberate attack? True - AnswersApplication software for an information system is usually a series of preprogrammed software modules supplied by a software publisher. C2C - AnswersWhich ecommerce classification encompasses consumers selling merchandise and services to each other? B2C - AnswersWhich ecommerce classification encompasses online storefronts selling merchandise and services to consumers? - product planning - manufacturing and purchasing - inventory control and distribution - AnswersIn addition to sales, CRM, and SCM, ERP modules support business activities such as _____________. - Collect, display, and modify transactions. - Store transactions. - List transactions. ALL OF THE ABOVE - AnswersA transaction processing system is characterized by its ability to: True - AnswersAcceptance testing is designed to verify that the new information system works as required. True - AnswersA lookup routine validates an entry by checking data in an in-house or third-party database The 3rd platform - AnswersAn emerging computing platform that is likely to drive innovation and disruption through the next decade called __________ has massive scale, not only in cloud-based hardware technology, but also in the vast amount of data that will be generated, consumed, and analyzed serializability - AnswersA DBMS feature known as __________ ensures that transactions are updated in an orderly manner by establishing update rules True - AnswersThe goal of normalization is to minimize data redundancy. True - AnswersA table's physical sort order is the order in which records are arranged on storage devices. scale up, scale out - AnswersA __________ solution for data storage adds resources to a single device, while a __________ solution adds more devices to a system. False - AnswersSQL statements contain command words but do not contain data. Browsers - Answers__________ are the most commonly used database clients. JOIN - AnswersThe SQL ________ command allows you to temporarily join and simultaneously access the data in more than one table. False - AnswersSQL keywords must be entered in all uppercase letters because they are case-sensitive. BLOB - AnswersWhich database data type is a collection of binary data stored in a single field of a database? field validation rule - AnswersA(n) _____________ is a specification that the database designer sets up to filter data entered into a particular field. True - AnswersDynamic scaling for database servers can be a challenge because the additional sharding has to be handled on the fly by the DBMS. Field - AnswersIn a database, a(n) __________ contains the smallest unit of meaningful information report generator - AnswersA(n) ________________ is a software tool for specifying the content and format for a database report. False - AnswersIn a case-sensitive database, uppercase letters are equivalent to their lowercase counterparts. False - AnswersA filing cabinet full of folders and papers would be classified as a structured file because every document has a unique structure. sort key - AnswersA(n) __________ is the column of data in a database that is used as the basis for rearranging the data. DBMS - AnswersThe acronym ____________ refers to software that manages data stored in a database. single-level, multi-level - AnswersA(n) _________ sort uses one field, to arrange records. A(n) _________ sort arranges information by more than one field. a. Local software b. Browsers c. Apps ALL OF THE ABOVE - AnswersWhich of the following is not considered to be type of database client? False - AnswersSpreadsheet software offers database capabilities for establishing relationships between different record types. Spreadsheet software - AnswersWhich database tool is best for simple flat files that involve calculations? OLAP - Answers__________ is a data analysis technique used by decision makers to quickly get answers to complex queries that encompass multiple factors, such as locations, revenue, time periods, and employee status. True - AnswersIn a relational database, relationships are specified by joining common data stored in records from different tables. source code - AnswersThe human-readable version of a program created in a high-level language by a programmer is called __________. Encapsulation - Answers_________________ refers to the process of hiding the internal details of objects and their methods. True - AnswersMicroprocessors only understand machine language, so there has to be some way to convert assembly language instructions into 1s and 0s main() - AnswersRegarding OO programming, which of the following terms best matches with the term "method"? True - AnswersProlog and other declarative languages were classified as fifth-generation languages. False - AnswersProgrammers insert documentation called facts into the program code. Flow Control - AnswersWhat is the term that refers to the sequence in which a computer executes program instructions? public attribute, private attribute - AnswersA(n) __________ is available for use by any routine in the program while a(n) _______________ can be accessed only from the routine in which it is defined. known information - AnswersThe _____________ in a problem statement is the information that is supplied to the computer to help it solve a problem. True - AnswersProcedural languages encourage programmers to approach problems by breaking the solution down to a series of steps. True - AnswersSome software engineering activities overlap with the systems analysis and design activities instantiation - AnswersFinding a value for a variable is referred to as ___________. True - AnswersThe process of planning a computer program begins with a problem statement that clearly define the program's purpose. True - AnswersThe facts in a Prolog program are useful even without any rules. Variables - AnswersProlog allows you to ask open-ended questions by replacing constants with __________. code - AnswersThe instructions that make up a computer program are sometimes referred to as __________. VDE - AnswersA(n) _________ provides programmers with tools to build substantial sections of a program by pointing and clicking rather than typing lines of code. algorithm - AnswersA(n) ____________ for a computer program is a set of steps that explains how to begin with known information specified in a problem statement and how to manipulate that information to arrive at a solution. True - AnswersAn API is a set of application or operating system functions that programmers can add to the programs they create. selection control structure - AnswersA(n) ________________ tells a computer what to do based on whether a condition is true or false. True - AnswersWhen taking the object-oriented approach to a problem, one of the first steps is to identify the objects that pertain to a solution. False - AnswersA low-level language uses command words and grammar based on human languages. compiler, object code - AnswersA(n) ___________ converts all the statements in a program in a single batch, and the resulting collection of instructions, called ________, is placed in a new file. predicate, arguments - AnswersIn Prolog, the __________ describes the relationship between the _________ . True - AnswersProlog programming is all about facts and rules.