M6 Flashcards

1
Q

referring to the hardware, software,
computer system connections, information, information system users, and the
building where its located.

A

information system

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

The

most common types of information systems are

A

transactions processing or TPS,
Management Information Systems or MIS, Decision Support Systems, and Executive
Information System.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

The six elements of a Computer Based Information

System (CBIS) are:

A

Hardware, software, data, procedures,

people, and communication.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

refers to the computers themselves, along with
any and all peripherals, including servers, routers,
monitors, printers and storage devices.

A

hardware

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

tells the hardware how to function

A

software

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

the information part of an information system

A

data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Rules, descriptions and instructions for how things are

done.

A

procedures

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

who design and operate the software, input the
data, build the hardware and keep it running, write the
procedures and it is ultimately people who determine the
success or failure of a CBIS.

A

people

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

The components that allow one computer to communicate

with another are hardware and are controlled by software.

A

communication

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

a collection of data organized in a manner that allows access, retrieval,
and use of that data.

A

database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

A list of related information in columns and rows

A

table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

a database object that can be used to extract or

show information in Datasheet view.

A

query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

is a database object that you can use to enter, edit,

or display data from a table or a query

A

form

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

is another database object which can be use to

summarize information from a table or query.

A

report

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

can be used to create an action or set of actions

that can be used to automate a task

A

macro

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

is a field or set of fields in your table that

acts as a unique identifier for every row.

A

primary key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

is a situation that exists between two
relational database tables when one table has a foreign
key that references the primary key of the other table.

A

relationship

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

relationship

A

One-to-One relationship

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

exist when a primary record from the primary table

is related to many records in the related table.

A

One-to-Many relationship

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

exist when a primary record from the primary
table is related to many records in the related table AND a related record in the related table is also related to many records in the primary table

A

Many-to-Many relationship

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

A _________ stores data about engineering, architectural, and scientific designs.

A

COMPUTER – AIDED DESIGN (CAD) DATABASE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Most __________ database products for servers and mainframes include SQL.

A

relational

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

A(n) __________ program interacts with a DBMS, which in turn interacts with the database.

A

FRONT END

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

________ is processed data; that is, it is organized, meaningful, and useful.

A

— INFORMATION

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

In a database, a field __________ uniquely identifies each field

A

primary key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

The developer of a relational database refers to a file as a(n) __________

A

relation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

In managing a company’s database, the database __________ requires a technical inside view of data.

A

— ADMINISTRATOR

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

The developer of a relational database refers to a record as a(n) __________.

A

— TUPLE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

In a database, a(n) __________ is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses

A

field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

For a database, the field __________ defines the maximum number of characters a field can contain.

A

— SIZE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

A(n) __________ is an item that contains data, as well as the actions that read or process the data.

A

— OBJECT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

A data _________ is a collection of related records stored on storage media such asa hard disk, CD, or DVD.

A

— file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

For a database, the field __________ defines the maximum number of characters a field can contain.

A

— SIZE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

A(n) __________ is an item that contains data, as well as the actions that read or process the data.

A

— OBJECT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

A data _________ is a collection of related records stored on storage media such as a hard disk, CD, or DVD.

A

file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

A user of a relational database, refers to a record as a __________.

A

row

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

A major weakness of a lot of file processing systems is that __________.

A

— THEY HAVE REDUNDANT DATA AND THEY ISOLATE DATA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

The advantage of a multidimensional database is that __________.

A

— IT CAN CONSOLIDATE DATA MUCH FASTER THAN A RELATIONAL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

A(n) __________ stores data in objects.

A

— OODB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

In a relational database, each row __________.

A

— HAS A PRIMARY KEY AND EACH COLUMN HAS A UNIQUE NAME

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

Compared with relational databases, object-oriented databases __________.

A

— ALL OTHER CHOICES ARE CORRECT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

In a relational database, users can set up a relationship between tables at any time, but the tables must have a common __________.

A

— column

43
Q

A(n) __________ database is an application appropriate for an object-oriented database that contains text, graphics, video, and sound.

A

— HYPERMEDIA

44
Q

__________ is a process designed to ensure the data within the relations (tables) contains the least amount of duplication.

A

— NORMALIZATION

45
Q

In managing a company’s database, the data ________ focuses on the meaning and usage of data.

A

— modeler

46
Q

In a relational database, a __________ is a connection within the data.

A

— RELATIONSHIP

47
Q

Popular data models in use today include all of the following except ___________.

A

— HIERARCHICAL

48
Q

It is the process of comparing data with a set of rules or values to find out if the data is correct.

A

— VALIDATION

49
Q

Validation ____________ reduce data entry errors.

A

— RULES

50
Q

A multidimensional database stores data in multiple dimensions, sometimes known as a(n) __________, that allow users to access and analyze any view of the database data.

A

— HYPERCUBE

51
Q

In a relational database, the only data redundancy exists in the __________.

A

— FIELDS

52
Q

In a typical file __________ system, each department or area within an organization has its own set of files.

A

— PROCESSING

53
Q

The advantage of a multidimensional database is that __________.

A

it can consolidate data much faster than a relational database

54
Q

A(n) __________ digit is a number(s) or characters that is appended to or inserted into a primary key field.

A

— CHECK

55
Q

A data __________ is a huge database that stores and manages the data required to analyze historical and current transactions.

A

— WAREHOUSE

56
Q

File __________ refers to the procedures that keep data current.

A

— MAINTENANCE

57
Q

Data __________ identifies the quality of data in a database.

A

— INTEGRITY

58
Q

A __________ stores documents such as schedules, calendars, manuals, memos, and reports.

A

— GROUPWARE DATABASE

59
Q

_________, is a query language that allows users to manage, update, and retrieve data.

A

SQL or STRUCTURED QUERY LANGUAGE

60
Q

A(n) __________ stores data in objects.

A

— OODB

61
Q

A(n) __________ stores data in dimensions.

A

— MULTIDIMENSIONAL

62
Q

A user of relational database refers to a file as a __________.

A

— column

63
Q

Object-oriented and object-relational databases often use a query language called __________ to manipulate and retrieve data.

A

— OQL

64
Q

_________ is a collection of unprocessed items, which can include text, numbers, images, audio, and video.

A

— DATA

65
Q

When a company uses that __________ approach, many programs and users share the data in a database.

A

— DATABASE

66
Q

Many databases programs perform a validity __________ that analyzes entered data to help ensure that it is correct.

A

— CHECK

67
Q

A user of relational database, refers to a field as a __________.

A

— table

68
Q

few operating systems include utility programs

A

false

69
Q

_____ is a set of data related for a specific purpose or topic

A

database

70
Q

What kind of relationship is observed in the situation: Suppliers to products

A

many-to-many

71
Q

it is a collection of unprocessed information

A

data

72
Q

A company can use thousands of computer system in a single computer-based information system

A

true

73
Q

it is the most overlooked element of a CBIS

A

people

74
Q

a file _____ utility is a utility that transforms the contents of a file or data from one format to another.

A

conversion

75
Q

With an operating system, _____ can include fixes to bugs, enhancements to security, modifications to devices drivers, and the like.

A

automatic updates

76
Q

a device dependent program runs on computers provided by a variety of manufacturers

A

false

77
Q

because virtual memory is faster than RAM, users may notice the computer speeding up while it uses virtual memory

A

false

78
Q

when users press a key or move the mouse, a screen saver disappears, and the screen returns to the previous state

A

true

79
Q

_____ is an element of an information system which refers to the physical component of a computer system

A

hardware

80
Q

this element of a CBIS tells hardware how to function

A

software

81
Q

_____ software assists people in becoming more effective and efficient while performing their daily business activities

A

business

82
Q

a(n) _____ operating system is an operating system that organizes and coordinates how multiple users access and share resources on a network

A

server

83
Q

even if users are working on multiple programs simultaneously, it is impossible to run out of RAM

A

false

84
Q

a(n) _____ is a window on the screen that provides areas for entering or changing data in a database

A

form

85
Q

_____ software provides a means for sharing, distributing, and searching through documents by converting them into a format that can be viewed by any user

A

document management

86
Q

what kind of relationship is observed in the situation: A customer to products that can be ordered

A

one-to-many

87
Q

stand-alone utilities typically offer improvements over those features built into an operating system or provide features not included in an operating system

A

true

88
Q

_____ is software that acts without a user’s knowledge and deliberately alters a computer’s operations

A

malware

89
Q

a(n) _____ is a rectangular area of the screen that displays data and information

A

window

90
Q

when computer users _____ a document, the computer transfers the document from the memory to a store medium

A

save

91
Q

the _____ is a small symbol displayed on the screen that moves as a user moves the mouse

A

pointer

92
Q

word processing software includes a(n) _____, which reviews the spelling of individual words, sections of a document, or the entire document

A

spelling checker

93
Q

when using spreadsheet software each worksheet can have more than ___ cells

A

17 billion

94
Q

Linux is _____ software, which means its code is provided for use, modification and redistribution

A

open source

95
Q

____ software helps companies records and reports their financial transactions

A

accounting

96
Q

_____ software consists of programs designed to make users more productive and/or assist them with personal tasks

A

application

97
Q

a program called a print _____ interprets documents to be printed from the operating system and places them in the queue

A

spooler

98
Q

_____ is a multitasking operating system developed in the early 1970s by scientists in bell laboratories

A

unix

99
Q

the kernel is memory _____, which means it remains in memory while the computer is running

A

resident

100
Q

In addition to being a stand-alone operating system, UNIX also is a network operating system

A

true

101
Q

two types of system software are _____.

A

operating systems and utility programs

102
Q

during a cold boot on a personal computer, the POST results are compared with the data in a _____ chip

A

CMOS

103
Q

a spyware _____ is a program that detects and deletes spyware and other similar programs

A

remover

104
Q

it is a n element of CBIS that is responsible in disseminating information to other people faster and safer

A

communications