Use Data Structures — Cumulative exam Answers

50 verified answers1 views
21
Free Preview

Which pseudocode represents the flowchart?

Question illustration
A
Input lengthInput widthCalculate volume =length ´ width ´ heightPrint volume
B
Input lengthInput widthInput heightCalculate volume =length ´ width ´ height
C
Input lengthInput widthInput heightPrint volume
D
Input lengthInput widthInput heightCalculate volume =length ´ width ´ heightPrint volume
24

Samantha’s database contains a table of student scores and another table with student schedules. How can Samantha use this information to help her decide how to group students for review class?

A
She can use a simple query to sort the scores in ascending order.
B
She can use a simple query to group student scores by name.
C
She can use a complex query linking student scores by name and available study period, then sort the data and group it.
D
She can use a complex query to retrieve all scores below 65.
27

Mark and John are developing a program using Python. They name a variable 24_hour_mart, but then recognize that this name violates a Python naming convention. What naming convention does it violate?

A
Variable names can not include the underscore character (_).
B
Variable names can not begin with a number.
C
Variable names can not exceed ten characters in length.
D
Variable names can not be fewer than fifteen characters in length.
28

Which statement demonstrates the value of an iteration in programming?

A
An iteration can be used instead of many repetitive lines of code in a computer program.
B
An iteration makes a program end without having to press keys on the keyboard.
C
An iteration formats the code in a program into a neat indented form.
D
An iteration controls the order in which a program executes code.
29

A looping construct that continues to repeat until the expression becomes false is

A
a while loop.
B
a for loop.
C
an infinite loop.
D
a pass loop.
32

What does this loop that uses a range function do? for i in range(7, 15):print(“goodbye”)

A
It prints “goodbye” 8 times, numbered from 7 through 14.
B
It prints “goodbye” 9 times, numbered from 7 through 15.
C
It prints “goodbye” 9 times.
D
It prints “goodbye” 8 times.
33

Variables differ from values in that

A
variables are always letters of the alphabet and values are always numbers.
B
a variable is a symbol or a placeholder while a value is assigned to a variable as the result of a function.
C
a variable is accessible from anywhere in a program while a value is accessible only in one situation.
D
a variable is defined by the programmer while a value is defined by the program.
34

One evening, a teacher uses a computer program to record each student’s test grade. She then uses the program to calculate each student’s test average for the year. The teacher then plans her lessons for the following week. Which of the following best explains how the computer algorithm helps the teacher?

A
It gives the teacher step-by-step directions on how to grade tests.
B
It makes a simple task more complex for the teacher.
C
It reduces the errors the teacher makes in writing tests.
D
It saves time for the teacher so that she can do other tasks.
37

How is an interpreter different from a compiler?

A
An interpreter translates and executes code line by line, while a compiler translates all code at once so that it is ready to be executed at any time.
B
An interpreter translates all code at once so that it is ready to be executed at any time, while a compiler translates and executes code line by line.
C
An interpreter translates programming code into binary language, while a compiler does not.
D
An interpreter translates binary language into programming language, while a compiler translates programming language into binary language.
38

How do HLookup and VLookup differ?

A
HLookup searches for data in columns, while VLookup searches for data in rows.
B
HLookup searches for data in cells, while VLookup searches for data in tables.
C
HLookup searches for data in tables, while VLookup searches for data in cells.
D
HLookup searches for data in rows, while VLookup searches for data in columns.

Did you find these answers helpful?

Use Data Structures — Cumulative exam Answers —…