CISC1000 Information Technology Fundamentals and Practices

簡介

Information Technology Fundamentals and Practices。

CISC1000 is a foundational course in Language and Skills that explores the impact of information technology in our modern society. CISC1000 is an online course that is accessible at UMMoodle. Students may access the course at any time and find out all resources related to the course online, including course materials, video lectures and exercises. A face-to-face Q&A tutorial hour is arranged for students every week. If any of your enrolled courses has schedule conflict with the tutorial hour of your CISC1000 section, please send an email to fst.cisc1000 and seek FST’s advice and/or approval to change your tutorial hour to other time slot.

所有同學都必須Pass的電腦基礎知識課。

有多次考試機會，需要先報名再考試。

學習攻略

複習題庫，聽天由命。

題庫 - 更新於2018年9月27日

Key:所有Q1題都不需要溫的，希望大家考試順利。（學姐留下的🫡🫡）

Topic 01

Q1

Question	Answer
Type of computer that is small enough to fit on top of or alongside a desk yet is too big to carry around.	Desktop
A type of a file that might contain, for example, audience handouts, speaker notes, and electronic slides.	Presentation
Devices that translate the processed information from the computer into a form that humans can understand.	Output
Enables the application software to interact with the computer hardware.	System software
Unlike hard disks, this type of storage does not have any moving parts, is more reliable, and requires less power.	Solid-state
Another name for a program.	Software
Consists of the step-by-step instructions that tell the computer how to do its work.	Program
A communications system connecting two or more computers.	Network

Q2

The keyboard, mouse, display, and system unit are:

a. software

b. hardware

c. storage devices

d. output devices

Ans: hardware

Q3

Programs that coordinate computer resources, provide an interface, and run applications are known as:

a. application programs

b. operating systems

c. utility programs

d. storage systems

Ans: operating systems

Q4

A browser is an example of a:

a. general-purpose application

b. specialized program

c. utility program

d. system application

Ans: general-purpose application

Q5

Although not as powerful as a supercomputer, this type of computer is capable of great processing speeds and data storage.

a. mainframe

b. laptop

c. tablet

d. midrange

Ans: mainframe

Q6

Apple’s Watch is what type of computer?

a. tablet

b. wearable

c. laptop

d. smartphone

Ans: wearable

Q7

RAM is a type of:

a. computer

b. secondary storage

c. network

d. memory

Ans: memory

Q8

Unlike memory, this type of storage holds data and programs even after electric power to the computer system has been turned off.

a. secondary

b. RAM

c. primary

d. ROM

Ans: secondary

Q9

The type of file created by word processors, for example, memos, term papers, and letters.

a. database

b. worksheet

c. document

d. presentation

Ans: document

Q10

Uses the Internet and the web to shift many computer activities from a user’s computer to computers on the Internet.

a. solid-state storage

b. high definition

c. network

d. cloud computing

Ans: cloud computing

Q11

The largest network in the world is [the]:

a. Internet

b. Facebook

c. web

d. supercomputer

Ans: Internet

Topic 02

Q1

The most common way to access the Internet is through a 👎	ISP
Electronic commerce involving individuals selling to individuals.	C2C
Two popular instant messaging services are Google Talk and Facebook _____.	Chat
The basic components of cloud computing are clients, service providers, and the _____.	Internet
A business-oriented social networking site.	LinkedIn
Transmission of electronic messages over the Internet.	E-mail
Maintain huge databases relating to information provided on the web and the Internet.	Search services
Another name for a blog.	Web log
Publishes short sentences that take only a few seconds to write.	Microblog
The most popular Internet activity.	Communicating

Q2

The network that connects computers all over the world.

a. Internet

b. ARPANET

c. LAN

d. web

Ans: Internet

Q3

The rules for exchanging data between computers.

a. DSL

b. WWW

c. protocols

d. web

Ans: protocols

Q4

Using file transfer utility software, you can copy files to your computer from specially configured servers on the Internet. This is called:

a. downloading

b. blogging

c. uploading

d. filtering

Ans: downloading

Q5

Communities of individuals who share a common interest typically create Facebook:

a. Pages

b. clients

c. groups

d. Profiles

Ans: groups

