Review Sheet for Test #5                                                                    Return To Main page

 

Completion

Complete each sentence or statement.

 

                  1.   Each field has a unique field ____________________ that describes its contents.

 

                  2.   A(n) ____________________-length field is like an accordion--it expands to fit the data you enter.

 

                  3.   A(n) ____________________-length field contains a predetermined number of characters.

 

                  4.   In database jargon, a(n) ____________________ is an association between data that is stored in different record types.

 

                  5.   In a(n) ____________________ database, a record type is referred to as a node or segment.

 

                  6.   A parent node can have more than one ____________________ node.

 

                  7.   A(n) ____________________ database stores data in a collection of related tables.

 

                  8.   An object ____________________ specifies the attributes and methods that are shared by all objects in a given group.

 

                  9.   The term database ____________________ refers to the arrangement of the fields, tables, and relationships in a database.

 

                  10.  From a user perspective, the data ____________________ determines the way that data can be manipulated.

 

                  11.  A database designer can assign a(n) ____________________ data type to fields containing numbers that will be manipulated mathematically by adding, averaging, multiplying, and so forth.

 

                  12.  A(n) ____________________ is a whole number.

 

                  13.  For fields that contain data that would not be used for calculations, a database designer can specify a(n) ____________________ data type, which is also referred to as a string data type.

 

                  14.  The ____________________ data type is used to store dates in a format that allows them to be manipulated.

 

                  15.  A field ____________________ helps maintain consistent data by providing a structure for entering data into a field.

 

                  16.  A lookup ____________________ validates an entry by searching for the same data in a field or database table.

 

                  17.  The goal of normalization is to minimize data ____________________.

 

                  18.  The ____________________ key for a database is typically specified by the database designer at the time the database structure is created.

 

                  19.  A(n) ____________________ routine brings data into a database.

 

                  20.  The SQL query language provides a collection of special command words called SQL ____________________, such as SELECT, FROM, INSERT, and WHERE.

 

                  21.  By Department of Defense standards, a small program is one with fewer than ____________________ lines of instructions.

 

                  22.  The ____________________ for a computer program is the set of steps that explain how to begin with the known information specified in a problem statement, and how to manipulate that information to arrive at a solution.

 

                  23.  To perform a(n) ____________________, you can use a calculator and paper and pencil to step through a sample problem using realistic test data.

 

                  24.  A program ____________________ is essentially a blueprint for a computer program.

 

                  25.  A person who codes computer programs is called a computer ____________________.

 

                  26.  Most programming languages provide three types of ____________________ structures.

 

                  27.  A subroutine, procedure, module, or ____________________ is a section of code that is part of a program, but is not included in the main sequential execution path.

 

                  28.  A selection control structure is also referred to as a(n) ____________________ structure.

 

                  29.  A repetition control structure is also referred to as a loop or ____________________.

 

                  30.  The command words FOR, DO, or WHILE mark the beginning of a(n) ____________________.

 

                  31.  Testing each section of your code to make sure that it works correctly is referred to as ____________________.

 

                  32.  Internal ____________________ explains how a program works and should be useful to other programmers who need to modify your code.

 

                  33.  ____________________ documentation contains any information about a program that might be useful to programmers, including the problem statement and algorithm.

 

                  34.  ____________________ documentation contains information that helps users learn to work with a computer program.

 

                  35.  Languages with procedural characteristics are called ____________________ languages.

 

                  36.  A(n) ____________________ language defines a task in the form of a script.

 

                  37.  When you run a program that is written in an interpreted language, the language's ____________________ reads one instruction and converts it into a machine language instruction, which the computer executes.

 

                  38.  A(n) ____________________ event is an action or occurrence, such as a key press or mouse click, to which a program might respond.

 

                  39.  A(n) ____________________ is any characteristic of a component that might describe how it appears on screen, how it responds to mouse activity, and what it does with its output.

 

                  40.  A component accepts input in the form of ____________________.

 

Matching

 

Identify the letter of the choice that best matches the phrase or definition.

a.

field

e.

data type

b.

record

f.

computed

c.

node

g.

validation

d.

attribute

h.

normalization

 

 

____          41.  A collection of data fields

 

____          42.  The column in a table, in a relational database

 

____          43.  Efficiently designed databases use this type of field whenever possible

 

____          44.  A record type, in a hierarchical database

 

____          45.  Helps create a database structure that can save storage space and increase processing efficiency

 

____          46.  Type of rule used to filter the data entered into a particular field

 

____          47.  The smallest unit of meaningful information

 

____          48.  Specifies the way data is represented on the disk and in RAM

 

Identify the letter of the choice that best matches the phrase or definition.

a.

class

e.

algorithm

b.

method

f.

pseudocode

c.

attribute

g.

function

d.

program event

h.

syntax

 

 

____          49.  Any behavior that an object is capable of performing

 

____          50.  Error type that occurs when an instruction does not follow the language's grammar

 

____          51.  The characteristic of an object

 

____          52.  A notational system for algorithms that has been described as a mixture of English and a programming language

 

____          53.  Section of code that is not included in the main sequential execution path

 

____          54.  The set of steps for carrying out a task

 

____          55.  A grouping of objects

 

____          56.  A key press is an example

 

Short Answer

 

                  57.  What happens if you enter data in a fixed-length field that is shorter than the allocated length?

 

                  58.  What is a one-to-many relationship?

 

                  59.  What is an object-oriented database?

 

                  60.  Define data dependence.

 

                  61.  Define data independence.

 

                  62.  What is a computed field?

 

                  63.  What is a report generator?

 

                  64.  What are the limitations of the global UPDATE command?

 

                  65.  Is it possible to update a group of records? What is this called?

 

                  66.  What does the JOIN command allow you to do in SQL?

 

                  67.  What is structured English?

 

                  68.  Why is the GOTO command rarely used by skilled programmers?

 

                  69.  Write a simple BASIC program that uses the FOR...NEXT command to print a message three times.

 

                  70.  What is debugging?

 

                  71.  Why is the instruction DiscountPrice = RegularPrice/0 a run-time error?

 

                  72.  What is an object-oriented language?

 

                  73.  What is a low-level language?

 

                  74.  What is an event-driven language?

 

                  75.  How do you create an event-driven program?

 

                  76.  What is component programming?

 

Essay

 

                  77.  Explain what a relational database is, defining the following terms: table, tuple, and attributes.

 

                  78.  What are the disadvantages of using custom file management software?

 

                  79.  Briefly define each of the three types of control structures.

 

                  80.  What are the advantages and disadvantages of object-oriented programming languages?


Review Sheet for Test #5

Answer Section

 

COMPLETION

 

                  1.   name

 

                  2.   variable

 

                  3.   fixed

 

                  4.   relationship

 

                  5.   hierarchical

 

                  6.   child

 

                  7.   relational

 

                  8.   class

 

                  9.   structure

 

                  10.  type

 

                  11.  numeric

 

                  12.  integer

 

                  13.  character

 

                  14.  date

 

                  15.  format

 

                  16.  routine

 

                  17.  redundancy

 

                  18.  sort

 

                  19.  import

 

                  20.  keywords

 

                  21.  100,000

 

                  22.  algorithm

 

                  23.  walkthrough

 

                  24.  specification

 

                  25.  programmer

 

                  26.  control

 

                  27.  function

 

                  28.  decision

 

                  29.  iteration

 

                  30.  loop

 

                  31.  debugging

 

                  32.  documentation

 

                  33.  Program

 

                  34.  User

 

                  35.  procedural

 

                  36.  scripting

 

                  37.  interpreter

 

                  38.  program

 

                  39.  property

 

                  40.  messages

 

MATCHING

 

            41.  B

 

            42.  D

 

            43.  F

 

            44.  C

 

            45.  H

 

            46.  G

 

            47.  A

 

            48.  E

 

            49.  B

 

            50.  H

 

            51.  C

 

            52.  F

 

            53.  G

 

            54.  E

 

            55.  A

 

            56.  D

 

SHORT ANSWER

 

                  57.  Blank spaces are automatically added to fill the field.

 

                  58.  A one-to-many relationship is when one record is related to many records.

 

                  59.  An object-oriented database stores data as objects, which can be grouped into object classes, and defined by attributes and methods.

 

                  60.  Data dependence refers to the undesirable situation in which data and program modules are so tightly interrelated that they become difficult to modify.

 

                  61.  Data indepedence means that data is stored separately from the programs that are used to manipulate the data.

 

                  62.  A computed field is a calculation that a DBMS performs during processing, and then temporarily stores in a memory location.

 

                  63.  A report generator is a software tool that provides the ability to create report templates for a database.

 

                  64.  Although the global update function is powerful, it is limited by the fact that it only works on records that have similar characteristics.

 

                  65.  SQL can perform a global update that changes the data in more than one record at a time.

 

                  66.  The SQL JOIN command allows you to temporarily join and simultaneously access the data in more than one table.

 

                  67.  Structured English is a subset of the English language with a limited selection of sentence structures that reflect processing activities.

 

                  68.  It is rarely used because injudicious use of the command makes it difficult for other programmers to understand the underlying algorithm, which in turn means that such programs are difficult to correct, improve, or revise.

 

                  69.  For N = 1 to 3

            Print "This is a message."

Next N

End

 

                  70.  Debugging is the testing of each section of your code to make sure that it works correctly, by eliminating the "bugs" so that they do not cause errors when you run the program.

 

                  71.  It is a run-time error because it tells the computer to divide by 0, which is an operation that it cannot perform.

 

                  72.  An object-oriented language is based on an approach to programming that uses objects, which are entities that the program manipulates.

 

                  73.  A low-level language requires a programmer to write instructions for the lowest level of the computer's hardware--that is, for specific hardware elements, such as the processor, registers, and RAM locations.

 

                  74.  An event-driven language helps programmers easily create programs that constantly check for and respond to a set of events.

 

                  75.  Lines of program code are attached to graphical objects, such as command buttons and icons, which the users manipulate to generate an event, which in turn causes the instructions attached to that object to be executed.

 

                  76.  Component programming is the use of components, which are pre-written objects or modules that programmers can customize and add to their own programs.

 

ESSAY

 

                  77.  A relational database stores data in a collection of related tables. Each table is a sequence, or list, of records. All of the records in a table are of the same record type. A row of the tables is called a tuple, and is equivalent to a record. The columns in the table are called attributes, and are equivalent to fields.

 

                  78.  Custom software requires skilled programers. The development time for each module can be lengthy and costly. In addition, programmer efforts are sometimes redundant because similar modules are often required for different data files. Also, poorly designed custom software can result in data dependence (the tight interrelation of data and program modules so that they become difficult to modify).

 

                  79.  Sequence control structures change the sequence/order in which instructions are executed by directing the computer to execute an instruction elsewhere in the program. Selection control structures tell a computer what to do, based on whether a condition is true or false. Repetition control structures repeat one or more instructions until a certain condition is met.

 

                  80.  These languages help programmers create programs with a clear modular structure, containing objects that can be easily modified and reused. In addition, most experts agree that the object-oriented approach to software engineering reduces overall development time. The downside to object-oriented languages is that they tend to require slightly more execution time than procedural languages.