Deck 12: Accessing Databases

Question 1

Real-time locating systems are similar to baby monitors.

Answer 1

True

Question 2

To triangulate its location from a tower, a cellular device has to be turned on.

Answer 2

True

Question 3

The accuracy of real-time locating systems depends on the number of nearby towers and the coverage area.

Answer 3

False

Question 4

As a rule of thumb, spreadsheet software can handle any data that you could put on a set of cards in a card file.

Question 5

Web apps , such as Zoho Creator, are available for creating online databases.

Question 6

When you use a browser to access databases on the Web, you'll typically enter a query using a spreadsheet form.

Question 7

RFID is location aware, and its main capability is transmitting identification information.

Question 8

Unauthorized access is a potential problem with GPS tags.

Question 9

The data type field specifies the database fields and their characteristics.

Question 10

The term "database" means a collection of data.

Question 11

With real-time locating systems, a(n) tracking device worn by the trackee transmits signals to a nearby base station using radio waves.

Question 12

Database software is also referred to as a database management system (DBMS).

Question 13

A process called filtering is useful for creating reports that show only selected data.

Question 14

A GPS device needs to lock on to four satellites to determine a location.

Question 15

A CD containing back issues of TIME magazine would be an example of a free-form spreadsheet .

Question 16

A cellular device can determine its approximate distance from the tower by transmitting a long signal and gauging the time for a response.

Question 17

When you see a(n) colon in a URL, your browser is displaying the results of a database query.

Question 18

You may have to specify the file structure for each field, which indicates whether it will hold text, numbers, dates, or graphics.

Question 19

A group of similarly structured records can be stored in a(n) field .

Question 20

A structured database makes it easy to locate records using a report.

Question 21

Most database software is ____ sensitive.

A) case
B) file
C) field
D) record

Question 22

A ____ contains fields of information about a single entity in the database.

A) character
B) database
C) field
D) record

Question 23

Database software is sometimes referred to as a database ____.

A) management system
B) information system
C) management organizer
D) information organizer

Question 24

You cannot use most ____ software to join files or tables together and create a relational database.

A) spreadsheet
B) database
C) desktop publishing
D) word processing

Question 25

When working with Microsoft Excel, use the ____ button located on the DATA tab to arrange the data in a worksheet according to the contents of any field.

A) Edit
B) Sort
C) Search
D) Report

Question 26

The ____ for each field indicates whether it will hold text, numbers, dates, or graphics.

A) data type
B) field type
C) file type
D) character type

Question 27

An HTML ____ form might simply consist of a single text box where you can enter one or more keywords.

A) filter
B) query
C) question
D) information

Question 28

Once you have created the file structure, your database software displays it as a blank ____ that you can use to fill in the data for each field.

A) table
B) field
C) database
D) file

Question 29

A ____ contains a single piece of information, such as a name, birth date, or zip code.

A) character
B) field
C) file
D) record

Question 30

Which type of software provides a set of tools to enter and update information in fields, delete records, sort records, search for records that meet specified criteria, and create reports?

A) database
B) word processing
C) accounting
D) desktop publishing

Question 31

A specification for the database fields and their characteristics is the ____.

A) design
B) files
C) file structure
D) data type

Question 32

Which of the following is an example of a structured database?

A) phone book
B) letter
C) financial budget
D) payroll report

Question 33

A group of similarly structured records can be stored in a ____.

A) record
B) spreadsheet
C) field
D) file

Question 34

A process called ____ is useful for creating reports that show only selected data.

A) filtering
B) sifting
C) sorting
D) finding

Question 35

____ software is useful primarily to create and maintain your own database.

A) Web app
B) Database
C) Online
D) Spreadsheet

Question 36

Spreadsheet software typically has special data-handling features that allow you to manipulate the rows and columns of a worksheet as if they were ____ and fields in a database.

A) files
B) records
C) characters
D) categories

Question 37

Which of the following is NOT an example of a field name?

A) Description
B) Purchase Date
C) Sam Jones
D) Value

Question 38

A ____ allows you to store information in two or more different types of records and form a link between them.

A) file
B) spreadsheet
C) database
D) relational database

Question 39

Which of the following provides a wealth of data management capabilities, but requires a substantial learning commitment?

A) LibreOffice Base
B) MySQL
C) FileMaker Pro
D) MyDatabase

Question 40

A structured database makes it easy to locate records using a ____.

A) sort
B) query
C) find
D) locate

Question 41

When you use a browser to access databases on the Web, you'll typically enter a query using a(n) ____ form.

A) database
B) HTML
C) XML
D) spreadsheet

Question 42

In a situation where a cellular device is within range of more than one tower, accuracy ____ dramatically.

A) stabilizes
B) increases
C) decreases
D) none of the above

Question 43

In the accompanying figure, the feature indicated by item 2 enables you to ____.

A) search through records
B) display the tables in the database that hold records that contain data
C) organize and display data in an effective way
D) define a way of displaying the data in each record

Question 44

RFID technology's main use is to ____, rather than geolocate.

A) identify
B) locate
C) track
D) find

