Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

CLEP - Information Systems & Computer Applications > Section 4 > Flashcards

Section 4 Flashcards

1
Q

__________ is the study of the meaning of a word or the interpretation of a written or spoken sentence or statement.

A

Semantics

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

____________ is a way of writing a computer algorithm in readable form, which can then be used as a basis to write an actual computer program.

A

pseudocode

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

___________ is the act of creating and writing a computer program to perform a particular task, such as generating and printing payroll checks.

A

programming

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

Programming _____ involves human thinking to give correct and valid mathematical reasons (logic) in a step-by-step manner when writing a computer program that will perform a particular task or solve a particular problem.

A

logic

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

_________ programming logic is a set of statements that is executed only once.

A

Sequential

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

In _______ Programming logic, the same sets of statements are repeated a certain number of times.

A

Looping

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

_________ Programming logic, also known as selective programming logic, selects one choice from a number of different operations that can be performed based on the outcome of some test condition applied to a variable such as a test score (ex. assign an A if test score is >= 90.

A

Decision

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

_____-______ Programming is a signal to a program that something has happened or occurred and the program must perform some operation to deal with the occurrence of that event.

A

event driven

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

_____-______ __________ (OOP) perceives everything as an object, where it has unique identity, displays some state, and exhibits some behavior. It’s an approach to program design in which a program consists of a collection of objects that contain data and methods to be used with that data.

A

Object-Oriented Programming

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

____ ____ specifies the kind of value that can be stored in each column of a database table and the types of operations that can be performed on those values.

A

data type

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

4 basic data types:

A

number, character, data and time, and Boolean

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

Animated images are ___ files in computers.

A

GIF

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

_____________ Data Type allows users to define the data type along with a list of acceptable values. ex. Months [Jan, Feb, Mar…]

A

Enumerated

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

____ structure is a scheme to structure data so that data of varied types can be entered, stored, sorted, retrieved, and manipulated by a computer program efficiently.

A

Data

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

In OOP, ______ ___ ___ (ADT) is used to create user-defined data type by collecting a number of data fields of built-in data types of programming language and methods to perform operations on those data fields as one unit.

A

Abstract Data Type

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

______ Files are unformatted file stores and are not able to edited with a word-processing program.

A

Binary

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

____ Files are formatted files that store formatted data in ASCII code and have the “.txt” extension, it can be read by any program that reads text.

A

Text

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

____ files store data that is read and processed by a program file.

A

data

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

Text files are ________ access files as the data stored in them has to be read sequentially.

A

sequential

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

Files stored in a storage medium such as a hard disk, are called ______ ______ files.

A

random access

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

_______ files store data in two discrete states: On (1) and Off (0). Off (0) indicates an absence of an electronic charge.

A

Digital

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

_____ files provide sound when you listen to downloaded MP3 files or live broadcasts through Internet radio.

A

Audio

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

_____ files are video clips displayed on a computer when it is connected to the website of a particular company.

A

video

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

Every file stored is given a name according to ____-_______ convention.

A

file-naming

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

A file _________ is a description of the way in which data is stored in a file; a computerized filing system.

A

structure

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

Every hard disk has a ____ directory, and user created _________ of file folders.

A

root; hierarchy

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

In the _____________ file structure, the folders are arranged in a scheme that resembles a family tree with folders related to one another, from top to bottom, where the file at the bottom stores the actual data or information. Every child folder can have one and ONLY one parent folder.

A

hierarchical

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

In ______ file structure, the records are arranged in groups, and each group known as a set. A particular file at one level can have MORE than one parent file.

A

Network

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

____________ File Structure is a structure in which the data in a file is accessed and processed in a serial manner from beginning to end, in the order that the data was written during the creation of the file.

A

Sequential

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

In a ________ scheme, storage is divided into a number of partitions, known as buckets, where each bucket can store a number of records. Using an algorithm, a hash function converts the key value of each record into a bucket number and then stores that record in the calculated bucket number. To access a record , the key value is converted to a bucket number, and then contents of the calculated bucket number are retrieved in order to search for the desired record.

A

hash

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

a one-dimensional array data structure is simply a ____.

A

list or homogenous array of the same type of data. ex. cities, employees, books, etc.

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

A collection of items of different data types is knows as ______________ array, which is best handled as ADT’s (classes).

A

heterogeneous

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

A homogenous ___-____________ array is a collection of data items of the same data type that are stored in a rows and column format.

A

two-dimensional

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

A _____ is a data structure un which the data items are removed from the top of a list and inserted only at the top of a list. Uses Last In, First Out concept.

A

stack

35
Q

A _____ is a data structure in which new data items are added at the end of the list while other items are removed from the beginning of the list, singing First in, first out concept. The front is the head and the end is the tail.

A

queue

36
Q

A ____ is a data structure in which data items are stored in the form of hierarchical org chart and has terms such as node, root node, parent node, child node, siblings, leaf node…

A

Tree

37
Q

In a ______ tree, a parent node cannot have more than two child nodes.

A

binary

38
Q

A _______ list is a data structure that, when storing records or data items, uses an additional field (known as a pointer) in record to store the link to the next data item or record in the list. Each data item in the list is a node.

A

linked

39
Q

A ________ is an added data field in a record that points to the location fo the next record in the list.

A

pointer

40
Q

The ____ points to the first data item in list and ____ indicates the end of the data items in a list

A

head, tail

41
Q

______ linked list - is when each data item points to the next data item in the list without pointing backward.

A

Singly

42
Q

______ linked list is a list where each data item has one backwards pointer to point to the previous data item and one forward winter to point to the next data item int he list.

A

doubly

43
Q

A __________ __________ _______ is a program that allows the user to create, maintain, and access a computerized database structure, while doing operations such as inserting, editing, and deleting data or records; querying data; sorting records; and creating forms and reports from the records stored in the database.

A

Database Management System (DBMS)

44
Q

_____ ___________ is the technique used to manage data that is stored in a computer’s memory as a resource for an organization. The objective is to make quality business decision.

A

data management

45
Q

____ ________ is the process of going through various files of a database and reading each record in a file to search for a particular kind of information.

A

data browsing

46
Q

____ ___________ is the technique used to create a database structure that allows data to be collected at its point of origin; organizes that data in a manner that stores it efficiently and with easy accessibility to make business decisions and produce reports; and allows data to be manipulated.

A

data modeling

47
Q

A _________ is a collection of tables (entities), where each entity is an object and the data about each entity is collected and stored as attributes (columns in table). Then, relationships are created between the tables to access data stored in two or more tables in a single SQL statement for making business decisions.

A

database

48
Q

_____ __________ is a technology that allows information or data to be kept accurate and up-to-date.

A

data maintenance

49
Q

__________ ______________ is an important part of data management in an organization and is performed by a database administrator (DBA).

A

database administration

50
Q

____ ________ means that data should be available when needed and it should be current, accurate, and complete.

A

data integrity

51
Q

____ _________ means that data must be protected against unauthorized access and modification. All the users of database are given a user id and password for control unauthorized access to the database.

A

data security

52
Q

____ _________ means that an individual or an organization determines who can see their data, what part of the data can be seen, how the data will be used, and where the data will be used.

A

data privacy

53
Q

____ _______ is an automatic process that searches and analyzes data stored in a database from different angles and converts it into useful information. It uncovers flaws, problems, and opportunities that may exist in stored data that the end user is not aware of such as finding problems in the relationships of tables.

A

data mining

54
Q

___ _________ is a place where data that has been collected from various databases is housed.

A

data warehouse

55
Q

Data can be stored in a centralized data warehouse or a ______________ data warehouse where it stores data in regionally based warehouses.

A

decentralized

56
Q

Data stored in a data warehouse is ______ removed.

A

never

57
Q

A ____ _____ is a mall sub-set of a data warehouse that is subject oriented and ism usually used by a particular group of people.

A

data mart

58
Q

__________ is the storage of information that provides a detailed explanation of the characteristics of the data and the set of relationships between data stored inside the database.

A

Metadata

59
Q

____ ___________ means that stored data has been damaged and is unreadable.

A

data corruption

60
Q

___ ___ means that data that was input and is stored on a storage medium can no longer be retrieved. It can be caused by human error, natural disasters, or b/c of hardware failures and file corruption.

A

data loss

61
Q

An ______ is an arrangement to sort or arrange data used to access the records in a data file (table).

A

index

62
Q

An ______ ___ is a sorted data field in a table that is used to access data in a data file.

A

index key

63
Q

A ______ _____ is an index key that points to a unique row in a data file.

A

unique index

64
Q

A ___________ data model is organized in a tree-like structure, showing parent-child relationships.

A

hierarchical

65
Q

In a _______ data model, the database can be seen as a group of records that are joined in a 1:M and one record can have more than one parent. It’s different from a hierarchical data model b/c one child can have more than one parent.

A

network

66
Q

In a ____________ __________ ______ (RDBMS) the data is stored in tables, in which the table is a matrix made up of M number of columns (attributes) and N number of rows (records). The values that can be assigned to an attribute must be selected from a set or range of values that the column can take. The set of values is known as the domain.

A

Relational Database Model System

67
Q

A _________ ______ ________ (SQL), the standard query language for relational databases, is used to create a database structure; to insert, update, delete, and organize data in relations (tables); and to provide data security by giving access rights to insert, view, and manipulate data in a database.

A

Structured Query Language

68
Q

In an _______-_________ __________ ______ (OODBMS, the data is stored in the from of objects and uses OOP logic; where each object contains data about objects in the form of attributes (fields). Objects that have the same attributes are grouped together and stores as classes containing the attributes of objects and methods to perform operations on those objects.

A

object-oriented database model system

69
Q

A _____________ database can store text, numbers, pictures, sound, movies, and hyperlinked data fields.

A

multimedia database

70
Q

A _______ database uses a combination of the database models.

A

hybrid

71
Q

An _______ _______________ model (ERM) is described through entities having relationships between them. It uses “connectivity” to describe the type (1:1, 1:M, M:N) of relationship, and “cardinalities” to show lower and upper limits of the type of relationship.

A

entity relationship model

72
Q

A DBMS must ensure that data redundancy is ________.

A

minimal

73
Q

In _____ processing, data processing is done on the bulk of the data at the end of certain time period.

A

batch

74
Q

when a customer makes a purchase online, e-commerce, the transaction is known as ______ ____________ __________ (OLTP).

A

Online Transaction Processing

75
Q

A traditional database is organized in a hierarchical relationship in what order?

entities, bit, record, character, field database and file

A

bit, character, entities, field, record, file and database

76
Q

A _________ is the smallest unit of meaningful information, each occupies 1 byte of space in memory.

A

character

77
Q

An _______ is a noun, something we are collecting data or information on.

A

entity

78
Q

A _____ is the smallest piece of data that a database user can read from a database table. It requires 4 attributes to be specified; Name/Title, Data type such as number, date/time, length to specify the max number of characters that can be used, and the format of the values such as DOB or SSN format.

A

field

79
Q

A ______ is a group of related fields used to completely describe one instance of an entity. It’s also known as row.

A

record

80
Q

A ____ is a collection of identical types of records, it’s also known as a relation or table.

A

file

81
Q

Oracle SQL uses the ______ command to create a table in a database.

A

CREATE

82
Q

When entering data in a PK field, the particular row must be _______ and must not be blank.

A

unique

83
Q

SQL uses ____ ______________ ________(DML) commands to query and manipulate (maintain) data inside a database by performing the following operations in a database; insert records, query (retrieve) tables, delete records, update (edit) records.

A

Data Manipulation Language

84
Q

INSERT, UPDATE, DELETE, SELECT, COMMIT, and ROLLBACK are all ___ data manipulation commands.

A

SQL

CLEP - Information Systems & Computer Applications (5 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions