Computer Science Final

The ________ is the smallest unit of data the computer can store in a database.

Bit

Bell Laboratories developed this general-purpose third-generation language that works well for mid-range computers and is portable among many computers. The Unix operating system was the first major program written in this language.

C

early high-level languages (third generation) was used for large computers in business applications and is still used today in legacy systems?

COBOL

Supercomputer

Computer for highly complex mathematical models

What are programs that help a database to be maintained, by creating, editing, and deleting data, records, and files?

DBMS utilities

Locating and removing all errors from a computer program is called ________.

Debugging

A description of the program, its purpose and how to use it, is known as ________.

Documentation

Platform

Examples are the PC and the Macintosh

Data mining is the process of removing errors and inconsistencies from data. t or f

False

E-readers are useful as multipurpose devices, and tablets are better for reading. t or f

False

first high-level language (third generation) and was used for mathematical formulas

Fortran

________ TV uses a digital signal, or series of 0s and 1s, and is much clearer and less prone to interference than analog TV.

High-definition (HD)

he four main functions of a computer are:

Input, processing, output, and storage.

Cable

Is sometimes subject to packet collisions.

ROM

Memory chip used in the BIOS

Data

Raw material that is processed by the computer

DSL

Requires the user to be near the Central office

What is the actual step-by-step process followed during systems analysis and design?

SDLC

Which of the following is NOT an example of a download? Putting pictures from the Internet on your hard drive Storing a map for your vacation from the Internet on your smartphone Saving a paper you just wrote to a CD Saving a program from an Internet site to your hard drive

Saving a paper you just wrote to a CD

A byte of data is the same as a character.

True

In a relational database, there are no access paths down through a particular hierarchy. t or f

True

In the make-or-buy decision, the systems analyst decides whether to have a program custom written or to purchase an existing software package. T or F

True

Key fields are necessary so that records can be identified, retrieved and processed. T or False

True

Smartphones are an example of digital convergence. T or F

True

Structured query language (SQL) is the standard query language used to create, modify, maintain, and query relational databases. t or f

True

The database administrator coordinates all related activities and needs for an organization's database. T or F

True

The principle tablet operating systems are Apple's iOS, Google's Android, and Microsoft Windows RT. t or f

True

The relational database model is more flexible than the hierarchical and the network database models. t or f

True

Too much multitasking can result in "absent presence." t or f

True

FIOS

Uses a thin glass fiber cable

What interconnected system of computers all over the world supports specially formatted documents in multimedia form?

World Wide Web

A(n) ________ is a formula or set of steps for solving a particular problem.

algorithm

Digital convergence combines several industries, including: -computers and communications -consumer electronics -entertainment and mass media -all of these

all of these

Machine language—0s and 1s—would be very difficult for a programmer to write in; thus a low-level (second-generation) language, ________ can be used to write a program with abbreviations and basic words, instead of numbers.

assembly language

If you were emailing a term paper and wanted to maintain its formatting, you would send it as a(n) ________.

attachment

An expression for how much data can be sent through a communications channel in a given amount of time is referred to as ________.

bandwidth

The process of loading an operating system into a computer's memory is called __________.

booting

A field is a unit of data consisting of one or more ________.

characters

What is the first thing a programmer should consider when defining a problem?

clarify program objectives and users

Which of these is the first step in programming?

clarify/define the problem

In a database management system, the ________ is a document or file that stores the data definitions and descriptions of the structure of data used in the database.

data dictionary

The person who coordinates all activities and needs for an organization's database is the ________.

database administrator

What is the software that controls the structure of a database and access to the data?

database management system

A digital point-and-shoot camera produces images of better quality than those produced by an SLR digital camera. t or f

false

A five-step procedure for creating a list of instructions for the computer is called programming. T or F

false

Being able to write computer programs is a necessary characteristic of computer fluency.

false

