Deck 15: Organizing and Manipulating the Data in Databases

Question 1

An exclamation point in the design menu of an Access query means to "run the query."

Answer 1

True

Question 2

A database subschema is a plot that can often be discovered with forensic accounting.

Answer 2

True

Question 3

A DBMS is an efficient database table in third normal form.

Answer 3

False

Question 4

An example of an input mask for an Access data field is 999\-00\-0000;;??_.

Question 5

A DBMS is a type of hardware.

Question 6

A DBMS is a type of software.

Question 7

Database designers typically store employee Social Security numbers as "Long Integer" data types.

Question 8

DML stands for "data management logic."

Question 9

SQL is an example of a database query language.

Question 10

Databases are the same thing as database management systems.

Question 11

An example of a data type for a database record field is "short text."

Question 12

Select queries are, by definition, multi-table queries.

Question 13

DDL is an acronym for "data definition language."

Question 14

If there are multiple search criteria on the criteria row of a query, this is the equivalent of an AND requirement.

Question 15

A database schema is a plan of the entire database.

Question 16

One way to create an OR condition in a query is to place the search criteria on different lines of the query.

Question 17

When purchasing a new database management system, managers should focus on the system's technological capabilities rather than its compatibility with current systems.

Question 18

A plus sign to the left of a database record in Access means there are related records linked to it.

Question 19

It is not possible to encode search criteria in more than one column of the criteria row in Access.

Question 20

Database management systems allow their users to create "input masks" which help to prevent input errors.

Question 21

Using Microsoft Access to create a select query with multiple criteria (all of which you want satisfied at the same time), you should specify them on the same Criteria line of the query.

Question 22

A delete query in Microsoft Access is an example of an action query that enables you to delete all those records in a table satisfying specific criteria.

Question 23

An update query in Microsoft Access is an example of an action query that enables you to increase the prices by ten percent for all those products starting with product code "123."

Question 24

Microsoft Access can create a well-functioning database for you using Wizards, and there is no need to understand database design or normalization.

Question 25

An append query in Microsoft Access is an example of an action query that enables you to systematically add the term "Jr." to individual names in a customer database.

Question 26

Using Microsoft Access, "referential integrity" enables you to delete a record on the "one" side of a one-to-many relationship.

Question 27

In the Relationships window, Access uses this symbol to represent the "many" side of a "one-to-many" relationship:

A)&
B)N
C)√
D)∞

Question 28

It is not possible to create queries for more than on table at a time.

Question 29

An OR operation (query)in Microsoft Access requires you to use multiple Criteria lines to create the query.

Question 30

A dynaset is the total set of records in a database table.

Question 31

All of the following are data types that you can assign to data fields when creating records in Microsoft Access except:

A)Short Text
B)Number
C)Long Text
D)Percent
E)all of these are legitimate data types

Question 32

Quotation marks that appear around a search criteria (e.g., "New York"), indicates an error.

Question 33

It is not possible to conduct multi-table queries using Microsoft Access because each table in the system is independent of the others.

Question 34

If you wish to create a select query with alternate criteria using Microsoft Access , you should specify them on separate Criteria lines of the query.

Question 35

Foreign keys are necessary in a database because every record must have a foreign key.

Question 36

A dynaset is the set of records that results from a query.

Question 37

Using Microsoft Access, you can delete a record from the "many" side of a one-to-many relationship, even if referential integrity is enforced.

Question 38

It is not necessary to spell accurately or correctly when creating queries in Microsoft Access because such matters as case or spelling are corrected automatically by the system's spell checker.

Question 39

Using Microsoft Access to create a select query with multiple criteria (all of which you want satisfied at the same time), you should specify them on separate Criteria lines of the query.

Question 40

Validation rules are useful to prevent data entry errors in databases.

Question 41

The value that a database will use if the user does not provide an alternate value is called a(n):

A)Asset value
B)Text value
C)Control value
D)Default value

