CIS Computers 5-11

Software that helps design new software

CASE tools

An informational message inserted into the program source code

Comment

A tool that helps identify and correct problems in software code.

Debugger

An application used for creating web pages

Dreamweaver

True or False: A database designer's data-mining techniques guide the process of developing and maintaining the database structures.

F

True or False: The process of structuring a database to avoid duplication of entries and undesirable relationships between entries is called data validation.

F

True or False: Checking for referential integrity involves making sure that the records entered into tables remain consistent with the relationships between the tables.

T

True or False: Visualization as a Service (VaaS) involves hiring an expert to transform data into stunning visuals.

T

A _____ is a business activity that is central to the nature of an enterprise, such as a product being sold or an airline flight being booked. Select one: a. transaction b. selection c. communication

a

In which of the following environments is FORTRAN still commonly used? a. factories and laboratories b. government agencies c. corporate headquarters d. colleges and universities

a

Java has _____, which means it can run on nearly any operating system. a. cross-platform compatibility b. nonprocedural language c. communication facilitation d. scripting language

a

Linear programming a. determines the optimal outcome under certain conditions. b. is a programming language similar to Visual Basic. c. is a programming language similar to Java. d. determines the quickest route to get to a destination.

a

Some professional programmers use _____ to develop software prototypes and custom interfaces for Windows platforms. a. Visual Basic (VB) b. BASIC c. C++ d. COBOL

a

Suppose that a store manager wants to identify the ten highest sales amounts for the past week. Which of the following database management tools should he or she use to display only this data? a. data filter b. data designer c. data warehouse d. data checker

a

When a program is run, which programming element performs an action (such as sending output to a printer) and then proceeds to the next statement in the sequence? a. executable statement b. decision statement c. loop d. variable

a

Which classification of computer languages is relatively similar to natural languages, such as English? Select one: a. high-level language b. machine code c. low-level language d. syntax

a

Which of the following methods for dealing with big data involves finding patterns and relationships in order to apply an organizing structure? Select one: a. data mining b. analytics c. data visualization d. modeling

a

Which of the following might be a disadvantage of using a distributed database? a. reduced speed b. high cost c. difficult expansion d. limited storage capability

a

Which of the following statements describes a variable? a. It's a data value stored in computer memory. b. It allows a program to return to a previously executed instruction and repeat it. c. It's a point where different actions may be performed depending on specific conditions. d. It's used to perform actions in a sequence.

a

Which type of processing updates the database immediately after a transaction occurs? Select one: a. transactional processing b. data filtering c. batch processing d. hybrid processing

a

Which type of programming statement allows a program to perform differently depending on whether a condition has been met? Select one: a. decision statement b. comment c. executable statement d. loop

a

_____ is a new Apple-developed language that may soon replace Objective-C as the preferred programming language for developing the iOS and macOS operating systems, as well as applications that run on those platforms. a. Swift b. Perl c. Java d. JavaScript

a

_____, which is the duplication of one or more fields of data in multiple tables, creates opportunities for error. a. Redundancy b. Integrity c. Metadata d. Duplicity

a

A database that uses different models together to handle data is called a _____. Select one: a. universal warehouse b. hybrid database c. multimodal database

b

A popular query language is _____. Select one: a. Legacy Database Language b. Structured Query Language c. Query by Example

b

A program with a single syntax error a. will usually work but may have ongoing problems. b. won't work at all and will therefore be useless. c. will always work but may be unstable. d. will run more slowly than one without any syntax errors

b

A(n) _____ check will prevent users from entering incorrect characters in a field, such as a percentage sign (%) in a field designated for customer last names. a. completeness b. alphanumeric c. consistency d. referential integrity

b

Before being written in a programming language, a program is first written out as a(n) _____, which is a complete list of the steps for solving a problem. Select one: a. function b. algorithm c. pseudocode d. variable

b

Graphics designed especially for online use can contain _____, in which different hyperlinks are assigned to different spots on the graphic. Select one: a. modules b. hotspots c. placeholders d. animation

b

If an address is stored in multiple data tables, it will need to be changed in all the tables if a customer moves. This is an example of which of the following? a. normalization b. redundancy c. integrity d. corruption

b

In which of the following environments is RPG commonly used? Select one: a. academic b. business c. sports d. math, science, and engineering

b

The language PHP (PHP: Hypertext Preprocessor) is used to do which of the following? Select one: a. to load the same navigation bar or boilerplate text on every page b. to write the code on the server that tells it what to do c. to execute complex activities on a website d. to function as both a text editor and a preview application