Q6

Type of email account that does not require an email program to be installed on a user’s computer is:

a. blog-based

b. web-based

c. client-based

d. utility-based

Ans: web-based

Q7

The most popular microblogging site:

a. Google+

b. LinkedIn

c. Twitter

d. Wikipedia

Ans: Twitter

Q8

Using a keyword, a search engine returns a list of related sites known as:

a. blogs

b. podcasts

c. hits

d. strikes

Ans: hits

Q9

This is the Internet’s equivalent to traditional cash.

a. e-commerce

b. Internet dollars

c. ftp

d. digital cash

Ans: digital cash

Q10

The continuing Internet development that allows objects to send and receive data over the Internet.

a. IoT

b. search engines

c. Web 2.0

d. HTML

Ans: IoT

Q11

Three basic components to cloud computing are clients, Internet, and _____.

a. CSS

b. streaming

c. service providers

d. Web 3.0

Ans: service providers

Topic 03

Q1

Used by scammers to trick Internet users with official-looking websites.	Phishing
Wide range of programs that secretly record and report an individual’s activities on the Internet.	Spyware
Malicious programs that damage or disrupt a computer system.	Malware
Privacy concern that relates to the responsibility to ensure correct data collection.	Accuracy
A type of scanning device such as fingerprint and iris (eye) scanner.	Biometric
Individuals who collect and sell personal data.	Information brokers
Infected computers that can be remotely controlled.	Zombies
Small data files deposited on your hard disk from websites you have visited.	Cookies
An ethical issue relating to using another person’s work and ideas as your own without giving credit to the original source.	Plagiarism
Process of coding information to make it unreadable except to those who have a key.	Encryption

Q2

The three primary privacy issues are accuracy, property, and:

a. ownership

b. security

c. ethics

d. access

Ans: access

Q3

Highly detailed and personalized descriptions of individuals are electronic:

a. profiles

b. cookies

c. histories

d. web bugs

Ans: profiles

Q4

Browsers store the locations of sites visited in a:

a. firewall

b. history file

c. menu

d. tool bar

Ans: history file

Q5

The browser mode that ensures your browsing activity is not recorded.

a. sleep

b. detect

c. insert

d. privacy

Ans: privacy

Q6

The information that people voluntarily post in social networking sites, blogs, and photo- and video-sharing sites is used to create their:

a. online identity

b. firewall

c. access approval

d. phish

Ans: online identity

Q7

Computer criminals who create and distribute malicious programs.

a. crackers

b. antispies

c. cyber traders

d. identity thieves

Ans: crackers

Q8

Programs that come into a computer system disguised as something else are called:

a. zombies

b. viruses

c. web bugs

d. Trojan horses

Ans: Trojan horses

Q9

The use of the Internet, cell phones, or other devices to send or post content intended to hurt or embarrass another person is known as:

a. cyberbullying

b. unethical communication

c. online harassment

d. social networking discrimination

Ans: cyberbullying

Q10

Special hardware and software used to control access to a corporation’s private network is known as a(an):

a. spyware removal program

b. antivirus program

c. firewall

d. communication gate

Ans: firewall

Q11

To prevent copyright violations, corporations often use:

a. ACT

b. WPA2

c. DRM

d. VPN

Ans: DRM

Topic 04

Q1

In an information system, the rules or guidelines for people to follow are called _______.	procedures
The component of the information system that is described as raw, unprocessed facts, including text, numbers, images, and sounds, is called _______.	data
Application software can be categorized as either general-purpose, specialized, or _______ apps.	mobile
The five types of personal computers are: desktops, laptops, tablets, smartphones, and _____ .	wearables
Increased use of mobile or wireless communication devices and cloud computing has been termed "the _______  revolution."	wireless

Q2

Which part of an information system consists of the rules or guidelines for people to follow?

a. Procedures

b. Internet

c. People

d. Data

Ans: Procedures

Q3

The equipment that processes data in order to create information is called the _______.

a. hardware

b. typology

c. software

d. compiler

Ans: hardware

Q4

In most cases, the word "software" is interchangeable with the word _______.

a. computer

b. application

c. procedure

d. program

Ans: program

Q5

