Homework answers / question archive / Chapter 18: Maintaining and Querying a Database   TRUE/FALSE        1)   The deletion of a record is permanent and cannot be undone

Chapter 18: Maintaining and Querying a Database   TRUE/FALSE        1)   The deletion of a record is permanent and cannot be undone

Computer Science

Share With

---

 

TRUE/FALSE

 

     1)   The deletion of a record is permanent and cannot be undone.

 

 

     2.   The design grid in a Query window contains the fields in the table or query used to create the query.

 

 

     3.   Hiding a field’s values in query results does not remove the field from the query design.

 

 

     4.   When sorting, the pivot field is the field used to determine the order of records in the datasheet.

 

 

     5.   A filter is a set of restrictions you place on the records in a datasheet or form to temporarily isolate a subset of the records.

 

 

     6.   In a one-to-many relationship, the primary table is the “one” table, and the related table is the “many” table.

 

 

     7.   You navigate and update an open subdatasheet the same way as a table datasheet.

 

 

     8.   Use the Both logical operator when you want a record selected only if all of the specified conditions are met.

 

 

     9.   Unless you are expert in creating expressions for calculated fields, you should avoid using Expression Builder.

 

 

   10.   The AutoSort operator divides the selected records from a query into groups based on values in the specified field.

 

 

MODIFIED TRUE/FALSE

 

     1.   The Esc key is a toggle that you use to switch between navigation mode and editing mode.

 

 

     2.   QED retrieves the information that precisely matches the example you provide of the information being requested.

 

 

     3.   A(n) select query is a query in which you specify the fields and records you want Access to select.

 

 

     4.   Sorting is the process of rearranging records in a specified order or sequence.

 

 

     5.   To sort fields in nonadjacent columns, you must specify the sort fields in Datasheet view.

 

 

     6.   You use a(n) common field to relate one table to another.

 

 

     7.   To create a multitable query, the tables must have a common primary key.

 

 

 

     8.   The join line in the figure above indicates a(n) one-to-one relationship between the tables.

 

 

     9.   Use the Or logical operator when you want a record selected if at least one of the specified conditions is met.

 

 

   10.   A(n) allocated field displays the results of an expression.

 

 

MULTIPLE CHOICE

 

     1.   You use ____ to navigate a datasheet.

a.	the F2 key	c.	navigation buttons
b.	keystroke combinations	d.	any of the above

 

 

     2.   You use the ____ dialog box to locate a specific field value in a table, query, datasheet, or form.

a.	Search	c.	Find and Replace
b.	Fields	d.	Help

 

 

     3.   Before you delete a record, you must ____.

a.	compact the database
b.	perform an entity integrity check
c.	select the entire row for the record in the datasheet
d.	all of the above

 

 

     4.   After deleting a record with an AutoNumber field, ____.

a.	there may be gaps in the numbers used for the field values
b.	you must re-sort the database on the AutoNumber field
c.	you must run an entity integrity check
d.	AutoNumbering will be turned off until you restore it

 

 

 

     5.   You work with a query in the ____ window.

a.	Layout	c.	Design
b.	Query	d.	Interact & Navigate

 

 

 

     6.   The bottom portion of the Query window contains the ____.

a.	field list	c.	QBE drop-down list
b.	design grid	d.	record sorter

 

 

 

     7.   The result of a query is referred to as a(n) ____.

a.	minisheet	c.	intra-list
b.	subdatasheet	d.	recordset

 

 

 

     8.   All of the following are true of a query datasheet EXCEPT ____.

a.	it shows the permanent data in a table
b.	it resembles a table datasheet
c.	its contents are based on the criteria set in the query design grid
d.	it can display selected fields from a table in the order you specify

 

 

 

     9.   The answer to a select query is returned in a query ____.

a.	window	c.	datasheet
b.	grid	d.	report

 

 

 

   10.   To transfer all the fields from the query field list to the design grid at once, ____.

