Answers VA-Information Technology Fundamentals BCumulative Exam

Cumulative Exam Answers

4 verified answers

Free Preview

Why is it important to begin development of a software solution with a programming design in place?

A programming design summarizes the results of a software development process.

A programming design summarizes the marketability of a software solution and the strategy for product placement.

A programming design communicates decisions about the programming approach and saves time, money, and effort.

A programming design communicates decisions about the approach for hiring contractors and saves time, money, and effort.

Free Preview

Dinah is using an IDE to write, modify, and save code. Which tool should she use?

a source code editor

a build automation tool

a compiler

a debugger

A Products table and an Orders table have several linked records that are joined by a cross-referencing table named ProductsOrders. What kind of table relationship do these tables demonstrate?

one-to-one

one-to-many

many-to-many

many-to-none

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?

Variable names can not include the underscore character (_).

Variable names can not begin with a number.

Variable names can not exceed ten characters in length.

Variable names can not be fewer than fifteen characters in length.

Which task is most suitable for creating an algorithm?

saving time writing a report

explaining how to set up a mobile phone for use

choosing photos to put on a website

finding the best of three suggested routes to drive to a concert

Use the line of code below to choose the correct answer.while (count < 7): print ‘Great!’This code is an example of a(n)

infinite loop.

pass statement.

for loop.

single statement suite.

Marie can now edit her photos, send them in emails, print them on a printer, and use them as wallpaper on her computer. This is because Marie converted the photos to

JPG files.

TASS files.

AI files.

OCR files.

Variables differ from values in that

variables are always letters of the alphabet and values are always numbers.

a variable is a symbol or a placeholder while a value is assigned to a variable as the result of a function.

a variable is accessible from anywhere in a program while a value is accessible only in one situation.

a variable is defined by the programmer while a value is defined by the program.

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

a while loop.

a for loop.

an infinite loop.

a pass loop.

Which is a real-world example of a procedure?

calculating the tip given the total at a restaurant

pressing submit and getting a new password

dividing to determine the number of cookies to distribute to each guest

getting up and dressing before school

Which best describes a computer bug?

a piece of computer hardware that is out of date or has a newer version

a piece of computer software containing defects that prevent a program from running properly

a piece of computer hardware that is being used improperly

a piece of computer software that is out of date or has a newer version

Comments should

give the reader the background of the programmer.

be written for every line of code.

communicate the purpose of the code that follows it.

give information about how many hours it took to write the code.

What does a sort tool enable you to do in a database?

remove irrelevant data from a form

hide irrelevant data in a form

arrange records by number of typos entered in a field

arrange records by field in a form

Mrs. Patel uses a computer program to balance her checkbook. Which of the following best explains how the computer algorithm helps Mrs. Patel?

It gives judgments about how Mrs. Patel spends her money.

It makes Mrs. Patel modern.

It reduces errors.

It shows how to write checks.

To create a nonlinear presentation that has external links, the designer should

include every slide in an order that loops continuously, causing the whole presentation to repeat.

include hyperlinks on each page to a table of contents that shows the order of the presentation.

include hyperlinks to websites or other slides that the user can choose at will.

include slides that move from start to finish following the same path each time.

The unique identifier for each record in a database table is called the

record ID.

ID number.

primary key.

row number.

A programmer is responsible for solving a problem and making a presentation that includes his solution. He does not have much room to show the steps, so he uses mostly words and a few symbols. For this presentation he decides to use

a flowchart because pseudocode is harder to write and understand.

pseudocode because it gives a summary of the process with concise words and symbols.

a flowchart because it requires special training to understand.

pseudocode because it uses pre-defined shapes to show the steps.

When preparing a photo for a magazine, a graphic designer would most likely need to use a program such as

Microsoft Excel to keep track of magazine sales.

Microsoft Word to write an article about the photo.

Adobe Photoshop to manipulate the photo.

Autodesk Maya to create 3-D images that match the photo.

Which statement is true?

An employee list can give the departments and job titles of employees.

A product list can include names and addresses of buyers of the product.

A medical record can include consumer buying behaviors of prescriptions.

A market research report can give names of employees of a company.

Which is a correctly formatted Python tuple?

[12, “circle”, “square”]

{“n”:12, “shape1”: “circle”, “shape2”: “square”}

(12, “circle”, “square”)

12 circle square

Which is a tool that allows you to copy formatting from one place and apply it to other places?

Copy and Paste

Pagination

Styles

Format Painter

Effective character encoding requires

standardized code.

compatible browsers.

common languages.

identical operating systems.

Which margin size is most appropriate for a business card?

0.2 inches

1.0 inches

2.0 inches

3.5 inches

Kali, a Python programmer, is using the turtle module to write the word “hello.” Which code should she use to indicate the location to begin writing the word?

# Pick up the turtle and move it to its starting location.

penup(-100, 200) goto()pendown()

penup() goto(-100, 200) pendown()

# Pick up the turtle and move it to (-100, 200)

A piece of the Student Info table in the Harris Community College database is shown below. What information could an instructor find by querying this table in the database?ID#FirstNameLastNameStudentMajorAddress1BethBorskyArt55 Winsap Ln.2HankHoffChemistry7 Gosling Rd.3StephanieSerlePolitical Science136 Finley Ave.4RafiRohrArt55 W. 79th St.

a list of students over the age of 35