Which of the following is a collection of programs rather than a single program?

a. System software

b. Microsoft Access

c. Procedures

d. Hardware

Ans: System software

Q6

Identify the program that coordinates computer resources, provides an interface between users and the computer, and runs applications.

a. System software

b. Operating system

c. Device driver

d. Application software

Ans: Operating system

Q7

Antivirus programs protect your computer system from viruses or malicious programs. This is an example of which type of software?

a. Operating system

b. Utilities

c. Browser software

d. Application software

Ans: Utilities

Q8

Which of the following computers is also referred to as a server and is used to support end users for things such as retrieving data from a database or providing access to application software?

a. Mainframe

b. Microcomputer

c. Supercomputer

d. Midrange

Ans: Midrange

Q9

Desktop, laptop, and tablet computers, and mobile devices are classified as _______.

a. mainframe computers

b. supercomputers

c. personal computers

d. midrange computers

Ans: personal computers

Q10

The most widely used handheld computers are _______.

a. smartphones

b. notebooks and laptops

c. laptops

d. tablets

Ans: smartphones

Q11

A microcomputer that is smaller, lighter, and less powerful than a notebook, and that has a touch sensitive screen, is called a _______.

a. desktop

b. laptop

c. tablet

d. subnotebook

Ans: tablet

Q12

This computer component holds the program and data that is currently being processed.

a. RAM

b. Ports

c. ROM

d. Bus

Ans: RAM

Q13

Which of the following will not retain data after the computer is turned off?

a. RAM

b. ROM

c. DVD

d. Hard drive

Ans: RAM

Q14

Identify the four basic categories of hardware in a personal computer system.

a. Hard disk, input/output, secondary storage, and display devices

b. System unit, input/output, secondary storage, and primary storage

c. System unit, input/output, secondary storage, and communication

d. System unit, modem, RAM, and microprocessor

Ans: System unit, input/output, secondary storage, and communication

Q15

A financial budget would be created in what type of data file?

a. Database

b. Document

c. Presentation

d. Worksheet

Ans: Worksheet

Q16

Employee records, including names, social security numbers, and related information, would typically be stored in what type of data file?

a. Worksheet

b. Presentation

c. Database

d. Document

Ans: Database

Topic 05

Q1

A type of suite that is stored at a server on the Internet and is available anywhere you can access the Internet.	Cloud
A general-purpose program that creates text-based documents.	Word processor
Toolbars typically appear below the menu bar and include small graphic elements called _____.	Buttons
A collection of related data.	Database
A type of specialized suite that includes a variety of programs designed to make computing easier and safer.	Utility
Image editors create images made up of thousands of dots known as _____.	Pixels
Program that organizes, analyzes, and graphs numerical data.	Spreadsheet
Also known as a photo editor, this specialized graphics program edits or modifies digital photographs.	Image editor
Simplifies the process of making a selection from a list of alternatives by graphically displaying the effect of alternatives before being selected.	Galleries
A website that provides access to specific mobile apps is known as an app _____.	Store

Q2

This type of software works with end users, application software, and computer hardware to handle the majority of technical details.

a. specialized

b. system

c. utility

d. application

Ans: system

Q3

A rectangular area that can contain a document, program, or message.

a. frame

b. dialog box

c. window

d. form

Ans: window

Q4

Programs that create text-based documents.

a. suites

b. word processors

c. spreadsheets

d. DBMS

Ans: word processors

Q5

Programs that organize, analyze, and graph numerical data such as budgets and financial reports.

a. suites

b. word processors

c. DBMS

d. spreadsheets

Ans: spreadsheets

Q6

Program that allows you to mix text and graphics to create publications of professional quality.

a. database

b. desktop publishing

c. productivity

d. presentation

Ans: desktop publishing

Q7

The type of image that consists of geometric shapes.

a. bitmap

b. ribbon

c. vector

d. raster

Ans: vector

Q8

An online diary or commentary.

a. blog

b. HTML

c. bitmap

d. vector

Ans: blog

Q9

Programs that combine a variety of visual objects to create attractive, visually interesting presentations.

a. DBMS

b. presentation graphics

c. word processor

d. spreadsheet

Ans: presentation graphics

Q10