a.	double-click the asterisk at the top of the field list
b.	select a field in the list, then press the Tab key
c.	click and drag the last field in the list to the design grid
d.	right-click a field in the list, then click “Transfer All”

 

 

 

   11.   If the results of a query are not what you expected or require, you can ____.

a.	remove fields from the query
b.	change the order in which fields appear in query results
c.	hide a field’s values in query results
d.	all of the above

 

 

 

   12.   To select a field in the design grid, click ____.

a.	the center of the field	c.	the thin bar above a column
b.	the asterisk in the field list	d.	the padlock icon to the right of the field

 

 

   13.   The figure above shows ____.

a.	the query datasheet	c.	the field list
b.	the design grid	d.	the QBE

 

 

   14.   In the figure above, box ____ denotes the field that is being moved.

a.	A	c.	D
b.	C	d.	E

 

 

   15.   In the figure above, the ____ field will NOT appear in query results.

a.	CustomerID	c.	City
b.	FirstName	d.	none of the above

 

 

 

   16.   To sort records, you must select the ____ field.

a.	sort	c.	first
b.	primary key	d.	query

 

 

 

   17.   In Datasheet view, when you click the arrow to the right of a column heading, the ____ menu opens.

a.	Query	c.	AutoFilter
b.	Find & Replace	d.	Sort Type

 

 

 

   18.   All of the following may be Sort fields EXCEPT ____.

a.	Hyperlink	c.	Currency
b.	Yes/No	d.	AutoNumber

 

 

 

   19.   In ____ view, the sort fields must be in adjacent columns in the datasheet, and you can specify only one type of sort for the selected columns.

a.	Design	c.	Datasheet
b.	Filter	d.	Layout

 

 

 

   20.   All of the following are true of filters EXCEPT ____.

a.	they let you temporarily isolate a subset of records
b.	they let you focus on only the data you need
c.	a filtered datasheet has the word Filtered on the status bar
d.	an object cannot be saved with a filter applied

 

 

 

   21.   You use a(n) ____ to relate one table to another.

a.	common field	c.	foreign key
b.	primary key	d.	AutoLink

 

 

 

   22.   A one-to-many relationship exists between two tables when one record in the first table matches ____ in the second table, and when each record in the second table matches at most one record in the first table.

a.	zero records	c.	several records
b.	one record	d.	any of the above

 

 

 

   23.   The ____ table is the “one” table in a one-to-many relationship.

a.	common	c.	secondary
b.	related	d.	primary

 

 

 

   24.   The ____ table is the “many” table in a one-to-many relationship.

a.	common	c.	secondary
b.	related	d.	primary

 

 

 

   25.   ____ is a set of rules to maintain consistency between related tables when data in a database is updated.

a.	Entity alignment	c.	Referential integrity
b.	QBE	d.	Orphanation

 

 

 

   26.   When no matching record already exists in the primary table, placing a record in a related table causes ____.

a.	referential disintegration	c.	broken relations
b.	orphaned records	d.	widowed links

 

 

 

   27.   After defining a relationship between tables, the “one” table in the one-to-many relationship contains a ____ for each record, which is collapsed until you expand it.

a.	subdatasheet	c.	query report
b.	link	d.	multitable query

 

 

 

   28.   The one-to-many relationship between two tables is shown in the Query window with a ____, just as in the Relationships window.

a.	translucent overlay	c.	join line
b.	hyperlink	d.	chain and lock icon

 

 

 

   29.   A join line with ____ indicates that the relationship is set to enforce referential integrity.

a.	a padlock icon	c.	a dotted line
b.	two infinity symbols	d.	thick ends

 

 

 

   30.   You can refine a query to display only selected records by specifying a(n) ____ as part of the query.

a.	condition	c.	priority
b.	relation	d.	expression

 

 

 

   31.   You use ____ to combine two or more conditions in a query.

a.	parentheses	c.	expressions
b.	logical operators	d.	targeted queries

 

 

 

   32.   To create a query with the ____ operator, you specify all of the conditions in the same Criteria row of the design grid.

