INFX 380 Final Exam Review

SP2023 INFX 380 Review Flashcards

\_____ combine data from different item attributes, or characteristics, to build code.

Derivation codes

In the accompanying figure, a \___ is a field or combination of fields that uniquely and minimally identifies a particular member of an entity.

Primary key

\_____ is designed to serve the needs of a specific department, such as sales, marketing, or finance

A data mart

If a primary key combines two or more fields, then it is called a \_____.

Composite key

\_____ describes the numeric relationship between two entities and shows how instances of one entity relate to an instance of another entity

Cardinality

\___ is an industry-standard protocol that makes it possible for software from different vendors to interact and exchange data.

Open Database Connectivity (ODBC)

Designing tables is easier if a \_____ is used to show a table’s structure, fields, and primary key

Standard notation format

One type of validity check, called \_____, is a set of rules that avoids data inconsistency and quality problems

Referential integerity

A \_____ is a set of letters or numbers that represents a data item

Code

Some abbreviation codes are called \_____ codes because they use a specific combination of letters that are easy to remember.

Mnemonic

The complete definition of a database, including descriptions of all fields, tables, and relationships, is called a \_____.

Schema

The data mining technique that relies on association rule learning is often called \_____.

Market basket analysis

\_____, a coding method that uses one byte per character, is used on mainframe computers and high-capacity servers.

EBCDIC (Extended Binary Coded Decimal Interchange Code)

To bridge the gap between a database and the internet, it is necessary to use \_____, which is software that integrates different applications and allows them to exchange data.

Middleware

In the accompanying figure, any field that serves as a primary key is called a \_____.

candidate key

\_____ is an integrated collection of data that can include seemingly unrelated information, no matter where it is stored in the company.

Data warehouse

\_____ means that a system can be expanded, modified, or downsized easily to meet the rapidly changing needs of a business enterprise

Scalability

A \_____ is a field in one table that must match a primary key value in another table in order to establish the relationship between the two tables

Foreign key

With a \_____, users provide an example of the data requested

Query by example language

In an entity-relationship diagram, entities are commonly represented as \______.

Rectangle

\_____ is the process of converting readable data into unreadable characters to prevent unauthorized access to the data

Encryption

\_____ uses a keyword to encode a number

Cipher codes

\_____ enables Java applications to exchange data with any database that uses SQL statements and is compliant with its standard

Java Database Connectivity (JDBC)

When developing e-business systems, an in-house solution usually requires a \______ for a company that must adapt quickly in a dynamic e-commerce enviroment

Greater initial investment but provides more flexibility

When an individual user works in \______, the workstation performs all the functions of a server by storing, accessing, and processing data as well as providing a user interface

Stand-alone mode

\_____ relies on collective data paths to increase bandwidth and range

Multiple input/multiple output (MIMO) technology

Many companies are extending internal enterprise resource planning (ERP) systems to their suppliers and customers, using a concept called \_____.

Supply chain management (SCM)

A \_____ design locates all or most of the processing logic on the server.

Thin client

Which configuration has a central wireless device that is used to serve all wireless clients?

The Basic Service Set (BSS)

The \_____ was formed in 1999 to certify interoperability of wireless network products based on IEEE 802.11 specifications.

Wi-Fi Alliance

A \_____ is relatively inexpensive to install and is well-suited to workgroups and users who are not anchored to a specific desk or location.

Wireless local area network (WLAN)

A \_____ resembles a group of computers in which data flows in only one direction from one device to the next.

Ring network

In it’s wireless configuration, the \_____ is similar to a hub in the local area network (LAN) star topology, except it provides network services to wireless clients instead of wired clients

Access point

\_____ establishes a company-wide strategy for IT resources and specific standards for data, processing, network, and user interface design

Enterprise Resource Planning (ERP)

A main advantage of enterprise resource planning (ERP) is that it describes a \_____ that ensures connectivity and easy integration of future systems, including in-house software and commercial packages

Platform

The \_____ standard uses multiple input/multiple output (MIMO) technology to boost performance

802.11ac

\_____ describes the way the components in a network interact

logical topology

A disadvantage of a bus network is that \_____

Performance can decline as more users and device are added

\_____ translate(s) the logical design of an information system into a physical structure that includes hardware, software, network support, and processing methods.

System architecture

The term “\_____” generally refers to systems that divide processing between one or more networked clients and a central server.

Client/server

User documentation \_____.

consists of instructions and information for users who will interact with the system

A(n) \_____ refers to a web-based broadcast that allows a user to download multimedia files to a PC or portable device.

Podcast

Successful completion of system testing is the key to user and management approval, which is why system tests sometimes are called \_____.

Acceptance test

When developing a training program, which guideline should be kept in mind?

Select the most effective place to conduct the training

\_____ requires that a software supplier document all testing and maintain records of test results.

The International Organization for Standardization (ISO)

As the accompanying figure illustrates, the \_____ approach causes the changeover from the old system to the new system to occur immediately when the new system becomes operational.

Direct cutover

The environment for the actual system operation is called the \_____.

Production environment

\_____ graphically represent the logical rules and interaction between program modules using a series of symbols connected by arrows.

Flowcharts