Programs typically used to create sophisticated commercial websites.

a. web authoring programs

b. video editors

c. illustration programs

d. game design programs

Ans: web authoring programs

Q11

Also known as an online suite.

a. office

b. utility

c. cloud

d. integrated

Ans: cloud

Topic 06

Q1

Restarting a running computer without turning off the power.	Warm boot
If a file cannot be saved on a single track, it has to be _______.	Fragmented
A type of software that allows a single physical computer to operate as though it were two or more separate and independent computers.	Virtualization
Type of operating system that controls and coordinates networked computers.	NOS
Type of program that guards computer systems from viruses and other damaging programs.	Antivirus
Program that works with the operating system to allow communication between a device and the rest of a computer system is called a device _______.	Driver
Programs that perform specific tasks related to managing computer resources.	Utilities
Switching between different applications.	Multitasking
An operating system is often referred to as the software environment or software _______.	Platform
Mobile operating system that is owned by Google and is widely used in many smartphones.	Android

Q2

BitDefender, Kaspersky, and Norton are examples of:

a. utility suites

b. apps

c. operating systems

d. application packages

Ans: utility suites

Q3

What type of software works with users, application software, and computer hardware to handle the majority of technical details?

a. system

b. desktop

c. application

d. Linux

Ans: system

Q4

The programs that convert programming instructions written by programmers into a language that computers understand and process are language:

a. linguists

b. converters

c. translators

d. managers

Ans: translators

Q5

The ability to switch between different applications stored in memory is called:

a. multitasking

b. operational interference

c. diversion

d. programming

Ans: multitasking

Q6

Graphic representation for a program, type of file, or function:

a. app

b. image

c. software

d. icon

Ans: icon

Q7

This operating system feature is controlled by a mouse and changes shape depending on its current function.

a. pointer

b. dialog box

c. mouse

d. menu

Ans: pointer

Q8

The operating system based on Linux, designed for notebook computers that use cloud computing and cloud storage:

a. UNIX

b. Chrome

c. Mac

d. Windows

Ans: Chrome

Q9

The mobile operating system developed by Apple and originally called iPhone OS:

a. iOS

b. Phone OS

c. Android

d. Mac OS

Ans: iOS

Q10

A utility program that copies all files in the libraries, contacts, favorites, and on the desktop:

a. Compactor

b. File History

c. Disk Cleanup

d. Optimize Drives

Ans: File History

Q11

A troubleshooting utility that identifies and eliminates nonessential files, frees up valuable disk space, and improves system performance:

a. File History

b. Disk Cleanup

c. Compactor

d. Optimize Drives

Ans: Disk Cleanup

Topic 07

Q1

MIS produces this type of report.	Standardized
A type of report that calls attention to unusual events.	Exception
The accounting activity concerned with calculating employee paychecks.	Payroll
Type of worker who is involved with the distribution and communication of information.	Data
Computer-based information system that uses data from TPS to support middle-level managers.	MIS
Computer system that allows people located at various geographic locations to communicate and have in-person meetings.	Videoconferencing
Type of software that works behind the scenes to handle detailed operating procedures.	System
The accounting activity that records the customer requests for the company’s products or services is sales order _____.	Processing
Function that plans, prices, promotes, sells, and distributes the organization’s goods and services.	Marketing
Managerial level where information flow is vertical and horizontal.	Middle

Q2

Which of the basic organizational functions records all financial activity from billing customers to paying employees?

a. accounting

b. production

c. marketing

d. research

Ans: accounting

Q3

What managerial level has information flow that is vertical, horizontal, and external?

a. foreman

b. middle

c. supervisory

d. top

Ans: top

Q4

Which computer-based information system uses data from TPS and analytical tools to support middle managers?

a. MIS

b. ESS

c. TPS

d. DSS

Ans: DSS

Q5

Accounts payable refers to money the company owes its suppliers for materials and services it has:

a. inventoried

b. created

c. received

d. exported

Ans: received

Q6

What accounting activity keeps track of all summaries of all transactions?

a. inventory control

b. income statement

c. balance sheet

d. general ledger

Ans: general ledger

Q7

What accounting statement lists the overall financial condition of an organization?

a. general ledger

