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