Calibración del escáner:

Demystified / Databases Demystified / Oppel/ 225364-9 / Chapter 3

c. Can never be recursive relationships d. Are inherited in queries as table joins

e. Can be one-to-many, one-to-one, or many-to-many 5. The Microsoft Access Show Table dialog box:

a. Lists all tables in the database and allows for the metadata about tables to be added, changed, and deleted

b. Lists only tables stored in the database

c. Lists tables and/or queries stored in the database d. Lists only queries stored the database

e. Provides the ability to show (display) or hide (not display) tables 6. A column in the results of a Microsoft Access query can be formed from:

a. A table column b. A view column c. A constant d. A calculation

e. Anything for which a formula may be composed

7. When a query with no criteria included is executed, the result is a. An error message

b. No rows being displayed

c. All the rows in the table being displayed d. A Cartesian product

e. None of the above

8. When sequencing (sorting) of rows is not included in a database query, the rows returned by the query are in:

a. No particular sequence

b. The order in which the rows were added to the table(s) c. Primary key sequence

d. Ascending sequence by the first column in the results e. Ascending sequence by the first index on the table(s)

9. In a query, the search criteria REGION NOT = “CA” OR REGION NOT = “NV” will display

a. An error message b. All the rows in the table

c. Only the rows where Region is equal to “CA” or “NV”

d. All the rows in the table except those where the Region is “CA” or “NV”

e. No rows

Color profile: Generic CMYK printer profile Composite Default screen

10. Criteria in a Microsoft Access query are

a. Connected with a logical AND if they are on the same line b. Connected with a logical OR if they are on the same line

c. Connected with a logical AND if they are in the same field’s column d. Connected with a logical OR if they are in the same field’s column e. Connect by a logical AND within the same row and each line’s criteria

is connected with the other lines using a logical OR

11. The join connector between tables in a Microsoft Access query:

a. May be manually created by dragging a column from one table or view to a column of another table or view

b. May be inherited from the metadata defined on the Relationships panel c. May be altered to define left, right, and full outer joins

d. Can cause a Cartesian product if defined incorrectly

e. Will cause a Cartesian product if not defined between two tables or views in the query

12. When an outer join is used, column data from tables (or views) where no matching rows were found:

a. Displays as zero for numeric column types b. Displays as blank for character column types c. Displays in gray

d. Displays the text “NULL” e. Is set to the NULL value 13. An aggregate function:

a. Combines data from multiple columns together b. Combines data from multiple rows together

c. May be applied to table columns but not to calculated columns d. Is a special type of database query function

e. Requires that every column in a query be either an aggregate function or named in the GROUP BY list for the query

14. Common aggregate functions include a. AVG b. COUNT c. ROUND d. SUM e. MIX 15. Self-joins:

a. Can never produce a Cartesian product because the two data sources come from the same table

b. Always produce a Cartesian product

CHAPTER 3

Forms-Based Database Queries

87

Color profile: Generic CMYK printer profile Composite Default screen

c. Are a method of resolving a recursive relationship d. Is the name given to any join that is manually created in

Microsoft Access

e. Involve joining a table to itself

16. The column name of a calculated column in the query results: a. Is NULL if not provided in the query definition

b. Is automatically assigned by Microsoft Access if not provided in the query definition

c. Is the first column name used in the formula if not provided in the query definition

d. May be supplied using a label that appears first in the field definition e. May be supplied using a label that appears last in the field definition 17. Tables may be joined:

a. Using only the primary key in one table and a foreign key in another b. Using any column in either table (theoretically)

c. Only to themselves d. Only to other tables

e. Only using the Cartesian product formula 18. Microsoft Access queries:

a. Are calledviewsin most other relational databases b. Are calledentitiesin most other relational databases c. May be stored in the database for subsequent reuse

d. Are highly flexible commands for retrieval of database data e. Provide a way to generate SQL statements

19. When a column is deleted from a Microsoft Access query: a. The column is only removed from the current query. b. The column is removed from all queries that reference it.

c. The column is removed from the table and all queries that reference it. d. An error message is displayed if the column is used in any other queries. e. The column remains in the query but is marked so the column data will

not be displayed in the query results. 20. A Cartesian product:

a. Results when a join between two tables in a query is not defined

b. Results when a join between two tables in a query is incorrectly defined c. Results whenever a table is joined to itself

d. Results when each row in one table is joined to every row in another e. Can never happen in a Microsoft Access query

88

Databases Demystified

Color profile: Generic CMYK printer profile Composite Default screen

CHAPTER

4

Introduction