b. inventory control

c. income statement

d. balance sheet

Ans: balance sheet

Q8

What type of report is produced at regular intervals?

a. exception

b. periodic

c. demand

d. inventory

Ans: periodic

Q9

A DSS consists of four parts: user, system software, decision models, and:

a. data

b. application software

c. spreadsheets

d. operating system

Ans: data

Q10

What type of worker is involved with the distribution, communication, and creation of information?

a. information

b. foreman

c. executive

d. knowledge

Ans: information

Q11

What type of program is designed to schedule, plan, and control project resources?

a. dtp

b. auditing

c. schedulers

d. project managers

Ans: project managers

Topic 08

Q1

The last and ongoing phase of the systems life cycle is systems _____.	Maintenance
The approach in which the new system is implemented gradually over a period of time.	Phased
Systems analysis and design is a six-phase problem solving procedure for examining and improving an information _____.	System
Systems life cycle phase that studies the present system in depth.	Analysis
The four approaches to conversion are parallel, pilot, phased, and _____.	Direct
The phase in which the old system is replaced and training begins.	Implementation
This phase begins with designing alternative systems.	Systems design
Another name for systems implementation.	Conversion
The document that shows the levels of management and formal lines of authority is an _____.	Organization chart
Systems analysis involves suggesting alternative _____.	Solutions

Q2

An information system is a collection of hardware, software, people, procedures, the Internet, and:

a. systems analysts

b. data

c. DBMS

d. specialists

Ans: data

Q3

What is the first phase in the systems life cycle?

a. preliminary investigation

b. systems analysis

c. systems design

d. needs analysis

Ans: preliminary investigation

Q4

Which phase involves installing the new system and training people?

a. systems analysis

b. preliminary investigation

c. systems design

d. systems implementation

Ans: systems implementation

Q5

This phase is concerned about determining system requirements not in design.

a. systems analysis

b. systems design

c. systems implementation

d. preliminary investigation

Ans: systems analysis

Q6

Which systems analysis tool shows the relationship between input and output documents?

a. automated design tool

b. grid chart

c. data flow diagram

d. system flow chart

Ans: grid chart

Q7

These tools relieve the systems analysts of many repetitive tasks, develop clear documentation, and, for larger projects, coordinate team member activities.

a. automated systems life cycle

b. CASE

c. data flow analyzers

d. flowcharts

Ans: CASE

Q8

Which phase is concerned with economic, technical, and operational feasibility?

a. systems design

b. systems analysis

c. preliminary investigation

d. systems implementation

Ans: systems design

Q9

What type of feasibility evaluates whether the people within the organization will embrace or resist a new system?

a. operational

b. technical

c. behavioral

d. economic

Ans: operational

Q10

Which approach to conversion begins by trying out a new system in only one part of an organization?

a. pilot

b. phased

c. parallel

d. direct

Ans: pilot

Q11

An alternative to the systems life cycle approach using powerful development software, small specialized teams, and highly trained personnel.

a. AAD

b. CASE

c. RAD

d. prototyping

Ans: RAD

Topic 09 -1

Q1

System board component that provides a connection point for specialized cards or circuit boards.	Slots
A type of multiprocessor chip that provides two or more separate and independent CPUs.	Multicore
This bus connects the CPU to memory on the system board.	System
A socket for external devices to connect to the system unit.	Port
This port can be used to connect many USB devices to the system.	USB
A type of memory that is volatile or loses its contents when power is turned off.	Flash
Provide connection points for chips.	Sockets
Another name for a network adapter card.	NIC
A type of memory that improves processing by acting as a temporary high-speed holding area between the memory and the CPU	Cache
A type of memory that provides a combination of features of RAM and ROM.	Flash

Q2

This container houses most of the electrical components for a computer system.

a. system board

b. chip carrier

c. system unit

d. Unicode

Ans: system unit

Q3

The most popular mobile device.

a. ultrabook

b. smartphone

c. all-in-one

d. desktop

Ans: smartphone

Q4

The mainboard or motherboard is also known as the:

a. mobile system

b. computer

c. system board

d. board processor

Ans: system board

Q5

How many bytes can a 32-bit-word computer access at one time?