\_____ is the process of putting a new information system online and retiring the old system.

System changeover

\_____ measures a module’s scope and processing characteristics.

Cohesion

Using a \_____ strategy, knowledgeable users can be selected who then conduct sessions for others

train-the-trainer

\_____ describes the degree of of interdependence among modules

Coupling

\_____ involves more risk than other changeover methods

Direct cutover

Which is specified by the detailed procedures in a test plan?

The test data to be used

A \_____ consists of related program code organized into small units that are easy to understand and maintain

module

The Software Engineering Institute (SEI) established a new model, called \_____, which incorporates software and systems development into a much larger framework

Capability Maturity Model Integration (CMMI)

A class diagram includes the class \_____, which describes the characteristics of objects in the class

attributes

The \_____ documents a system at the end of the design phase, identifies any changes since the beginning of the project, and includes testing and verification of all system requirements and features

Allocated baseline

In maintenance management, \_____ involves studying the parts of a system to understand the overall system

synthesis

Many IT departments use a job title of \_____ to designate positions that require a combination of systems analysis and programming skills

programmer/analyst

In addition to benchmark testing, performance measurements, called \_____, can monitor the number of transactions processed in a given time period, the number of records accessed, and the volume of online data

metrics

\_____ includes monitoring a system for signs of trouble, logging all system failures, diagnosing the problem, and applying corrective action

fault management

\_____ costs include expenses for items such as supplies and equipment rental

operational

Perfective maintenance usually is cost effective \_____ a system’s operational life.

during the middle of

The first step in managing IT security is to develop a \_____ based on confidentiality, integrity, and availability

security policy

\_____ measures the time between submitting a request for information and the fulfillment of the request

Turnaround time

A ______ displays the same information as the Gantt chart, including task dependencies, but uses task boxes to include much more details

Network diagram

\_____ lists each risk and assesses the likelihood that it could affect a project

Risk identification

Project monitoring, an activity of a project manager, \_____

Requires guiding, supervising, and coordinating a project team’s workload

\_____, a free cloud-based project management tool, runs in a browser window, so there is no software to install to use it

Gantter

A \_____ is a proactive effort to anticipate risk and describe an action plan to deal with it

Risk response plan

When maintaining schedules, if enough \_____ and frequent checkpoints exist, problems will be detected rapidly

milestones

A \_____ chart displays complex task patterns and relationships

PERT

Two or more \_____ depend on a predecessor task

concurrent tasks

Project planning, an activity of a project manager, \______

Includes identifying project tasks and estimating completion times and costs

Using a(n) \_____, a project manager can convert task start and finish times to actual dates by laying out the entire project on a calendar

Program Evaluation Review Technique (PERT) chart

What is a scrum development team expected to do during the first Sprint? Two correct answers.

Test the product & Build a thin slice of potentially shippable functionality

Who is the product owner? Three correct answers.

Accept/reject work results; Responsible for ROI; Focuses more on what than how

Which is NOT part of a family of methods designed to respond to the challenges of unpredictable projects?

Fixed scope

A person who acts on behalf of customer to represent their interests is called a

Product owner

The CEO asks the Development Team to add an activity to the current Sprint. What should the Development Team do?

Inform the Product Owner so he/she can work with the CEO

Which of these agile principles is where teams reflect, learn, and adapt to change; work informs the plan?

Continuous improvement

What is included in the manifesto for Agile Software Development? Two correct answers

Working Software & Responding to change

All of the following are part of the Agile Project Management model except \_____.

Design up front

What is NOT the question to ask at the daily scrum?

What is the newest schedule changes?

Who is the scrum master? Two correct answers.

Focuses more on the how than the what & Has no authority

How often do experienced Agile software developers test?

Every time the code changes

What’s a good use for velocity?

To help the product owner make forecasts on what might be done by a given release date

Which of thee following are more effective solutions? Three correct answers.

A volunteer agrees to a specific action by a specific date; Team writes concrete adjustments to its working agreements; Team agrees to try a different approach as an experiment for one Sprint

What is the first thing we should see at the Sprint Review Meeting?

Live demonstration of a potentially shippable (properly tested) product increment

What is the definition of “done” int eh project development team? Three correct answers.

Code refactored, Properly tested, Potentially shippable

When is Sprint execution completed?

When the timebox expires

When were product backlogs committed to the Sprint?

During the sprint planning meeting

What is the best time within the Sprint Review Meeting to discuss feedback from outside stakeholders?

The end, after demo and measurement of which goals were achieved

What should we do now that we’ve seen the product demonstration, the declaration of what’s done, and a measurement of velocity?

Get feedback from stakeholders leading to a new PBIs and the possible re-prioritization

Many companies had an installed base of data, called \____, which was difficult to access and transport to a client/server environment.

Legacy data

The \____ describes how data actually moves from an application on one computer to an application on another networked computer.

OSI (Open Systems Interconnection) model

A \____ follows Internet design protocols and enables a company to integrate new applications into its e-commerce strategy.

Web-centric architecture

\____ is the amount of data that can be transferred in a fixed time period.

Bandwidth

The \____ allows the expansion of wireless access over a wide area.

Extended Service Set (ESS) topology