a list of students grouped by major

a list of students who got over a 90% on the entrance exam

a list of all male students

What is the difference between a sort tool and a filter tool?

A sort tool is used by end users, and a filter tool is used by database administrators.

A sort tool is used by database administrators, and a filter tool is used by end users.

A sort tool arranges records by field but hides them from view, and a filter tool hides records that a user does not want to view when focusing on specific records.

A sort tool hides records from view but does not remove them from a database, and a filter tool removes unwanted records from a database.

Mika forgot to put in the function name in his function header for the code below. What would be the best function header?def draw(): forward(80) left(120) forward(80) left(120) forward(80) left(120)

def drawDiamond():

def drawTriangle():

def drawN():

def drawH():

Which can be used to decode a Unicode character encoding into text?

stringVariable=unicodeString.decode(decoding= “utf-8”, errors= “strict”)

stringVariable=unicodeString.encode(encoding= “utf-8”, errors= “strict”)

stringVariable=unicodeString.decode(encoding= “utf-8”, errors= “strict”)

stringVariable=unicodeString.encode(decoding= “utf-8”, errors= “strict”)

Serena, an analyst at an environmental agency, wants to prepare a report using data from the Car Emissions database. In her report she plans to include written analysis as well as circle graphs. To best complete this task, she can

export the query results from the database to a spreadsheet, then export the graph to a document.

export the query results into a word processing document, then import the graph into the same document.

export the graph into a spreadsheet.

export the query into a word processing document.

Which statement is correct?

Flat files use foreign keys to uniquely identify tables.

Flat files use foreign keys to secure data.

A foreign key is a primary key in another table.

A foreign key uniquely identifies a record in a table.

What is an example of a network database?

a database that stores medical records and needs to accommodate patients who see several doctors and use multiple clinics

a database that contains a retail store’s lists of employees and the managers they report to

a database that organizes a list of customers’ saved online shopping carts using the customers’ ID numbers

a database that stores information for a professional website that keeps users’ photos and resumes

Which are steps taken to diagnose a computer problem?

reproducing the problem and using error codes

reproducing the problem and troubleshooting

using error codes and troubleshooting

using error codes and stepping functions

Which syntax error in programming is unlikely to be highlighted by a compiler or an interpreter?

a variable name misspelling

a missing space

a comma in place of a period

a missing closing quotation mark

In a digital drawing program, when an object is highlighted, boxes appear at the sides and corners. These boxes can be grabbed and dragged to manipulate the size and shape of the object. What are these boxes called?

handles

pointers

grips

shifters

Which is an advantage of using a flat file instead of a relational database?

A flat file is easier to set up.

It is easier to assign foreign keys to a flat file.

A flat file reduces storage of redundant data.

A flat file reduces storage of irrelevant data.

An unexpected result is returned by the computer when a program is executed. Which has likely occurred?

an error

a compiler

an interpreter

a stepping function

A Student table and an Address table contain one linked record. What kind of table relationship do these tables demonstrate?

one-to-one

one-to-many

many-to-many

many-to-none

In the blank LibreOffice Writer document, to start the process of entering a date field into a letter, click on the

Insert menu.

Edit menu.

File menu.

Fields menu.

What happens when a Boolean expression is evaluated?

If the condition evaluates as True, then the next statement is executed.

If the condition evaluates as True, then nothing happens.

If the condition evaluates as False, then the next statement is false.

If the condition evaluates as False, then the next statement is executed.

Which best describes the condition under which the Unicode output is the same as plain text?

when the text contains no punctuation

when the text contains only characters that are part of Unicode

when the text contains only characters that are part of ASCII

when the text contains no numbers

Which shape denotes a process to be carried out in a flowchart?

an oval

a parallelogram

a rectangle

a diamond

Which statement is true?

Bill Gates and Guido van Rossum cofounded Microsoft.

Bjarne Stroustrup published the first reference guide for C++.

Paul Allen developed object-oriented programming.

John McCarthy led a team that developed FORTRAN.

Mr. Stevens is the principal of a high school. Why might he want to export data from a database of students’ exam scores?

to create a presentation using other software on how students’ scores have changed throughout a semester

to view the student data in a new database

to query the database and sort students into groups according to their scores

to append additional student records to the database

Which string of octal values in the conversion table can be used to represent the word “BAKE”?

101 102 105 107

105 113 101 102

102 101 113 105

1018 1028 1058 1078

Which of the following is an object-oriented programming language?

Ada

COBOL

Pascal

Python

In Python, arrays are usually reserved for

sorting operations.

indexing operations.

searching operations.

numerical operations.

Arrays are described as immutable because they

are two dimensional.

are arranged sequentially.

can be reordered.

cannot be changed once they are defined.

When is it a good time to create a database?

when you have a long list of contacts you need to save and refer to

when you have a short list of contacts you need to save and refer to

when you have a small volume of data you need to track and calculate

when you have large volumes of data you need to track and analyze

A spreadsheet software program requires that users predefine each field’s data type. The software program is most likely programmed using a language that is

open.

predefined.

strongly typed.

weakly typed.

An error was reported in a software program by a user. Before that error can be diagnosed and fixed

it must be reproduced.

it must be beta tested.

the code must be rewritten.

the code must be debugged.

Did you find these answers helpful?

Cumulative Exam Answers

More from this Course

TRY EDGENUITY HACKS