a. 16

b. 4

c. 8

d. 1

Ans: 4

Q6

In a personal computer system, the central processing unit is typically contained on a single:

a. chip

b. RAM

c. bus

d. module

Ans: chip

Q7

This type of memory divides large programs into parts and stores the parts on a secondary storage device.

a. direct

b. random-access

c. virtual

d. expanded

Ans: virtual

Q8

Also known as NIC, this adapter card is used to connect a computer to a(an):

a. expansion

b. graphics

c. AIA

d. network

Ans: network

Q9

This provides a pathway to connect parts of the CPU to each other.

a. bus

b. cable

c. wireless

d. wired

Ans: bus

Q10

The specialized port that connects musical instruments like an electronic keyboard to a sound card.

a. MIDI

b. Thunderbolt

c. eSATA

d. HDMI

Ans: MIDI

Q11

Computers can only recognize this type of electronic signal.

a. bus

b. digital

c. analog

d. maximum

Ans: digital

Q12

Which one of the following coding systems can be used to represent the Thai language?

a. EBCDIC

b. Unicode

c. CJK

d. ASCII

Ans: Unicode

Q13

One gigabyte is approximately equal to

a. one million bytes

b. one thousand bytes

c. one billion bytes

d. one trillion bytes

Ans: one billion bytes

Topic 09 -2

Q1

Input device that controls a pointer that is displayed on the monitor.	Mouse
Records images digitally on a memory card or in its memory.	Digital camera
A monitor feature that is measured by the diagonal length of the viewing area.	Active display area
Bar code readers use either handheld wand readers or platform _____.	Scanners
Special-purpose printers for creating maps, images, and architectural and engineering drawings.	Plotters
A provider of lower-cost options for telephony	Skybe
Bar code system used by many electronic cash registers.	UPC
A pen like device commonly used with tablet PCs and PDAs.	Stylus
Pressing this key turns a feature on or off	Toggle key
The distance between each pixel.	Dot pitch

Q2

Most keyboards use an arrangement of keys known as:

a. OptiKey

b. QWERTY

c. Alpha

d. Daisy

Ans: QWERTY

Q3

The device that controls a pointer displayed on the monitor.

a. printer

b. cord

c. mouse

d. scanner

Ans: mouse

Q4

The type of screen that can be touched with more than one finger and supports zooming in and out by pinching and stretching your fingers.

a. OLED

b. multitouch

c. digital

d. dynamic

Ans: multitouch

Q5

Flatbed and document are types of:

a. monitors

b. scanners

c. MaxiCode

d. headsets

Ans: scanners

Q6

Device used by banks to automatically read those unusual numbers on the bottom of checks and deposit slips.

a. MICR

b. UPC

c. FDIC

d. OMR

Ans: MICR

Q7

The most widely used audio-input device.

a. RFID

b. microphone

c. mouse

d. VR

Ans: microphone

Q8

The monitor feature that indicates the ability to display colors.

a. aspect ratio

b. dot pitch

c. contrast ratio

d. resolution rate

Ans: contrast ratio

Q9

Mobile devices able to store and display electronic media.

a. HDTV

b. lasers

c. whiteboards

d. e-book readers

Ans: e-book readers

Q10

Virtual reality strives to create this type of experience.

a. VoIP

b. immersive

c. LCD

d. electronic

Ans: immersive

Q11

The study of human factors related to things people use is:

a. RFID

b. ergonomics

c. telephony

d. RSI

Ans: ergonomics

Topic 09 -3

Q1

Provides permanent or nonvolatile storage.	Secondary storage
Each track is divided into invisible wedge-shaped sections called _____ .	Sectors
Similar to internal hard-disk drives except they use solid-state memory.	Solid-state drives
Architecture to link remote storage devices to computers such that the devices are as available as locally attached drives.	Storage area network
Optical disc most common on today’s personal computers.	DVD
Hardware that reads data and programs from storage media.	Storage devices
The next generation of optical discs.	Hi def
Increases storage capacity by reducing the amount of space required to store data and programs.	File compression
Mass storage device widely used for home and small business storage.	Network attached storage
Concentric rings on a hard-disk platter.	Tracks

Q2