Question 45

Consumer-level GPS devices are accurate to about ____ feet.

A) 20
B) 30
C) 40
D) 50

Question 46

In the accompanying figure, item 4 ____.

A) holds the records that contain data
B) searches through the records
C) defines a way of displaying the data in each record
D) organizes and displays data in an effective way

Question 47

____ tracks the position of a cellular device based on its distance from cell towers.

A) Real-time locating systems
B) Mobile locating
C) Radio
D) RFID

Question 48

The data that you entered into a ____ is collected by a program that runs on the Web site's server.

A) form
B) table
C) database
D) row

Question 49

Signals transmitted by GPS satellites can pass through all of the following except ____.

A) buildings
B) clouds
C) plastic
D) glass

Question 50

____ can be used to keep a virtual eye on children and pets.

A) Mobile locating
B) Real-time locating systems
C) GPS
D) Cell phones

Question 51

Triangulation for a phone within range of two or more towers can be as accurate as ____ yards, which is pretty good for locating a motorist in trouble.

A) 50
B) 100
C) 200
D) 300

Question 52

In the accompanying figure, the view indicated by item 3 allows you to ____.

A) redesign your spreadsheet
B) delete an entire spreadsheet
C) view each record displayed as a list
D) select criteria to use as the filter

Question 53

Which of the following is not one of today's most common tracking technologies?

A) radio
B) GPS
C) PC
D) RFID

Question 54

In the accompanying figure, the feature indicated by item 1 indicates a ____ in a database that holds records that contain data.

A) table
B) form
C) tab
D) file

Question 55

RFID is incorporated in all but which of the following?

A) passports
B) driver's licenses
C) merchandise labels
D) cell phones

Question 56

Which of the following is not location aware?

A) GPS
B) RFID
C) mobile locating
D) real-time locating

Question 57

Cellular phones offer tracking capabilities because they can determine their geographic location using either mobile locating or ____ technology.

A) radio
B) cellular
C) GPS
D) RFID

Question 58

In the accompanying figure, the feature referred to by item 3 ____.

A) allows you to search through the records
B) holds the records that contain data
C) helps you organize and display data in an effective way
D) defines a way of displaying data in each record

Question 59

When you see a(n) ____ in a URL, your browser is displaying the results of a database query.

A) *
B) ?
C) &
D) ^

Question 60

____ devices receive signals transmitted by a collection of earth-orbiting satellites.

A) RFID
B) Triangulation
C) GPS
D) Mobile locating

Question 61

Name four tips to keep in mind when entering data as suggested in this chapter.

Question 62

Explain how spreadsheet software can be used to create databases.

Question 63

A process called ____________________ is useful to create reports that show only selected data.

Question 64

The data that you enter into an online form is collected by a program that runs on the Web site's ____________________.

Question 65

The ____________________ of mobile locating depends on the number of nearby towers and the coverage area.

Question 66

Case-Based Critical Thinking Questions Case 12-1 Tina is considering purchasing database software. She already has Microsoft Excel, which is spreadsheet software. Tina has been thinking about the fact that her personal data is tracked in databases without her knowledge. She needs to research information about ____.

A) real-time locating systems that transmit signals to a nearby station using radio waves
B) RFID technologies that are used to identify, rather than geolocate
C) mobile locating that tracks the position of a cellular device
D) GPS devices that receive signals transmitted by a collection of earth-orbiting satellites

Question 67

A(n) ____________________ contains fields of information about a single entity in the database.

Question 68

Case-Based Critical Thinking Questions Case 12-1 Tina is considering purchasing database software. She already has Microsoft Excel, which is spreadsheet software. Tina wants to add data to an online database. She has never accessed this database before. One of the first steps she needs to take is ____.

A) register for an account at a Web site
B) copy her database to a Web site
C) search for an e-commerce Web site
D) download the online database

Question 69

Case-Based Critical Thinking Questions Case 12-1 Tina is considering purchasing database software. She already has Microsoft Excel, which is spreadsheet software. Tina has a number of index cards filled with customer information from her home business. She wants to be able to input this data into her computer and search through it when necessary. Based on these criteria, Tina should ____.

A) purchase database software because you can't search for data that meets specific criteria using the spreadsheet software that she already has
B) purchase database software because it will allow her to build records based on her index cards and then filter specific data
C) stick with the software that she already owns; Microsoft Excel allows you to search for data that meets specific criteria, and there is no need for Tina to spend more money on more complicated software
D) find a new kind of software because both database and spreadsheet software are insufficient for her needs

Question 70

You can use most ____________________ software to create and maintain files of information, but cannot use it to join files or tables together.

Question 71

____________________ devices can be configured to issue an alert when the trackee moves out of a designated area.

Question 72

The ____________________ is a specification for the database fields and their characteristics.

Question 73

Signals transmitted by ____________________ satellites can pass through clouds, plastic, and glass.

Question 74

A(n) ____________________ database contains information that is organized as fields, records, and files.

Question 75

Web apps, such as Zoho Creator, are available for creating ____________________ databases.