a.	Equals	c.	Not
b.	Or	d.	And

 

 

 

   33.   With the And operator, you ____ the results of a query; with the Or operator, you ____ the results of a query.

a.	narrow, broaden	c.	broaden, narrow
b.	narrow, maintain	d.	broaden, broaden

 

 

 

   34.   A(n) ____ field displays the results of an expression.

a.	iterated	c.	calculated
b.	filtered	d.	sorted

 

 

 

   35.   In Access, calculations are performed ____.

a.	right to left	c.	using the standard order of precedence
b.	in DBMS Sort order	d.	from initial field to final field

 

 

 

   36.   ____ is an Access tool that makes it easy for you to create an expression.

a.	QBE	c.	MS Express
b.	Expression Builder	d.	The Formulator

 

 

 

   37.   The Calculated Field data type is available only for tables in ____ view.

a.	Query	c.	Layout
b.	Datasheet	d.	Design

 

 

 

   38.   You add a Total row by clicking the ____ button in the ____ group on the Home tab.

a.	Sum, Function	c.	Functions, Expressions
b.	Total, Function	d.	Totals, Records

 

 

 

   39.   If you use the Maximum function on the SalesQ4 field in a query, the resulting query datasheet will give the default column name ____.

a.	Max-SalesQ4	c.	MaxOfSalesQ4
b.	MaximumSal	d.	SalesQ4MAXIMUM

 

 

 

   40.   The ____ operator divides the selected records into groups based on the values in the specified field.

a.	Group By	c.	Sort Select
b.	Filter On	d.	Amass

 

 

 

Case-Based Critical Thinking Questions

 

Case 18-1

For each of the following questions, choose the answer that represents how the fields would be sorted given the kind of sort chosen.

 

   41.   Last Name       | First Name

Jacobson            Marvin

Jacobs                Marvin

Jenkins              Marc

 

Ascending sort on Last Name

 

a.	Jacobs              Marvin Jacobson          Marvin Jenkins            Marc	c.	Jenkins            Marc Jacobson          Marvin Jacobs              Marvin
b.	Jacobson          Marvin Jacobs              Marvin Jenkins            Marc	d.	Jacobs              Marc Jacobson          Marvin Jenkins            Marvin

 

 

 

   42.   Last Name       | First Name

Jacobson            Marvin

Jacobs                Marvin

Jenkins              Marc

 

Descending sort on Last Name

 

a.	Jacobs              Marvin Jacobson          Marvin Jenkins            Marc	c.	Jenkins            Marc Jacobson          Marvin Jacobs              Marvin
b.	Jacobson          Marvin Jacobs              Marvin Jenkins            Marc	d.	Jacobs              Marc Jacobson          Marvin Jenkins            Marvin

 

 

 

   43.   ID        |  Price

3            $5.00

17          $12.75

5            $18.00

1            $0.00

 

Ascending on ID

 

a.	1          $5.00 3          $12.75 5          $18.00 17        $0.00	c.	1          $0.00 3          $5.00 5          $18.00 17        $12.75
b.	1          $0.00 3          $5.00 5          $18.00 17        $12.75	d.	5          $18.00 17        $12.75 3          $5.00 1          $0.00

 

 

 

   44.   ID        |  Price

3            $5.00

17          $12.75

5            $18.00

1            $0.00

 

Descending on Price

 

a.	1          $5.00 3          $12.75 5          $18.00 17        $0.00	c.	1          $0.00 3          $5.00 5          $18.00 17        $12.75
b.	1          $0.00 3          $5.00 5          $18.00 17        $12.75	d.	5          $18.00 17        $12.75 3          $5.00 1          $0.00

 

 

 

   45.   ID        |  Price

3            $5.00

17          $12.75

5            $18.00

1            $0.00

 

Descending on ID

 

a.	17        $12.75 5          $18.00 3          $5.00 1          $0.00	c.	1          $0.00 3          $5.00 5          $18.00 17        $12.75
b.	1          $0.00 3          $5.00 5          $18.00 17        $12.75	d.	5          $18.00 17        $12.75 3          $5.00 1          $0.00

 

 

 