RAM is sometimes referred to as:

a. read-only memory

b. primary storage

c. ratio active memory

d. secondary storage

Ans: primary storage

Q3

The actual physical material that holds the data and programs.

a. primary storage

b. capacity

c. access

d. media

Ans: media

Q4

Measures how tightly the magnetic charges can be packed next to one another on the disk.

a. tracks

b. sectors

c. density

d. cylinders

Ans: density

Q5

When a read-write head makes contact with the hard disk’s surface, it causes a head:

a. scratch

b. crash

c. land

d. pit

Ans: crash

Q6

This hard-disk performance enhancement anticipates data needs.

Select one:

a. RAID

b. file compression

c. file decompression

d. disk caching

Ans: disk caching

Q7

This type of storage uses pits and lands to represent 1s and 0s.

a. optical

b. cloud

c. hard disk

d. solid state

Ans: optical

Q8

DVD stands for:

a. dynamic video disc

b. digital versatile disc

c. dynamic versatile disc

d. digital video data

Ans: digital versatile disc

Q9

USB drives are also known as:

a. universal state bus

b. flash drives

c. optical drives

d. ports

Ans: flash drives

Q10

An organizational strategy to promote efficient and safe use of data across the networks.

a. RAID

b. cloud dynamic

c. data mission statement

d. enterprise storage system

Ans: enterprise storage system

Q11

Specialized high-capacity secondary storage devices designed to meet organizational demands.

a. flash drives

b. mass storage devices

c. platters

d. CD devices

Ans: mass storage devices

Topic 10

Q1

In this network, nodes have equal authority and can act as both clients and servers.	Peer-to-peer
Uses high-frequency radio waves.	Microwave
Rules for exchanging data between computers.	Protocols
Any device that is connected to a network.	Node
A widely used Internet protocol.	TCP/IP
Signals that are continuous electronic waves.	Analog
A computer specialist responsible for efficient network operations and implementation of new networks.	Network administrator
Work with firewalls to protect an organization’s network.	Intrusion detection systems
This network, also known as a hierarchical network, is often used to share corporatewide data.	Tree
Type of network topology in which each device is connected to a common cable called a backbone.	Bus

Q2

The concept related to using computer networks to link people and resources.

a. Wi-Fi

b. connectivity

c. TCP/IP

d. GPS

Ans: connectivity

Q3

A high-frequency transmission cable that delivers television signals as well as connects computers in a network.

a. 3D

b. twisted pair

c. hi def

d. coaxial

Ans: coaxial

Q4

A short-range radio communication standard that transmits data over short distances of up to approximately 33 feet.

a. broadband

b. TCP/IP

c. DSL

d. Bluetooth

Ans: Bluetooth

Q5

The speed with which a modem transmits data is called its:

a. transfer rate

b. modular rating

c. dynamic rate

d. digital velocity

Ans: transfer rate

Q6

The bandwidth typically used for DSL, cable, and satellite connections to the Internet.

a. voiceband

b. medium band

c. broadband

d. baseband

Ans: broadband

Q7

Every computer on the Internet has a unique numeric address called a(an):

a. DNS

b. broadcast

c. IP address

d. packet

Ans: IP address

Q8

Sometimes referred to as a LAN adapter, these expansion cards connect a computer to a network.

a. VPN

b. PCMCIA

c. server

d. NIC

Ans: NIC

Q9

A device that allows one LAN to be linked to other LANs or to larger networks.

a. network gateway

b. switch

c. PAN

d. IDS

Ans: network gateway

Q10

Typically using Wi-Fi technology, these wireless access points are available from public places such as coffee shops, libraries, bookstores, colleges, and universities.

a. extranets

b. hotspots

c. LANs

d. PANs

Ans: hotspots

Q11

Bus, ring, star, tree, and mesh are five types of network:

a. strategies

b. devices

c. protocols

d. topologies

Ans: topologies

Topic 11

Q1

