Question 1
Which of the following would NOT be part of a GUI?
icon
menu
button
typing a command
Question 2
Which of the following data sets is NOT stored in sequential order?
employees sorted by last name
cars sorted by color
tax records sorted by year
customer records entered by two typists who split the list in half alphabetically
Question 3
What is the name of the array in the below housekeeping module?
score
inScore
x
while
Question 4
A use case variation that shows functionality outside the base case is a(n) ____.
generalization
specification
extend
scenario
Question 5
Assume a customer record contains the fields:
custId
custName
custPhoneNum
custNextCustAddress
You could conclude this is part of a(n) ____.
index
linked list
insertion sort
swap
Question 6
In object-oriented programming, data fields are called ____.
methods
attributes
modules
details
Question 7
A basic query is: ____ custId, lastName FROM tblCustomer WHERE state = “WI”
SELECT
GRAB
GROUP
INSERT
Question 8
In a(n) ____ program the user could type either a letter or a number to select the same menu-option.
default
batch
elegant
user-friendly
Question 9
Usually a program that process an array uses a ____.
decision
black box
batch
loop
Question 10
Collections of classes that serve a related purpose are stored in ____.
modules
libraries
objects
instances
Question 11
When updating a master file with a transaction file, you encounter a situation in which the master record key is larger than the transaction record key. What type of operation would be valid at this point?
update
addition
deletion
merge
Question 12
When you merge records from two or more files, the records (almost) always contain ____.
the same data
the same fields in the same order
related information
unrelated information
Question 13
A(n) ____ is an occurrence that sends a message to an object.
event
command
prompt
GUI
Question 14
When all of the code in a module accomplishes one task, it has ____.
pathological coupling
normal cohesion
functional cohesion
normal coupling
Question 15
Assume an array has the following values: 90, 85, 65, 95, 75. What are the values in the array after the first operation in the bubble sort?
85, 90, 95, 75, 65
85, 90, 65, 95, 75
65, 85, 90, 95, 75
65, 75, 85, 90, 95
Question 16
A(n) ____ is unique among all records in a file.
flag
logical order
key field
index
Question 17
After the below code has executed, the ____ variable will hold the number of elements in the array.
inScore
numberOfEls
score
files
Question 18
What type of variable controls the main loop of a file merging program?
temporary
file
flag
character
Question 19
In an object-oriented program, one object can ____ another.
define
interpret
inherit from
own
**********************************************************
Many programming languages provide the ability to generate ____ numbers.
complete
random
long
hidden
When merging two files, what condition terminates the main loop of the program?
when the first file reaches eof
when the second file reaches eof
when both files reach eof
when 100 records have been processed
What happens during a merging program when both input files contain the same value?
an error occurs
the program exits
two identical records will appear in the merged file
only one record will appear in the merged file
The acronym ____ is used by computer professionals to mean that if you enter invalid input data into an application, the output results will be worthless.
FIFO
GIGO
MIMO
NIMP
When using a case structure to process a menu selection, a program with four menu options will require ____ cases.
1
3
4
5
Which of the following would be the best numeric high value?
-999
0
99
99999999999
What is the purpose of the flag variable in a bubble sort?
to eliminate unnecessary swaps
to eliminate unnecessary comparisons
to stop as soon as the list is sorted
to sort an array of unknown size
When merging, a ____ is used to determine which file the next record comes from.
comparison
loop
sequence
flag
What step is present in coding an event-driven program but not part of creating a procedural program?
Understand the problem.
Code the program.
Translate the program into machine language.
Create storyboards.
The questions that cause the database software to extract the appropriate records from a table and specify the fields to be viewed are called ____.
reports
queries
keys
indexes
Assume an array has the following values: 90, 85, 65, 95, 75. What are the values in the array after the first complete pass through the list of the bubble sort?
85, 65, 90, 75, 95
85, 90, 65, 75, 95
65, 85, 90, 75, 95
65, 75, 85, 90, 95
Which of the following is responsible for the initiation of a method in an event-driven program?
a loop
a conditional statement
a sequential statement
a mouse click
You need to understand a subroutine’s ____ in order to use it.
internal structure
local variables
programming style
interface
The numbers 1 3 5 6 7 10 15 are stored in ____ order.
descending
random
ascending
physical
A diagram that shows which screen leads to another is called a(n) ____.
storyboard
object dictionary
interactivity diagram
flowchart
What are signs of amateur design in a GUI?
menus placed on the top of the screen
icons that represent real-world objects
fancy fonts and weird color combinations
allowing the user to customize the background color
What is the largest unit in a data hierarchy?
character
field
record
file
Which of the following is an example of an interactive program?
payroll processing system
billing system
inventory system
library catalog
A(n) ____ use case is indicated with an open-headed dashed arrow.
extend
include
generalization
modification
In an object-oriented program, ____ are passed to ____.
methods, classes
messages, objects
modules, actions
objects, methods
****************************************************
A(n) ____ sort works by finding an element that is “out of order”.
bubble
selection
insertion
swap
Which of the following is NOT a UML diagram?
Use case
Activity diagram
Implementation diagram
Component diagram
What is the loosest style of coupling?
data
external
data-shared
control
Methods in object-oriented programs have ____ access.
private
public
derived
overloaded
When writing a module containing statements that repeat but may contain different variable values, you can use a(n) ____ to create a more elegant solution.
decision statement
stub
array
batch
What action does a merging program take after it writes a record from file 1?
writes the next entry from file 1
writes the next entry from file 2
reads the next entry from file 2
reads the next entry from file 1
A ____ file can be used to update a master file.
merge
data
transaction
detail
____ columns can hold any type of charactersletters or digits.
Text
Character
String
Number
Creating a many-to-many relationship in the database involves ____.
creating a link table
placing the foreign key in the related table
placing the foreign key in the base table
ensuring each table should have a foreign key to the other
What is the mean value for the following numbers?
1 2 20 30 40 50 100
30
34.71
50
100
A class diagram illustrating a single class contains a rectangle divided into three sections: the top section contains the ____, the middle section contains the ____, and the bottom section contains the ____.
name of the class, names of the attributes, names of the methods
name of the class, names of the methods, names of the attributes
class header, names of the methods, names of the attributes
name of the class, names of the exceptions, names of the subclasses
What is the most common table relationship?
one-to-one
one-to-some
one-to-many
many-to-many
Data records are stored in ____ order.
sequential
shared
default
grouped
Another name for data coupling is ____ coupling.
normal
data-structure
external
internal
In a batch program records are always ____.
saved and processed at one time
processed as they come in
typed in by a user and processed
loaded from a database
********************************************************
A(n) ____ diagram consists of a rectangle divided into three sections.
object
entity
class
attribute
A third-level menu is also called a ____.
batch
main menu
submenu
console
Which UML diagram shows the system from the perspective of users?
use case
statechart
activity diagram
collaboration diagram
What UML diagram has the closest resemblance to a conventional flowchart?
sequence
class
statechart
activity
In a database, files are called ____.
characters
rows
columns
tables
The ____ menu of a program contains the quit option.
main
submenu
exit
default
In a(n) ____ sort all of the array elements are moved to make room for the newly sorted element.
swap
selection
bubble
insertion
Module statements that are “invisible” to the rest of the program are said to be in a(n) ____.
function
black box
orange triangle
loop
How many loops are there in a bubble sort?
0
1
2
3
A(n) ____ is an example of a random-access storage device.
linked list
disk
index
physical memory
Which of the following sorting methods is least efficient?
insertion
selection
basic bubble sort
optimized bubble sort
Frequently, records are stored in order of their ____ field.
primary
unique
key
numeric
The ____ clause of a database query allows you to retrieve rows that match specified criteria.
SELECT
WHERE
FROM
EQUAL
Which of the following is a static UML diagram?
class
statechart
activity
collaboration
To create a new object of a class, you must ____ it.
instantiate
derive
inherit
enable
How many passes through an optimized bubble sort would be required to sort values 10, 20, 30, 40, 50, 60?
0
1
5
6
What type of variable is used to help move array elements in a selection sort?
swap
flag
temporary
array
There are two types of relationships shown in class diagrams: ____.
association and is-a
generalization and includes
association and aggregation
aggregation and integration
When a large amount of data needs to be sorted, it is more efficient to store the logical order and the physical address in a(n) ____ than to sort the data.
index
array
memory address
linked list
The last task that any menu-driven program should perform is ____.
accept another response
displaying nothing
reading the user response
performing a module based on user selection
******************************************
Like programming languages, ____ contain built-in functions.
spreadsheets
menus
GUIs
Web browsers
Assume an array has the following values: 90, 85, 65, 95, 75. What are the values in the array after the bubble sort has finished?
85, 65, 90, 75, 95
85, 90, 65, 75, 95
65, 85, 90, 75, 95
65, 75, 85, 90, 95
What is another name for command line?
GUI
command window
command prompt
command menu
Where is the best place to put a menu bar?
top of screen
left side of screen
right side of screen
bottom of screen
A rectangular area that displays text is a(n) ____.
option button
button
label
text field
GUI components are often referred to as ____.
widgets
gadgets
icons
buttons
____ values can be both letters and numbers.
Numeric
Boolean
Character
Black box
A method ____ describes how to use the method.
stamp
black box
signature
argument list
After the final pass in a selection sort the values 95, 80, 75, 65, 90 will be ordered as ____.
65, 80, 75, 95, 90
65, 75, 80, 90, 95
65, 75, 95, 80, 90
65, 80, 75, 90, 95
When matching records between files, they must be ____.
sorted in the same order
the same length
backed-up
printed
When ____ coupling is used an entire record is passed from one module to another.
data
data-structured
control
external
A college maintains a master file of all students and a transaction file for each course registration is an example of a ____ relationship.
master-transaction
equal
parent-child
master-detail
A class that inherits attributes and methods is a(n) ____ class.
child
parent
object
overlord
The tables with the following definitions are related with a ____ relationship. tblCustomers(customerNumber, customerName) tblOrders(orderNumber, customerNumber, orderQuantity, orderItem, orderDate)
one-to-one
one-to-some
one-to-many
many-to-many
What is the most common database query language?
SQL
MML
C++
Java
The variable’s ____ in no way affects how the method is called from another module.
local name
data type
size
definition
What is the first step in writing an event driven program?
Test the program.
Define the connections between the screens the user will see.
Understand the problem.
Define the objects.
After you choose a primary key from among candidate keys, the remaining candidate keys become ____ keys.
compound
foreign
alternate
discarded
A housekeeping routine exhibits ____ cohesion.
functional
temporal
procedural
logical
When a database program includes counts or totals at the end of each sorted group, its creation is a(n) ____ report.
query
primary key
grouped
control break
*********************************************************
Question 80
____ are used to organize files.
Characters
Records
Fields
Databases
Question 81
Which of the following is NOT another name for a module?
subroutine
function
procedure
loop
Question 82
A control break program that calculates totals for each category and a grand total has four modules: startUp, bookListLoop, categoryChange, closeDown. In which module would you expect to see the category total incremented?
startUp
bookListLoop
categoryChange
closeDown
Question 83
In a flowchart depicting a module, what shape does the return statement have?
circle
oval
rectangle
diamond
Question 85
In order to have the most efficient program, which question should be asked first when working with an AND decision?
the one that is less likely to be true
the one that is more likely to be true
the one that involves fewer comparisons
the one with the lower value
Question 86
Which of the following would NOT be a valid comparison to control a while loop?
rep < 65
rep > 1
rep > true
rep * 3 > 100
Question 88
When creating a printed report, you need to clarify whether the user wants a specific number of ____ lines per page, including headings, or a specific number of ____ lines per page following the headings.
detail, total
total, detail
heading, total
heading, detail
Question 100
In which programming language could the starting subscript be 13?
Java
VisualBasic
COBOL