Deck 4: Organizing and Manipulating the Data in Databases

Question 1

A useful guideline to follow when creating data fields containing text is to assign at least 50 characters to it.

Answer 1

False

Question 2

It is not possible to save a table in Microsoft Access unless you also identify a primary record key.

Answer 2

False

Question 3

Microsoft Access is an example of a database,not a database management system.

Answer 3

False

Question 4

The conventional prefix for the name of a table is "tbl."

Question 5

Microsoft Access is an example of a database management system,not a database.

Question 6

To create a relationship between two tables in Microsoft Access,you should use the Relationships window.

Question 7

The inability to delete a parent record if it has subordinate or "child records" in a relational database is enforced by using "Referential Integrity" in Microsoft Access.

Question 8

A good primary record key to use for a table of employee records that you might create in Access is the employee's last name.

Question 9

A template that you can create in Microsoft Access and that prompts users for expected values is called a "mask."

Question 10

Microsoft Access uses a key symbol to identify the primary record key in a database table.

Question 11

DDL is an acronym for "data definition language."

Question 12

The inability to delete a parent record if it has subordinate or "child records" in a relational database is enforced by using "Parental Hierarchy" in Microsoft Access.

Question 13

Databases are the same thing as database management systems.

Question 14

An example of a data type for a data field in the record of an Access table is "Number."

Question 15

The guideline recommending that you create "mnemonic names for data fields" means that you should name data fields that rhyme with their data types.

Question 16

An example of a data type for a data field in the record of an Access table is "Text."

Question 17

A DBMS is a type of hardware.

Question 18

To create a relationship between two tables in Microsoft Access,you should use the Queries window.

Question 19

A useful guideline to follow when creating data fields containing text is to limit data fields to reasonable lengths.

Question 20

A DBMS is a type of software.

Question 21

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

Question 22

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 23

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

Question 24

Multimedia databases have rendered traditional text databases useless.

Question 25

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

Question 26

Data warehouses are only used for analyzing current accounting data.

Question 27

An example of an input mask for an Access data field is "000\-00\-0000."

Question 28

If creating a data mart is not cost effective,management should consider creating a data warehouse,which typically uses less money and time to design.

Question 29

SQL is an example of a database query language.

Question 30

Pivot tables are powerful statistical tools,but allow the user little flexibility in selecting what data can be analyzed.

Question 31

OLAP is notable for its "drill-down capability."

Question 32

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

Question 33

Object-oriented databases are used to archive older data that management no longer needs to process.

Question 34

It is not necessary for data to be "clean" or accurate if they are stored in a data warehouse.

Question 35

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

Question 36

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

Question 37

A database schema is a plan of the entire database.

Question 38

Online analytical processing enables a computer system to display information that must be computed from the data stored in a database.

Question 39

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

Question 40

DML stands for "data management logic."

Question 41

Database management systems are important to accountants because:

A)They automate file storage tasks and enable accountants 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 42

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

Question 43

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

Question 44

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 45

_________ is an 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 46

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 47

Using Microsoft Access to create a select query with

Question 48

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

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

Question 49

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

Question 50

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 51

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 52

The proper prefix to use when naming a table in Microsoft Access is:

A)tab
B)table
C)tbl
D)tb
E)none of these

Question 53

Using Microsoft Access to create a select query with

Question 54

Microsoft uses this symbol to represent the "many" side of a "one-to-many" relationship:

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

Question 55

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 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

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

Question 58

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 59

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 60

An OR operation (query)in Microsoft Access requires you to use

Question 61

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 62

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 63

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 64

DML stands for:

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

Question 65

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 66

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 67

Which 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 68

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 69

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 70

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 71

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 72

At the time that a user starts to input data into a database,an "input mask" for a telephone number in an Access database might look like:

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

Question 73

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 74

Which of these terms is synonymous with the term "combo box?"

A)Collection box
B)Textbox
C)Criteria line
D)Drop-down box

Question 75

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

A)The user enters a value that falls outside the allowable range
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 76

If you 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 77

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 78

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 79

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 80

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