Programming languages that are closer to the language of humans.	Higher level
Six-step procedure also known as software development.	Programming
The process of testing and then eliminating program errors.	Debugging
An outline of the logic of the program to be written.	Pseudocode
The first-generation language consisting of 1s and 0s.	Machine
Logic structure, also known as IF-THEN-ELSE, that controls program flow based on a decision.	Selection
Converts a procedural language one statement at a time into machine code just before it is to be executed.	Interpreter
5GL that allows more direct human communication with a program.	Natural language
Program step that involves creating descriptions and procedures about a program and how to use it.	Documentation
Generation of computer languages that allows a person to provide a system with a problem and some constraints, and then request a solution.	5GL

Q2

A program is a list of instructions for the computer to follow to process:

a. hardware

b. data

c. software

d. direct logic

Ans: data

Q3

The major processing steps identified in a top-down program design are called:

a. modules

b. assembly

c. instructions

d. logic

Ans: modules

Q4

The programming logic structure in which one program statement follows another.

a. sequential

b. loop

c. selection

d. repetition

Ans: sequential

Q5

One of the best ways to code effective programs is to use the three basic logic structures to create:

a. modular languages

b. code reviews

c. pseudocode

d. structured programs

Ans: structured programs

Q6

Which step in the six-step programming procedure involves desk checking and searching for syntax and logic errors?

a. program design

b. program documentation

c. program test

d. program maintenance

Ans: program test

Q7

Which step in the six-step programming procedure is the final step?

a. program design

b. program maintenance

c. program test

d. program documentation

Ans: program maintenance

Q8

Unlike traditional systems development, this software development approach focuses less on the procedures and more on defining the relationships between previously defined procedures.

a. object-oriented

b. 2GL

c. module

d. context-markup

Ans: object-oriented

Q9

Natural languages are considered to be a:

a. low-level language

b. high-level language

c. midlevel language

d. procedural language

Ans: high-level language

Q10

A compiler converts the programmer’s procedural language program, called the source code, into a machine language code, called the:

a. structured code

b. object code

c. interpreter code

d. top-down code

Ans: object code

Q11

The 4GL languages that enable nonprogrammers to use certain easily understood commands to search and generate reports from a database.

a. query

b. application generator

c. C++

d. COBOL

Ans: query

Topic 12

Q1

View that focuses on the actual format and location of the data.	Physical
A data problem that often occurs when individual departments create and maintain their own data.	Redundancy
Type of database that uses communication networks to link data stored in different locations.	Distributed
Type of database structure where fields or records are structured in nodes that are connected like the branches of an upside-down tree.	Hierarchical
Type of database structure where the data elements are stored in different tables.	Relational
Two of the most significant advantages of multidimensional databases are conceptualization and processing _____.	Speed
Another name for a data dictionary.	Schema
Type of processing in which data is collected over several hours, days, or even weeks and then processed all at once.	Batch
Group of related characters.	Field
Object-oriented databases organize data by classes, objects, methods, and _____.	Attributes

Q2

Facts or observations about people, places, things, and events are:

a. occurrences

b. tables

c. data

d. records

Ans: data

Q3

The most basic logical data element such as a single letter, number, or special character is known as a(an):

a. record

b. character

c. element

d. phrase

Ans: character

Q4

Each record in a database has at least one distinctive field, called the:

a. view

b. key field

c. type

d. structure

Ans: key field

Q5

One element of database security is to provide only authorized users with:

a. relations

b. passwords

c. classes

d. nodes

Ans: passwords

Q6

The bridge between the logical and physical views of the data is provided by:

a. records

b. SQL

c. tables

d. DBMS

Ans: DBMS

Q7

Highly trained computer specialists who interact with the data administration subsystem are known as:

a. relational specialists

b. database administrators

c. DBMS

d. data modelers

Ans: database administrators

Q8

In a network database, each child node may have more than one parent node; this is known as a:

a. many-to-many relationship

b. parent relationship

c. hierarchy

d. relational relationship

Ans: many-to-many relationship

Q9

Connections between parent nodes and child nodes are provided by:

a. objects

b. DBA

c. pointers

d. characters

Ans: pointers

Q10

Two of the most significant advantages of multidimensional databases over relational databases are processing speed and:

a. conceptualization

b. control

c. objectification

d. format

Ans: conceptualization

Q11

Object-oriented databases organize data by classes, attributes, methods, and:

a. relations

b. time

c. space

d. objects

Ans: objects