Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?
database
Which of the following is a request for specific data from a database?
query
Which of the following languages consists of simple, English-like statements that allow users to specify the data to display, print, or store?
query
Which of the following is a window on the screen that provides areas for entering or changing data in a database?
form
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