Deck 12: Designing Databases

Question 1

Volatility is a protected memory space created by the CPU allowing the computer to create virtual machines.

Answer 1

False
Explanation: Virtualization is a protected memory space created by the CPU allowing the computer to create virtual machines.

Question 2

Which of the following represents megahertz?

A)The number of millions of CPU cycles per second
B)The number of billions of CPU cycles per second
C)A type of CPU that can recognize as many as 100 or more instructions, enough to carry out most computations directly
D)A limit on the number of instructions the CPU can execute to increase processing speed

Answer 2

A
Explanation: This is the definition of megahertz.

Question 3

Complex instruction set computer chips limit the number of instructions the CPU can execute to increase processing speed.

Answer 3

False
Explanation: Reduced instruction set computer (RISC) chips limit the number of instructions the CPU can execute to increase processing speed.

Question 4

What is a CPU?

A)The actual hardware that interprets and executes the program (software) instructions and coordinates how all the other hardware devices work together
B)The computer's main memory, which consists of the random access memory (RAM), cache memory, and the read-only memory (ROM) that is directly accessible to the central processing unit (CPU)
C)Equipment designed to store large volumes of data for long-term storage
D)Equipment used to capture information and commands

Question 5

Utility software provides additional functionality to the operating system.

Question 6

What is the size of the internal electrical pathway along which signals are sent from one part of the computer to another?

A)Clock speed
B)Word length
C)Bus width
D)Chip line width

Question 7

What is information technology?

A)Any computer-based tool that people use to work with information and support the information and information-processing needs of an organization
B)The set of instructions that the hardware executes to carry out specific tasks
C)The physical devices associated with a computer system
D)An electronic device operating under the control of instructions stored in its own memory that can accept, manipulate, and store data

Question 8

What is a complex instruction set computer chip?

A)The actual hardware that interprets and executes the program (software) instructions and coordinates how all the other hardware devices work together
B)Equipment that interprets software instructions and literally tells the other hardware devices what to do, based on the software instructions
C)A type of CPU that can recognize as many as 100 or more instructions, enough to carry out most computations directly
D)Equipment that performs all arithmetic operations (e.g., addition and subtraction) and all logic operations (such as sorting and comparing numbers) This is the definition of CISC.

Question 9

What is hardware?

A)Any computer-based tool that people use to work with information and support the information and information-processing needs of an organization
B)The set of instructions that the hardware executes to carry out specific tasks
C)The physical devices associated with a computer system
D)An electronic device operating under the control of instructions stored in its own memory that can accept, manipulate, and store data

Question 10

What is a form of a stationary mouse on which the movement of a finger causes the pointer on the screen to move?

A)Microphone
B)Touch pad
C)Pointing stick
D)Touch screen

Question 11

What is similar to a desktop but has more powerful mathematical and graphics processing capabilities and can perform more complicated tasks in less time?

A)Tablet
B)PDA
C)Workstation
D)Minicomputer

Question 12

What is an input device?

A)The actual hardware that interprets and executes the program (software) instructions and coordinates how all the other hardware devices work together
B)The computer's main memory, which consists of the random access memory (RAM), cache memory, and the read-only memory (ROM) that is directly accessible to the central processing unit (CPU)
C)Equipment designed to store large volumes of data for long-term storage
D)Equipment used to capture information and commands

Question 13

What is an older secondary storage medium that uses a strip of thin plastic coated with a magnetically sensitive recording medium?

A)Magnetic medium
B)Magnetic tape
C)Hard drive
D)RAM

Question 14

A tablet is a pen-based computer that provides the screen capabilities of a PDA with the functional capabilities of a laptop or desktop computer.

Question 15

What is roughly 1 million bytes?

A)Megabyte
B)Terabyte
C)Kilobyte
D)Gigabyte

Question 16

What detects the presence or absence of a mark in a predetermined place (popular for multiple-choice exams)?

A)Magnetic ink character reader
B)Optical-character recognition
C)Optical-mark recognition
D)Point-of-sale

Question 17

Disk optimization software helps save information if a computer crashes.

Question 18

What is the arithmetic logic unit?

A)The actual hardware that interprets and executes the program (software) instructions and coordinates how all the other hardware devices work together
B)Equipment that interprets software instructions and literally tells the other hardware devices what to do, based on the software instructions
C)A type of CPU that can recognize as many as 100 or more instructions, enough to carry out most computations directly
D)Equipment that performs all arithmetic operations (e.g., addition and subtraction) and all logic operations (such as sorting and comparing numbers)

Question 19

What is the number of bits (0s and 1s) that can be processed by the CPU at any one time?

A)Clock speed
B)Word length
C)Bus width
D)Chip line width

Question 20

What is software?

A)Any computer-based tool that people use to work with information and support the information and information-processing needs of an organization
B)The set of instructions that the hardware executes to carry out specific tasks
C)The physical devices associated with a computer system
D)An electronic device operating under the control of instructions stored in its own memory that can accept, manipulate, and store data

Question 21

____________ is the set of instructions that the hardware executes to carry out specific tasks.

Question 22

A (An) ____________ is designed to meet the computing needs of several people simultaneously in a small to medium-size business environment.

Question 23

A (An) ____________ device is the equipment used to see, hear, or otherwise accept the results of information processing requests.

Question 24

____________ is the number of billions of CPU cycles per second.

Question 25

____________ allows more than one piece of software to be used at a time.

Question 26

What organizes information on a hard disk in the most efficient way?

A)Text protect
B)Disk optimization
C)File recovery
D)Cash proof

Question 27

Define the relationship between operating system software and utility software.

Question 28

A cathode-ray tube (CRT) is a _________ tube that uses an electron gun (cathode) to emit a beam of electrons that illuminates phosphors on a screen as the beam sweeps across the screen repeatedly.

Question 29

Identify the different computer categories, and explain their potential business uses.

Question 30

What provides the tools for data retrieval, modification, deletion, and insertion?

A)Data management
B)Desktop publishing
C)Email
D)Groupware

Question 31

What is application software?

A)Controls how the various technology tools work together along with the application software
B)Controls the application software and manages how the hardware devices work together
C)Provides additional functionality to the operating system
D)Is used for specific information processing needs, including payroll, customer relationship management, project management, training, and many others

Question 32

Magnetic _________ is a secondary storage medium that uses magnetic techniques to store and retrieve data on disks or tapes coated with magnetically sensitive materials.

Question 33

A (An) ____________ device is equipment used to send information and receive it from one location to another.

Question 34

Describe the six major categories of hardware, and provide an example of each.

Question 35

____________ access memory is the computer's primary working memory, in which program instructions and data are stored so that they can be accessed directly by the CPU via the processor's high-speed external data bus.

Question 36

Explain the difference between primary and secondary storage.

Question 37

List the common input, output, storage, and communication devices.

Question 38

Describe the eight categories of computers by size.

Question 39

What is system software?

A)Controls how the various technology tools work together along with the application software
B)Controls the application software and manages how the hardware devices work together
C)Provides additional functionality to the operating system
D)Is used for specific information processing needs, including payroll, customer relationship management, project management, training, and many others