final exam
database
Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?
query
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?
form
Which of the following is a window on the screen that provides areas for entering or changing data in a database?
Each row has a primary key and each column has a unique name.
Which of the following is true in a relational database?
relational
Which of the following is a database that stores data in tables that consist of rows and columns?
fields
In a relational database, where does the only data redundancy exist?
all of the above
Compared with relational databases, which of the following is true of object-oriented databases?
it can consolidate data much faster than a relational database
Which of the following is an advantage of a multidimensional database?
multidimensional
Which kind of database stores data in dimensions?
warehouse
Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?
a field
In a database, what is the smallest unit of data a user accesses?
a record
In your school's database, in which of the following is all of the information about a particular student is stored?
Each department has its own files, so the same data might be stored in multiple files.
Define data redundancy.
make it the default value
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?
guides you through the steps of creating a database object
While working with a database, you encounter a wizard. What best describes the purpose of a wizard?
S*
o find all customers whose names begin with S, enter ____ in the Criteria row of the Customer Name field.
Rob?n
To find all individuals whose name is Robin or Robyn, enter ____ in the Criteria row of the appropriate column.
square brackets [ ]
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 ____.
> 1000
To find all customers whose current due amount is greater than $1,000.00, enter ____ in the Criteria row of the Current Due column.
comparison operators
Less than (<), greater than (>), and NOT (not equal to) are examples of ____.
sort
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.
Yes
To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.
CREATE
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.
colon (
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.
Transitions
____ help one slide flow gracefully into the next during a slide show.
slides
PowerPoint ____ should reinforce the speaker's message and help the audience retain the information presented.
object-oriented, event-driven
Alice is both ____ and ____.
theme
When you begin creating a new PowerPoint presentation, you need to select a ____
title slide
When you open a new presentation, a slide with the default ____ layout appears.
placeholder
The box on a slide that has a dotted or hatch-marked border and that contains the insertion point is a text ____.
title
PowerPoint assumes every new slide, except for a blank slide, has ____.
landscape
By default, slides in a new presentation are in ____ orientation.
font
Text ____ defines the appearance and shape of letters, numbers, punctuation marks, and symbols.
title and content
When you add a new slide following the title slide, PowerPoint uses the ____ slide layout for the new slide.
demoting
In a multilevel bulleted list slide, creating a lower-level paragraph is called ____ the text.
tiles, write
The instructions in the language of Alice are contained on ____ which you can drag and drop into place to ____ new programs.
programming concepts
Alice allows you to focus on ____ instead of worrying about details of a new language.
object
A(n) ____ is anything that can be represented by data in the memory of a computer.
properties
The data that represents an object is organized into a set of ____.
methods
The programs that manipulate the properties of an object are called the object's ____.
state
The values stored in the properties of an object at any one time are called the ____ of the object.
properties and methods
A class of objects is a set of objects that each have the same ____.
IDE
Users interact with Alice through a(n) __
A text editor, a debugger, and an object library.
Which of the following is typically contained in an IDE?
event trigger
Which of the following is typically contained in an IDE?
algorithm
A(n) ____ is a step-by-step process that can be clearly defined.
four
The software development cycle has ____ phases.
test
In the ____ phase, each method is tested to see if it works by itself and with other methods.
design
In the ____ phase, the objects, methods, and initial scene are described.
implement
In the ____ phase, the necessary objects are added to the world, and their methods coded.
three
There are ____ types of software documentation
debugging
In the ____ phase of the software development cycle, developers attempt to correct mistakes.
make the program easier to use
Messages that appear when the program is run are intended to ____.
all of the above
Project documentation includes ____.
testing shell
Developers often create a ____ to create the necessary entry conditions and capture the exit conditions.
methods
A collection of ____ together make up the components of a more complex algorithm.
repetition sequences
Today, branching routines are referred to as selection sequences and loops are called ____.
complete and correct instructions in the proper order
Linear sequences must have ____.
two
There are ____ different kinds of binary branching sequences.
binary
"Would you like vanilla ice cream?" is an example of a(n) ____ question.
infinite
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.
sentinel
A(n) ____ is a marker or a condition that tells the computer when to stop executing a loop.
count controlled
A(n) ____ loop is a special type of sentinel loop in which the sentinel is a counte
initialization
____ is an instruction that sets the first value of the control variable
test
____ is the instruction that looks at the control variable to see if the loop should be executed.
command-driven
Before GUIs were developed, the most common interface was a(n) ____ interface.
event handler
The method that is run in response to an event trigger is called an ____.
event trigger
An event occurs when an event listener detects an ____.
any activity or condition selected by the programmer
An event trigger can be ____.
BDE
In a(n) ____ event type, there are three places for event handlers.
events area
The different events in the world appear in the ____.
nine
Altogether, there are ____different types of events in Alice.
They respond to specific event triggers tied to specific event handlers
Which of the following is true of the complex event types?