INSY exam 3 aaaaaaaaaaaaaaaaaaaaa
Studied by 0 people
Call Kai
Learn
Practice Test
Spaced Repetition
Match
Flashcards
Knowt Play1/96
There's no tags or description
Looks like no tags are added yet.
Name | Mastery | Learn | Test | Matching | Spaced |
|---|
No study sessions yet.
97 Terms
The scope of an information system includes which of the following?
a. computers, communications networks, and data
b. people and products
c. policies and procedures
d. All of the above
d. All of the above
A(n) _____________ is a group of people working together to accomplish a goal.
a. information system
b. organization
c. TPS
d. MIS
b. organization
Which type of problem requires human intuition as the basis for finding a solution.
a. Structured
b. Unstructured
c. Semistructured
d. none of the above
b. Unstructured
Most modern transaction processing systems use ________ processing—a realtime method in which each
transaction is processed as it is entered.
a. batch
b. online
c. inline
d. none of the above
b. online
A transaction processing system is characterized by its ability to:
a. Collect, display, and modify transactions.
b. Store transactions.
c. List transactions.
d. all of the above
d. all of the above
Which of the following is not a characteristic of a management information system?
a. Collect, display, and modify transactions
b. Provides useful information for managerial activities
c. Increases managerial efficiency
d. Produces routine and ondemand reports
a. Collect, display, and modify transactions
The process of designing, entering, and testing the rules in an expert system is referred to as __________.
a. DSS
b. knowledge engineering
c. expert system
d. decision model
b. knowledge engineering
Which ecommerce classification encompasses online storefronts selling merchandise and services to consumers?
a. C2C
b. B2B
c. B2C
d. B2G
c. B2C
Which ecommerce classification encompasses consumers selling merchandise and services to each other?
a. C2C
b. B2G
c. B2C
d. B2B
a. C2C
A key component of an ecommerce application is an online _________.
a. DSS
b. cookie
c. MIS
d. cart
d. cart
A(n) ___________ is the sequence of organizations, people, activities, information, and resources involved in
moving a product or service from supplier to customer.
a. supply chain
b. payment gateway
c. ecommerce application
d. payment processing routine
a. supply chain
_______ applications provide optimal information when they encompass customer support, marketing, and sales.
a. SCM
b. CRM
c. Supply chain
d. all of the above
b. CRM
Which of the following is not a core CRM system?
a. sales
b. marketing
c. customer support
d. payment gateway
d. payment gateway
In addition to sales, CRM, and SCM, ERP modules support business activities such as _____________.
a. product planning
b. manufacturing and purchasing
c. inventory control and distribution
d. all of the above
d. all of the above
The goal of the planning phase for an information system project is to create a(n) ____________.
a. iterative SDLC
b. systems analysis and design
c. project development plan
d. system development life cycle
c. project development plan
The planning phase of a SDLC includes all of the following except _________.
a. assembling the project team
b. writing a requirements report
c. justifying the project
d. producing a project development plan
b. writing a requirements report
Which of the following is not included in Michael Porter's Five Forces model?
a. Supply chain efficiency
b. Bargaining power of buyers
c. Bargaining power of suppliers
d. Threat of new entrants
a. Supply chain efficiency
Which 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?
a. BRP
b. SDLC
c. MRP
d. TQM
d. TQM
Industry standard tools for scheduling and project management include PERT, WBS, and ________.
a. TQM
b. BRP
c. ERP
d. Gantt charts
d. Gantt charts
Which of the following is not part of the analysis phase of a SDLC?
a. Develop a project schedule
b. Determine system requirements
c. Write requirements report
d. Study the current system
a. Develop a project schedule
The current standard for objectoriented documentation is referred to as ______.
a. XML
b. UML
c. HTML
d. DSS
b. UML
The design phase of a SDLC includes all of the following except _________.
a. Select hardware and software
b. Develop application specifications
c. Identify potential solutions
d. Write requirements report
d. Write requirements report
The implementation phase of a SDLC includes all of the following except _________.
a. Obtain approval
b. Purchase or contract for hardware and software
c. Test applications
d. Create applications
a. Obtain approval
After unit and integration testing are completed, _________ testing ensures that all hardware and software
components work together.
a. application
b. system
c. unit
d. integration
b. system
The maintenance phase of a SDLC includes all of the following except _________.
a. Make backups
b. Optimize for speed and security
c. Convert data
d. Revise as necessary to meet business needs
c. Convert data
Three key concepts ensure good quality of service include all of the following except _______ .
a. reliability
b. convertibility
c. availability
d. serviceability
b. convertibility
Dark data centers are an extension of ___________, which allows system administrators to monitor and manage
servers using remote control software.
a. colocation
b. fuzzy logic
c. lightsout management
d. none of the above
c. lightsout management
Which type of security measure reduces the effect of an attack by using data backups, disaster recovery plans, and
the availability of redundant hardware devices?
a. Corrective procedures
b. Preventive countermeasures
c. Detection activities
d. Deterrents
b. Preventive countermeasures
Which type of security measure reduces the likelihood of a deliberate attack?
a. Preventive countermeasures
b. Detection activities
c. Corrective procedures
d. Deterrents
d. Deterrents
Which of the following is not a step that a data breach victim should take?
a. Change your passwords
b. Activate a fraud alert
c. Get informed about the breach
d. Purchase a new computer or device
d. Purchase a new computer or device
In a __________ database, processing logic for the query is performed on the device that holds each database
shard and if necessary, results are consolidated by the DBMS.
a. SQL
b. NoSQL
c. relational
d. OLAP
b. NoSQL
A __________ solution for data storage adds resources to a single device, while a __________ solution adds
more devices to a system.
a. SQL, NoSQL
b. structured, unstructured
c. scale out, scale up
d. scale up, scale out
d. scale up, scale out
An 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.
a. The 3rd platform
b. NoSQL
c. SQL
d. BLOB
a. The 3rd platform
The SQL ________ command allows you to temporarily join and simultaneously access the data in more than one
table.
a. MERGE
b. JOIN
c. SELECT
d. UPDATE
b. JOIN
Which SQL keyword is used to search for records?
a. FIND
b. SEARCH
c. SELECT
d. UPDATE
c. SELECT
Which of the following is not a SQL keyword?
a. DELETE
b. REMOVE
c. CREATE
d. SELECT
b. REMOVE
A(n) ________________ is a software tool for specifying the content and format for a database report.
a. report generator
b. database index
c. sort key
d. primary key
a. report generator
A(n) __________ is the column of data in a database that is used as the basis for rearranging the data.
a. primary key
b. sort key
c. data type
d. keyvalue
b. sort key
Which database data type is a collection of binary data stored in a single field of a database?
a. Memo
b. Integer
c. BLOB
d. Logical
c. BLOB
Which database data type is used for fields that contain whole numbers—quantities, repetitions, rankings, and so
on?
a. Logical
b. Real
c. Integer
d. Memo
c. Integer
Which of the following would not be considered a database data type?
a. Real
b. SELECT
c. BLOB
d. Memo
b. SELECT
A(n) _____________ is a specification that the database designer sets up to filter data entered into a particular
field.
a. database structure
b. computed field
c. field format
d. field validation rule
d. field validation rule
A(n) ____________ is a template that adds the correct formatting as data is entered. If someone attempts to
enter data in the wrong format, the database can be set up to reject that entry or correct it.
a. field format
b. primary key
c. database structure
d. parameter
a. field format
A(n) _______________ is a field that contains data unique to a record.
a. query
b. parameter
c. primary key
d. keyvalue
c. primary key
A computed ___________ is a calculation that a DBMS performs, similar to the way a spreadsheet computes a
formula.
a. table
b. field
c. record
d. relationship
b. field
__________ are the most commonly used database clients.
a. Local software
b. Apps
c. Browsers
d. none of the above
c. Browsers
Which of the following is not considered to be type of database client?
a. Local software
b. Browsers
c. Apps
d. all of the above
d. all of the above
A DBMS feature known as __________ ensures that transactions are updated in an orderly manner by
establishing update rules.
a. serializability
b. optimization
c. prioritization
d. normalization
a. serializability
The acronym ____________ refers to software that manages data stored in a database.
a. ERP
b. SQL
c. OLAP
d. DBMS
d. DBMS
A(n) _________ sort uses one field, to arrange records. A(n) _________ sort arranges information by more than
one field.
a. singlelevel, multilevel
b. multilevel, singlelevel
c. structured, unstructured
d. SQL, NoSQL
a. singlelevel, multilevel
Which database tool is best for simple flat files that involve calculations?
a. Database software
b. Spreadsheet software
c. Word processing software
d. DBMS
b. Spreadsheet software
Modern database tools support ________________, which entails separating data from the programs that
manipulate data.
a. Predictive analytics
b. Cardinality
c. data independence
d. data dependence
c. data independence
The relationship between record types can be depicted graphically with a(n) _________.
a. data archive
b. executive dashboard
c. OLAP
d. ERD
d. ERD
A record that contains data is referred to as a record ________.
a. occurrence
b. type
c. template
d. file
a. occurrence
In a database, a(n) __________ contains the smallest unit of meaningful information
a. record
b. field
c. table
d. model
b. field
__________ refers to a branch of data mining that analyzes current and historical data to predict future trends.
a. Predictive analytics
b. OLAP
c. Data warehouse
d. TPS
a. Predictive analytics
_________ 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.
a. SQL
b. OLAP
c. NoSQL
d. TPS
b. OLAP
Data _________ refers to computer algorithms that analyze information to discover previously unknown and
useful information, including relationships and patterns.
a. analytics
b. OLAP
c. mining
d. model
c. mining
Which of the following is not one of the main activities associated with operational databases?
a. Collect, store, and view data
b. Update and find data
c. organizing and distributing data
d. providing an executive dashboard for decision makers
d. providing an executive dashboard for decision makers
A(n) _________ database is used to collect data that will be used for spotting trends that offer insights for tactical
and strategic business decisions.
a. relational
b. operational
c. analytical
d. non relationa
c. analytical
A(n) _________ database is used to collect, modify, and maintain data on a daily basis.
a. non relational
b. operational
c. relational
d. analytica
b. operational
____________ encompasses a broad set of activities that include planning, coding, testing, and documenting while
a related activity, __________, is a development process that uses mathematical, engineering, and management
techniques to reduce the cost and complexity of a computer program while increasing its reliability and modifiability.
a. Software engineering, computer programming
b. Computer programming, software engineering
c. Application programming, systems programming
d. Systems programming, application programming
b. Computer programming, software engineering
The instructions that make up a computer program are sometimes referred to as __________.
a. code
b. control
c. encapsulation
d. function
a. code
Which of the following is not a characteristic for a good problem statement?
a. It specifies any assumptions that define the scope of the problem.
b. It contains detailed descriptions of the processes and tools that need to be developed.
c. It clearly specifies the known information.
d. It specifies when the problem has been solved
b. It contains detailed descriptions of the processes and tools that need to be developed.
In a problem statement, you can limit complexity by making ____________.
a. objects
b. variables
c. constants
d. assumptions
d. assumptions
The _____________ in a problem statement is the information that is supplied to the computer to help it solve a
problem.
a. known information
b. assumption
c. algorithm
d. predicate
a. known information
A(n) __________ is a factor that remains the same throughout a program.
a. algorithm
b. variable
c. object
d. constant
d. constant
A(n) _________ provides programmers with tools to build substantial sections of a program by pointing and
clicking rather than typing lines of code.
a. repetition control structure
b. interprete
c. VDE
d. superclass
c. VDE
A low-level language has a low level of ___________ because it includes commands specific to a particular CPU
or microprocessor family.
a. flow control
b. abstraction
c. syntax
d. iteration
b. abstraction
_______________, such as BASIC, Python, Java, Prolog, and C++, make the programming process easier by
replacing unintelligible strings of 1s and 0s or cryptic assembly commands with understandable commands, such as
PRINT and WRITE.
a. Lowlevel languages
b. Highlevel languages
c. First generation languages
d. Multiparadigm languages
b. Highlevel languages
_________-generation languages, such as COBOL and Fortran, were used extensively for business and
scientific applications.
a. First
b. Second
c. Third
d. Fourth
c. Third
In 1969, computer scientists began to develop high-level languages, called ________-generation languages, which
more closely= resembled human languages.
a. second
b. third
c. fourth
d. none of the above
c. fourth
The human-readable version of a program created in a high-level language by a programmer is called
__________.
a. source code
b. op code
c. object code
d. structured English
a. source code
A(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.
a. constant, variable
b. object code, compiler
c. compiler, object code
d. interpreter, compiler
c. compiler, object code
Which of the following is a scripting language?
a. Ruby
b. Perl
c. PHP
d. all of the above
d. all of the above
Which of the following is not a programming paradigm?
a. Declarative
b. Procedural
c. ObjectOriented
d. Predictive
d. Predictive
Which programming language is used for artificial intelligence applications and expert systems?
a. Prolog
b. COBOL
c. C++
d. Objective C
a. Prolog
Which programming language is an interpreted language most commonly used for client-side Web scripting, such as
animating page elements and validating input on HTML forms?
a. Prolog
b. Pythod
c. Java
d. Javascript
d. Javascript
A(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.
a. control
b. algorithm
c. syntax
d. parameter
b. algorithm
A(n) _________ is a graphical representation of the way a computer should progress from one instruction to the
next when it performs a task.
a. paradigm
b. flowchart
c. pseudocode
d. VDE
b. flowchart
What is the term that refers to the sequence in which a computer executes program instructions?
a. control structure
b. Flow control
c. walkthrough
d. none of the above
b. Flow control
A(n) _____________ changes the order in which instructions are carried out by directing the computer to
execute an instruction elsewhere in the program.
a. sequential execution
b. formal method
c. programming paradigm
d. sequence control structure
d. sequence control structure
A(n) __________ is a section of code that is part of a program, but is not included in the main sequential execution
path.
a. function
b. goto
c. method
d. iteration
a. function
A(n) ________________ tells a computer what to do based on whether a condition is true or false.
a. sequence control structure
b. selection control structure
c. repetition control structure
d. walkthrough
b. selection control structure
In a repetition control structure, the computer is directed to repeat one or more instructions until a certain condition
is met. The section of code that repeats is usually referred to as a(n) ___________.
a. algorithm
b. compiler
c. iteration
d. rule
c. iteration
The ________________ paradigm is based on the idea that the solution for a problem can be visualized in terms
of objects that interact with each other.
a. declarative
b. object-oriented
c. procedural
d. none of the above
b. object-oriented
A(n) _____________ defines the characteristics of a set of objects.
a. class attribute
b. control structure
c. function
d. method
a. class attribute
A(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.
a. public attribute, class attribute
b. private attribute, class attribute
c. public attribute, private attribute
d. class attribute, public attribute
c. public attribute, private attribute
___________ provides OO programs with easy extensibility and can help simplify program control structures.
a. Polymorphism
b. Inheritance
c. Encapsulation
d. Abstraction
a. Polymorphism
Regarding OO programming, which of the following terms best matches with the term "method"?
a. algorithm
b. pseudocode
c. syntax
d. main()
d. main()
Computer historians believe that ____________ was the first programming language to work with objects, classes,
inheritance, and methods.
a. COBOL
b. SIMULA
c. Python
d. Java
b. SIMULA
_________________ refers to the process of hiding the internal details of objects and their methods.
a. Abstraction
b. Encapsulation
c. Assumption
d. Polymorphism
b. Encapsulation
The _______________ paradigm describes aspects of a problem that lead to a solution.
a. procedural
b. declarative
c. objectoriented
d. none of the above
b. declarative
In Prolog, the __________ describes the relationship between the _________ .
a. argument, predicates
b. predicate, rules
c. rule, arguments
d. predicate, arguments
d. predicate, arguments
Prolog allows you to ask openended questions by replacing constants with __________.
a. parameters
b. variables
c. functions
d. rules
b. variables
Finding a value for a variable is referred to as ___________.
a. instantiation
b. abstraction
c. argument
d. inheritance
a. instantiation
In the context of Prolog programming, a(n) ________________ is a tabular method for visualizing and specifying
rules based on multiple factors.
a. selection control structure
b. decision table
c. formal method
d. storyboard
b. decision table