Case-Based Critical Thinking Questions

 

Case 18-2

 

Answer the following questions based only on the figure shown below. (Don’t let your recollections from the chapter influence how you answer.)

 

 

 

 

   46.   The figure above shows ____.

a.	the table datasheet view	c.	the Query window field list
b.	the Query window design grid	d.	the query datasheet view

 

 

 

   47.   Which of the following is known to be TRUE from the figure above?

a.	This is going to be a multitable query.
b.	FirstName is the primary key of the Customer table.
c.	Customer and Contract are in a one-to-one relationship.
d.	ContractID is the common field.

 

 

   48.   What obvious problem with the figure above will keep it from working properly?

a.	All of the fields are being shown.
b.	There is no obvious connection between the Customer and Contract tables.
c.	There is only one condition; there must be at least two.
d.	None of the above poses a problem.

 

 

   49.   You know that the Contract table is the ____.

a.	primary table
b.	related table
c.	secondary table
d.	none of the above; you don’t know the relation just from this figure

 

 

   50.   Given the condition, you know that this query uses a(n) ____ operator.

a.	Or	c.	Not
b.	And	d.	none of the above

 

 

 

COMPLETION

 

     1.   The ____________________ dialog box lets you locate a specific field value in a table, query datasheet, or form.

 

     2.   In Design view, you specify the data you want to view by constructing a query by ____________________.

 

 

     3.   The result of a query is referred to as a(n) ____________________.

 

     4.   The answer to a select query is returned in a query ____________________.

 

     5.   ____________________ is the process of rearranging records in a specified order or sequence.

 

     6.   When you use a(n) ____________________ sort field, records with the same sort field value are grouped together, but are not sorted in a specific order within the group.

 

     7.   The restrictions placed by a(n) ____________________ on the records in a datasheet will temporarily isolate a subset of those records.

 

     8.   The two tables that form a relationship are called the ____________________ and ____________________ tables.

 

     9.   ____________________ records are those that appear in a related table but have no matching record that exists in the primary table.

 

   10.   After you create a relation, when you open the primary table, the ____________________ for each record in the primary table is collapsed until you expand it.

 

   11.   A one-to-many relationship shown in the Query window will have a number 1 on the “one” side, and a(n) ____________________ on the “many” side.

 

   12.   A condition is a(n) ____________________, or rule, that determines which records are selected.

 

   13.   ____________________ is the Access “not equal to” operator.

 

   14.   Unlike a Field box, the Zoom box and ____________________ are large enough to display longer expressions that you are creating.

 

   15.   To quickly perform a calculation using a function in a query datasheet, you can add a(n) ____________________ row at the bottom of the datasheet.

 

MATCHING

 

 

a.	field list	g.	design grid
b.	F2	h.	referential integrity
c.	filter	i.	sorting
d.	subdatasheet	j.	And
e.	Group By	k.	calculated field
f.	QBE	l.	join line

 

 

     1.   displays the results of an expression

 

     2.   shows a relationship between tables in a Query window

 

     3.   retrieves information precisely matching the example you provide

 

     4.   the bottom portion of a Query window

 

     5.   rearranging records in a specified order or sequence

 

     6.   maintaining consistency between related tables when data is updated

 

     7.   a logical operator

 

     8.   a set of restrictions that temporarily isolates a subset of records

 

     9.   used to navigate a datasheet and select field values

 

   10.   displays, in a primary table, records from the related table

 

   11.   an operator that divides selected records based on values in a specified field

 

   12.   the top portion of the Query window

 

ESSAY

 

     1.   What is referential integrity? Discuss the three rules for maintaining it.

 

     2.   Name and briefly discuss the three reasons database experts caution against storing calculations in a table.

 

 

     3.   Briefly explain how to use the Query window design grid to create a query with an And logical operator, and then a query with an Or logical operator. What will each kind of query display for its results?