Question 42

If you want to require a data entry in an Access database to fall between two dates (rather than between two numeric values):

A)You should use a select query using one line
B)You should use a select query, using two lines
C)You should use a validation rule and the word "between"
D)This is impossible to require in Access

Question 43

This is the Access tool that prohibits users from deleting parent records with child records (i.e., records related in a one-to-many relationship):

A)Referential integrity
B)Mnemonic naming
C)Integrative relationships
D)Data typing
E)none of these is correct

Question 44

To perform a range test on the hours worked data field in an Access database that requires the entry to be at least 0 and no more than 40, you should express this requirement as:

A)At least 0; Not more than 40
B)0<= X <= 40
C)Between 0 And 40
D)none of these

Question 45

The purpose of an input mask is to:

A)Disguise data when they are first input into a database
B)Transform data from alphabetic to numeric formats
C)Help users avoid data entry errors
D)Hide sensitive data such as passwords onscreen

Question 46

Database management systems can be implemented on:

A)Mainframe computers only
B)Mainframe and minicomputers only
C)Mainframes, minicomputers, and microcomputers
D)Microcomputers only

Question 47

An advantage of using a drop-down box in an Access database is that:

A)It helps users avoid input errors
B)It provides an input mask for data entries
C)It automatically screens numeric data for incorrect values
D)all of these are correct

Question 48

A "default value" for an Access data field is:

A)The value of last resort
B)A value that Access will assume if the user does not enter one
C)A value that Access will take from the last record entered into the system
D)none of these

Question 49

Which of these is most likely to represent an input mask for a telephone number in an Access database?

A)xxx-xxx-xxxx
B)abc-def-ghij
C)( _ _ _ )_ _ _ - _ _ _ _
D)none of these

Question 50

All of the following are advantages of drop-down boxes in Access except:

A)It limits users to valid input choices
B)It takes a small amount of room, even if the number of choices is large
C)It always limits users to numeric entries
D)The entries for the combo box can be stored in a separate table

Question 51

Using Microsoft Access, you create a "one-to-many" relationship between "Customers" records and "Customer Orders" records.When you view the Customers records in a datasheet view, Access indicates the presence of these customer order records using this symbol:

A)&
B)N
C)√
D)∞
E)+

Question 52

Which one of these is not a good guideline to follow when creating tables in a relational database?

A)Design first, create tables later
B)Name tables systematically, using conventional "tbl" prefixes
C)Use mnemonic names for data fields
D)Assign at least 50 characters to each text field
E)Use consistent data types for primary and foreign key fields in database tables

Question 53

The purpose of using validation tests in the record definition of a database is to:

A)Make sure the database works properly
B)Avoid data entry errors
C)Ensure normalized data
D)Verify that the user is authorized to enter data in the database

Question 54

A database developer can require Access to display records in an ascending sequence using this data field property:

A)Organize
B)Index
C)Reorganize
D)Sequencing

Question 55

You can instruct Access to display a particular error message if you use this property:

A)Validation rule
B)Validation text
C)Validation message
D)Validation error

Question 56

A database management system is:

A)A set of computer files
B)A set of one or more computer programs
C)A set of data to be processed by a computer
D)A manual accounting information system

Question 57

To perform a range test of the "hours worked" data field for an employee, you should store the term "Between 0 and 40" in which of these properties in Access?

A)Text
B)Testing procedure
C)Validation rule
D)Validation text

Question 58

Database management systems are important to accountants because:

A)They automate file storage tasks and enable managers to generate worthwhile financial reports
B)They eliminate data redundancy
C)They are unique data structures which accountants have never used before
D)They are easy to develop and therefore save money
E)They are energy efficient

Question 59

A disadvantage of database management systems is that:

A)They are not flexible
B)They cannot be implemented on microcomputers
C)They rarely support file inquiries
D)They are often machine dependent (e.g., not all DBMSs can run on all types of computers)

