Which of the following is true in a relational database?

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

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

relational

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

fields

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

all of the above

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

it can consolidate data much faster than a relational database

Which kind of database stores data in dimensions?

multidimensional

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

warehouse

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

a field

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

a record

Define data redundancy.

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

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

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

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

S*

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

Rob?n

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 [ ]

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

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

comparison operators

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

sort

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

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

Yes

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

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 (

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

Transitions

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

slides

Alice is both ____ and ____.

object-oriented, event-driven

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

theme

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

title slide

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

placeholder

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

title

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

landscape

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

font

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

title and content

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

demoting

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

tiles, write

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

programming concepts

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

object

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

properties

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

methods

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

state

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

properties and methods

Users interact with Alice through a(n) __

IDE

Which of the following is typically contained in an IDE?

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

Which of the following is typically contained in an IDE?

event trigger

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

algorithm

The software development cycle has ____ phases.

four

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

test

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

design

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

implement

There are ____ types of software documentation

three

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

debugging

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

make the program easier to use

Project documentation includes ____.

all of the above

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

testing shell

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

methods

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

repetition sequences

Linear sequences must have ____.

complete and correct instructions in the proper order

There are ____ different kinds of binary branching sequences.

two

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

binary

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

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

sentinel

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

count controlled

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

initialization

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

test

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

command-driven

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

event handler

An event occurs when an event listener detects an ____.

event trigger

An event trigger can be ____.

any activity or condition selected by the programmer

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

BDE

The different events in the world appear in the ____.

events area

Altogether, there are ____different types of events in Alice.

nine

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

They respond to specific event triggers tied to specific event handlers