b

The most common data types are numeric and _____. Select one: a. analytical b. alphanumeric c. field

b

The programming language C was developed in the early _____ for the early UNIX operating system. a. 1980s b. 1970s c. 1990s d. 1960s

b

The time during which a database system isn't available is known as a. response time. b. downtime. c. overtime. d. sleep mode.

b

To display only a list of customers with last names that start with the letter B, you should apply a(n) _____. Select one: a. batch filter b. data filter c. interface screen

b

When data processing occurs at a scheduled time, the type of processing is called _____. Select one: a. coordinated processing b. batch processing c. transactional processing

b

Which is the preferred programming language for developing Apple applications? a. JavaScript b. Objective-C c. Java d. HTML

b

Which of the following are first-generation programming languages? a. C++ and Java b. machine languages c. assembly languages d. text-based languages

b

Which of the following converts general Java instructions into commands that a device or computer can understand? a. Perl b. Java virtual machine (JVM) c. JavaScript d. Swift

b

Which of the following involves using advanced computing to find patterns and relationships in large sets of data to apply an organizing structure and extract information? Select one: a. data browsing b. data mining c. data structuring d. data visualization

b

Which of the following languages is not used to write the code on the server that tells it what to do? Select one: a. APS.NET b. cascading style sheets (CSS) c. PHP (PHP: Hypertext Preprocessor) d. JavaServer Pages (JSP)

b

Which of the following statements does not describe pseudocode? a. It's a formally styled natural language, not a programming language. b. It involves envisioning a project in its entirety to identify the larger elements that must be handled first. c. It's used to write algorithms. d. It's a useful tool for organizing the way a programmer thinks about a solution.

b

_____ involves using advanced computing to find patterns and relationships in large sets of data in order to apply an organizing structure and extract information. a. Advanced statistics b. Data mining c. Analytics d. Model validation

b

_____ is a simple interpreted scripting language that's used for very basic operations on the server, such as loading the same navigation bar or boilerplate text on every page. Select one: a. Extensible HTML (XHTML) b. Server-side include (SSI) c. Extensible Markup Language (XML) d. Cascading style sheets (CSS)

b

A software program that's ready for testing outside the development group.

beta version

A _____ interface makes it possible for users to easily enter data and request information, and it should also prevent users from entering erroneous data. a. frontline b. back-end c. front-end d. backline

c

A program that contains a(n) _____ statement, or point where different actions may be performed depending on specific conditions, will be more useful than one that simply follows a linear sequence of actions without variation. Select one: a. variable b. loop c. decision d. executable

c

A retail store's inventory-tracking system is typically classified as a(n) _____. Select one: a. data warehouse b. real-time database c. operational database

c

A(n) _____ stores data gathered from one or more databases, functioning as a vast storage place for information that can later be used in a variety of ways. a. distributed database b. operational database c. data warehouse d. data mine

c

An error in a database system can cause _____, which involves the spread of incorrect information and can have serious consequences. a. data normalization b. data validation c. data contamination d. data redundancy

c

If you enter the search criteria smartphone NOT iPhone, what would the search engine display? Select one: a. web pages that do not contain the term smartphone b. web pages that contain the term iPhone c. web pages that contain the term smartphone but not iPhone d. web pages that contain the term iPhone but not smartphone

c

In a relational database model, a field is called a(n) Select one: a. object. b. entity. c. attribute. d. tuple.

c

In addition to discovering meaningful patterns in data, _____ includes communicating insights about data, such as the spending behavior of a group of customers. a. model validation b. data mining c. analytics d. data visualization

c

One of the benefits of programing in HTML5 is that it uses _____ tags, which are tags whose names reflect their usage. Select one: a. object-oriented b. dynamic c. semantic d. extensible

c

Rather than develop in-house analytics expertise, a company might use a(n) _____ provider and buy analysis tools and information. a. Analytics as a Service (AaaS) b. Data Analysis as a Service (DAaaS) c. Big Data as a Service (BDaaS) d. Hardware as a Service (HaaS)

c

The body of metadata for the entire database is collected by the _____. a. database query system b. data browser c. data dictionary

c

The individual that handles the day-to-day operations of a database is called the _____. Select one: a. data entry operator b. data recorder c. database administrator

c

Web pages are usually built with a combination of markup languages, such as Hypertext Markup Language (HTML), and _____ languages, such as JavaScript. a. assembly b. machine code c. scripting d. applet

c

Which of the following became the official standard for HTML in March 2018 and is supported by the latest versions of all major browsers? Select one: a. XHTML b. XML c. HTML5 d. HTML 4