Question 60

An advantage of defining a default value for an Access data field is that it:

A)Assures that the data in all records will be exactly the same for that field
B)Eliminates data redundancy
C)Helps create subsequent queries on that field
D)Saves typing, and probably errors

Question 61

All of these are examples of action queries that you can create in Microsoft Access except:

A)Append query
B)Update query
C)Make table query
D)Delete query
E)Validation query

Question 62

One purpose of a data manipulation language is to:

A)Create data fields
B)Define the record structure
C)Create queries on the data
D)all of these

Question 63

A school administrator wishes to select the names of all students who live in a certain city.That city has exactly two zip codes in it.Which of these would be the best approach to use for this task?

A)Perform two separate select queries, using only one zip code for each task
B)Perform a single select query, placing the zip codes on the same Criteria line of the query
C)Perform a single select query, placing the zip codes on separate Criteria lines of the query
D)Perform a single, update query
E)none of these (this is not possible using Microsoft Access)

Question 64

This tool enables a DBMS to extract only a subset of records from a database:

A)Table
B)Query
C)Validation test
D)none of these

Question 65

Using Access, which of the following is not a recognized data type?

A)yes/no
B)Year
C)Currency
D)Date

Question 66

Sorting and Indexing database records are similar in that:

A)Neither require underlying table records
B)Both require the user to first define data validation rules
C)Both reorganize the way record data appear in outputs
D)None of these

Question 67

DML stands for:

A)Distributed management logic
B)Data management logic
C)Data management language
D)Data manipulation language

Question 68

You can increase the prices of selected products systematically using Microsoft's:

A)Append query
B)Update query
C)Make table query
D)Delete query
E)Select query

Question 69

Using Access, which of these terms is not associated with defining a data field within a record?

A)Field name
B)Data type
C)Currency value
D)Description

Question 70

To create a query that calculates the total amount for a sale, you would likely need to include the following tables in your query:

A)Customers, Employees, and Cash Receipts
B)Customers, Employees, and Sales
C)Sales, Inventory, and Cash Receipts
D)Sales, Inventory, and the relationship table Sales/Inventory

Question 71

Which of these is an example of a data query language?

A)ABC
B)SQL
C)DDL
D)JPG

Question 72

Which of these is a desirable guideline to follow when creating queries with Microsoft Access?

A)Spell accurately
B)Don't worry about capitalization
C)Join each table at least twice to ensure their connectivity
D)Name each query you create "Query"

Question 73

When Access links records to one another in different tables, the foreign key in one record refers to the _______ in another record.

A)Primary key
B)Secondary key
C)Foreign key
D)Linkage key

Question 74

In Access, a validation rule triggers at the time that:

A)The user first enters data into the database
B)The DBMS first uses the data in a report
C)The user first requests the database to test data with a menu command
D)The user powers up Access and loads that particular database

Question 75

A school administrator wishes to select the names of all students who have taken at least 130 units of credit at your university to see if they qualify for graduation.Which of these is the best type of query to use for this task?

A)Append query
B)Update query
C)Make table query
D)Select query
E)Make report query

Question 76

Sorting records is unlike indexing records in that:

A)Sorting physically rewrites records on disks whereas indexing does not
B)Sorting requires a primary key whereas indexing does not
C)Indexing requires a separate database file whereas sorting does not
D)none of these

Question 77

You could add the term "Jr." to selected names in a customer database using Microsoft's:

A)Append query
B)Update query
C)Make table query
D)Select query
E)none of these (this is not possible using an action query)

Question 78

When creating queries in Access:

A)It is necessary to include all data fields from an underlying record.
B)It is not necessary to include all data fields from an underlying record.
C)Data fields must be listed in alphabetical order.
D)Numeric fields must precede short text fields.

Question 79

In Access, the terms "size," "data type," and "input mask" are mostly closely associated with:

A)A table
B)A record
C)A data field
D)A database