Satellite radio combines digital and analog broadcast signals, enabling stations to offer an analog main channel and digital "sidebands" so that multiple types of content can be broadcast from the same position on the dial. t or f

false

The highest level of programming languages is machine language, because it is the language that the computer itself uses. t or f

false

The number of megapixels a digital camera has is the only factor affecting photographic quality. t or f

false

Videogame consoles use the same CPUs and operating systems as desktop computers. t or f

false

WAN is a wireless connection standard t or f

false

A record (row) is a collection of related ________.

fields

Digital music players, such as the iPod, use one or both of the following file storage technologies: ________ and ________.

hard-disk drive; flash memory

________ is a tablet PC.

iPad

Data that has been summarized or otherwise manipulated for use in decision making is called ________.

information

The ________ uniquely identifies a record.

key field

Slower than a supercomputer, but still able to process millions of instructions per second, these computers are often access by means of a terminal and are sometimes called "midsize" computers.

mainframe computers

A digital camera's resolution is expressed in ________.

megapixels

What describes contents of a data warehouse?

metadata

The category of operating system that you most likely have running on your desktop or laptop computer at home is a ________ operating system.

multi task

A communications system connecting two or more computers is called a(n) ________.

network

In Phase 5 of the SDLC, if parts of the new system are introduced at different times, this is what type of system conversion plan?

phased implementation

A camera, either film or digital, that automatically adjusts settings such as exposure and focus is a ________ camera.

point-and-shoot

A ________ is a list of instructions that the computer must follow to process data into information.

program

A limited working system, or part of one, developed to test design concepts is a ________.

prototype

A narrative that uses normal human-language statements to describe the logic and processing flow of a program is called ________.

pseudocode

Which of these is NOT an example of relational database terminology? -tuples -attributes -qualities -relations

qualities

A fourth-generation language used to retrieve data from a database management system is called a(n)

query language

A file (table) is a collection of related ________.

records

Which type of database model connects data in different files through the use of a key field?

relational database

There are five basic computer sizes, generally classified according to their processing power. Which of these is NOT a computer size designation? workstation server robot microcontroller

robot

Bluetooth

s a form of short range communication

The Apple iPhone is a cellphone with a microprocessor, display screen, memory, and built-in modem. Thus it is a ________.

smartphone

An information specialist who performs systems analysis, design, and implementation is a(n) ________.

systems analyst

The systems analyst acquires the software, hardware, and then tests the system during the ________ phase of the SDLC.

systems development

A user interface is the display screen in an expert system that the user interacts with. T or F

true

Both machine language and assembly language are machine dependent. t or f

true

Desk-checking, debugging code, and using real-world data to make sure the program works are all part of program testing. This is called beta testing. t or f

true

Expert systems, fuzzy logic, and robotics are some of the main areas of artificial intelligence. t or f

true

High-definition TV has a higher resolution and uses a wider screen than standard-definition TV and uses much more bandwidth. t or f

true

If a company stops using the old system all at once and then starts using the new system, this is called direct implementation. T or F

true

If the old and new systems are operated side by side until the new system has proven itself, this type of system conversion plan is parallel implementation. T or F

true

Keeping a program in working condition, error-free, and up to date is called maintenance. t or f

true

People in the United States who still have analog TVs now must use a converter box to receive digital TV (DTV) signals, because TV broadcasters have switched from analog to digital. t or f

true

Real-world test data used to test a program should never include bad data. t or f

true

Some programs like "Open Office" are available for the Windows, LINUX and MAC operating systems

true

The SDLC is the step-by-step process of systems analysis and design T or F

true

The basic language of the computer is known as machine language and represents data as 0s and 1s. t or f

true

The driving directions to your friend's house are an algorithm. t or f

true

The first step in programming is to have a clear understanding of the problem. t or f

true

The term "nano" means one-billionth. t or f

true

UNIX

An Operating System used for Servers

Dial-Up

Approaches speeds of 56 KBS