c

Which of the following legacy programming languages is used chiefly for business applications by large institutions and companies? a. BASIC b. FORTRAN c. COBOL d. RPG

c

Which of the following methods can help reveal patterns and transitions that may be hard to see when reviewing numeric data alone? Select one: a. data mining b. analytics c. data visualization d. data browsing

c

Which of the following statements does not describe an object-oriented database? a. Each object contains the data related to the object. b. Each object contains the actions to be performed on the object. Incorrect c. Data is structured in multiple dimensions. d. Data is stored in the form of objects.

c

_____ is the same as C but has added features, such as object-oriented programming. a. Visual Basic (VB) b. Java c. C++ d. BASIC

c

_____ represents an emerging branch of information technology that deals with transforming large amounts of unstructured data into useful information using new methods. Select one: a. Strong analytics b. Data mining c. Big data

c

Refers to the capability of a program to run on more than one operating system.

cross-platform compatibility

A scripting language is a _____ language, meaning that it explains what the computer should do in English-like terms but not precisely how the computer should do it. a. markup b. legacy programming c. assembly d. nonprocedural

d

A(n) _____ types and changes data as needed to ensure that the contents of the database remain as up to date as possible. a. account representative b. customer c. database analyst d. data entry operator

d

Adobe's Dreamweaver, which is installed on a local PC, is an example of a(n) _____ application of web creation software. a. extensible b. online c. security Incorrect d. offline

d

An alphanumeric check allows only _____ to be entered. a. credit card numbers b. numeric data such as birth dates c. symbols such as dollar signs Incorrect d. letters of the alphabet and digits

d

Assembly language uses symbols and words to represent the elements of _____, making it possible for programmers to memorize them. a. engineering programming b. high level programming language c numbers d. machine codes

d

By 2016, how many states had implemented NEDSS? Select one: a. 39 b. 46 c. 12 d. 50

d

Small applications that can run on all types of computer operating systems are called a. functions. b. scripts. c. compilers. d. applets.

d

The availability of free, open source, public-domain _____ has spurred the trend of DIY data collection, analysis, and visualization. Select one: a. data filters b. metadata c. field names d. datasets

d

When multiple users attempt to edit an existing record simultaneously, which of the following features prevents changes from being written to the database? a. remote access b. data corruption c. data integrity d. record locking

d

Which of the following is a popular query language that enables users to request information from a database? a. Database Query Language (DBL) b. Database Field Query Language (DFQL) c. SELECT Query Language (SQL) Incorrect d. Structured Query Language (SQL)

d

Which would be classified as a third-generation programming language (3GL)? a. Prolog b. SQL c. assembly language d. Java

d

_____ involves not only discovering meaningful patterns in data but also communicating insights about data and using data to make informed business decisions. a. Advanced statistics b. Metrics c. Data graphics d. Analytics

d

_____ is a high-level language that's friendlier and more natural than COBOL and FORTRAN. Select one: a. C b. C++ c. C# d. BASIC

d

_____ is one of the most popular tools for developing responsive, mobile-first websites. Select one: a. Dreamweaver b. Drupal c. Joomla d. Bootstrap

d

_____ means creating a small, semifunctional version of the solution to see if and how it works. Select one: a. Implementing b. Brainstorming c. Pseudocoding d. Prototyping

d

Occurs when data is unreadable, incomplete, or damaged

data corruption

Stores data gathered from one or more databases

data warehouse

If programmers develop software by tackling one small piece of the puzzle at a time, they are taking a(n)

divide & conquer

A single value, such as a name

field

A traditional data file storage system that contains only one data table or file.

flat file storage

A ______provides a visual diagram of an algorithm and is sometimes used instead of pseudocode.

flowchart

A screen or dialog box used to enter data in a database

form

In Microsoft Office, you can automate a frequently performed task by recording a

macro

Describes the structure, specifications, and purpose of each element in a database.

metadata

A step-by-step description of how a program should operate, using ordinary language (not a specific programming language).

pseudocode

Used to display a list of records that match specified criteria.

query

The type of database in which fields with similar data can be connected between data tables in the database

relational database

Presents output from a data table or query.

report

A program that has not yet been compiled is also referred to as ___ code

source

A type of error in a program caused by a typographical error.

syntax

How many parameters does the for statement have?

three

A programming language developed by Microsoft that many schools teach as a first introduction to programming.

visual basic

Takes place when the database administrator uses the most recent backup to restore data.

Recovery

A programming language that is similar to machine language but uses text-based commands.

Assembly language