final exam

Helpfulness: 0
Set Details Share
created 6 years ago by lsudduth
6,856 views
updated 6 years ago by lsudduth
show moreless
Page to share:
Embed this setcancel
COPY
code changes based on your size selection
Size:
X
Show:
1

Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?

database

2

Which of the following is a request for specific data from a database?

query

3

Which of the following languages consists of simple, English-like statements that allow users to specify the data to display, print, or store?

query

4

Which of the following is a window on the screen that provides areas for entering or changing data in a database?

form

5

Which of the following is true in a relational database?

Each row has a primary key and each column has a unique name.

6

Which of the following is a database that stores data in tables that consist of rows and columns?

relational

7

In a relational database, where does the only data redundancy exist?

fields

8

Compared with relational databases, which of the following is true of object-oriented databases?

all of the above

9

Which of the following is an advantage of a multidimensional database?

it can consolidate data much faster than a relational database

10

Which kind of database stores data in dimensions?

multidimensional

11

Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?

warehouse

12

In a database, what is the smallest unit of data a user accesses?

a field

13

In your school's database, in which of the following is all of the information about a particular student is stored?

a record

14

Define data redundancy.

Each department has its own files, so the same data might be stored in multiple files.

15

You are creating a database for your computer club. Most of the students live in your town, Durham. How can you make Durham appear initially in the field to make data entry easier?

make it the default value

16

While working with a database, you encounter a wizard. What best describes the purpose of a wizard?

guides you through the steps of creating a database object

17

o find all customers whose names begin with S, enter ____ in the Criteria row of the Customer Name field.

S*

18

To find all individuals whose name is Robin or Robyn, enter ____ in the Criteria row of the appropriate column.

Rob?n

19

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.

square brackets [ ]

20

To find all customers whose current due amount is greater than $1,000.00, enter ____ in the Criteria row of the Current Due column.

> 1000

21

Less than (<), greater than (>), and NOT (not equal to) are examples of ____.

comparison operators

22

To order the records in the answer to a query in a particular way, you ____ the records.

sort

23

To sort records in a query, specify the sort order in the ____ row of the design grid below the field that is the sort key.

Sort

24

To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.

Yes

25

To use the Report Wizard to create a report for a query, select the query in the Navigation Pane, tap or click ____ on the ribbon, and then tap or click the Report Wizard button.

CREATE

26

To include calculated fields in queries, enter a name for the calculated field, a(n) ____, and then the expression in one of the columns in the Field row.

colon (

27

____ help one slide flow gracefully into the next during a slide show.

Transitions

28

PowerPoint ____ should reinforce the speaker's message and help the audience retain the information presented.

slides

29

Alice is both ____ and ____.

object-oriented, event-driven

30

When you begin creating a new PowerPoint presentation, you need to select a ____

theme

31

When you open a new presentation, a slide with the default ____ layout appears.

title slide

32

The box on a slide that has a dotted or hatch-marked border and that contains the insertion point is a text ____.

placeholder

33

PowerPoint assumes every new slide, except for a blank slide, has ____.

title

34

By default, slides in a new presentation are in ____ orientation.

landscape

35

Text ____ defines the appearance and shape of letters, numbers, punctuation marks, and symbols.

font

36

When you add a new slide following the title slide, PowerPoint uses the ____ slide layout for the new slide.

title and content

37

In a multilevel bulleted list slide, creating a lower-level paragraph is called ____ the text.

demoting

38

The instructions in the language of Alice are contained on ____ which you can drag and drop into place to ____ new programs.

tiles, write

39

Alice allows you to focus on ____ instead of worrying about details of a new language.

programming concepts

40

A(n) ____ is anything that can be represented by data in the memory of a computer.

object

41

The data that represents an object is organized into a set of ____.

properties

42

The programs that manipulate the properties of an object are called the object's ____.

methods

43

The values stored in the properties of an object at any one time are called the ____ of the object.

state

44

A class of objects is a set of objects that each have the same ____.

properties and methods

45

Users interact with Alice through a(n) __

IDE

46

Which of the following is typically contained in an IDE?

A text editor, a debugger, and an object library.

47

Which of the following is typically contained in an IDE?

event trigger

48

A(n) ____ is a step-by-step process that can be clearly defined.

algorithm

49

The software development cycle has ____ phases.

four

50

In the ____ phase, each method is tested to see if it works by itself and with other methods.

test

51

In the ____ phase, the objects, methods, and initial scene are described.

design

52

In the ____ phase, the necessary objects are added to the world, and their methods coded.

implement

53

There are ____ types of software documentation

three

54

In the ____ phase of the software development cycle, developers attempt to correct mistakes.

debugging

55

Messages that appear when the program is run are intended to ____.

make the program easier to use

56

Project documentation includes ____.

all of the above

57

Developers often create a ____ to create the necessary entry conditions and capture the exit conditions.

testing shell

58

A collection of ____ together make up the components of a more complex algorithm.

methods

59

Today, branching routines are referred to as selection sequences and loops are called ____.

repetition sequences

60

Linear sequences must have ____.

complete and correct instructions in the proper order

61

There are ____ different kinds of binary branching sequences.

two

62

"Would you like vanilla ice cream?" is an example of a(n) ____ question.

binary

63

Every loop, except for a(n) ____loop that never ends, has a condition to test whether or not the body of the loop should be executed.

infinite

64

A(n) ____ is a marker or a condition that tells the computer when to stop executing a loop.

sentinel

65

A(n) ____ loop is a special type of sentinel loop in which the sentinel is a counte

count controlled

66

____ is an instruction that sets the first value of the control variable

initialization

67

____ is the instruction that looks at the control variable to see if the loop should be executed.

test

68

Before GUIs were developed, the most common interface was a(n) ____ interface.

command-driven

69

The method that is run in response to an event trigger is called an ____.

event handler

70

An event occurs when an event listener detects an ____.

event trigger

71

An event trigger can be ____.

any activity or condition selected by the programmer

72

In a(n) ____ event type, there are three places for event handlers.

BDE

73

The different events in the world appear in the ____.

events area

74

Altogether, there are ____different types of events in Alice.

nine

75

Which of the following is true of the complex event types?

They respond to specific event triggers tied to specific event handlers