Deck 7: Database Applications and Privacy Implications

Question 1

A computerized ________ is a good comparison to a database.

A)file cabinet
B)typewriter
C)overhead projector
D)calculator

Answer 1

A

Question 2

Database programs can do all of the following EXCEPT:

A)store and organize data.
B)create graphics.
C)communicate data.
D)alleviate information overload.

Answer 2

B

Question 3

When looking for a specific customer in a large credit card database,________ is more efficient than browsing.

A)surfing
B)keying
C)scrubbing
D)querying

Answer 3

D

Question 4

The following is an example of a ________ language: Select Student_ID From Students Where Credits >= 46

A)query
B)Java
C)HTML
D)PHP

Question 5

One example of a PIM is ________.

A)Outlook
B)SQL Server
C)Access
D)MapQuest

Question 6

The number of newspapers sold on May 30 would be kept in a ________ field.

A)date
B)numeric
C)text
D)key

Question 7

All of the following are true statements about databases EXCEPT:

A)Databases allow easy reorganization of data.
B)Using a database simplifies retrieving information.
C)Databases store large amounts of data.
D)Information from the database cannot be printed.

Question 8

The process of ________ would be used when sending data from a database to a word processor so that mailing labels could be produced.

A)exporting
B)sorting
C)mining
D)querying

Question 9

In a customer database table,all information for one customer is kept in a

A)batch.
B)field.
C)record.
D)query.

Question 10

Bringing data from a word processing program into a database program is known as

A)exporting.
B)batch processing.
C)importing.
D)scrubbing.

Question 11

________ is perusing data in a database as if looking through pages in a notebook.

A)Browsing
B)Keying
C)Scrubbing
D)Cleansing

Question 12

In a database table,a ________ is all the information related to one person,product,or event.

A)table
B)report
C)field
D)record

Question 13

In a database,a ________ field shows results of calculations performed on data in other numeric fields.

A)configured
B)concatenated
C)key
D)computed

Question 14

A collection of information stored in an organized form on a computer is a(n)

A)database.
B)query.
C)operating system.
D)utility.

Question 15

An ordered list of selected records and fields printed in an easy-to-read format is known as a(n)

A)query.
B)sort.
C)inquiry.
D)report.

Question 16

Arranging all customer records in customer number order is an example of

A)querying.
B)sorting.
C)inquiring.
D)filtering.

Question 17

Database queries must be

A)contiguous.
B)unambiguous.
C)based on reports.
D)filtered.

Question 18

In a customer database,a customer's surname would be keyed into a(n)________ field.

A)key
B)text
C)numeric
D)computed

Question 19

A relational database requires one or more

A)forms.
B)tables.
C)queries.
D)reports.

Question 20

Software for organizing storage and retrieval of information is a(n)

A)record.
B)database program.
C)platform.
D)data warehouse.

Question 21

This search engine is the most visited site on the planet:

A)Bing.
B)Google.
C)Dogpile.
D)MSN.

Question 22

The Children's Online Privacy Protection Act requires Internet-based businesses to obtain parental consent before collecting information from children ________ years of age and younger.

A)9
B)12
C)17
D)18

Question 23

Producing paychecks twice a month is an example of ________ processing.

A)interactive
B)digitization
C)real-time
D)batch

Question 24

In a typical client/server environment,the client can be any of the following EXCEPT:

A)a desktop computer.
B)a mainframe.
C)a smart phone.
D)a laptop.

Question 25

A(n)________ combines data tables with demographic information.

A)PIM
B)DBMS
C)SPSS
D)GIS

Question 26

________ is connectivity software that hides the complex interaction between client and server computers and creates a three-tier design separating actual data from the programming logic used to access it.

A)SQL
B)Groupware
C)Middleware
D)Firmware

Question 27

The act of obtaining data about an individual and then using that data to impersonate them is known as

A)identity theft.
B)spam.
C)data mining.
D)phishing.

Question 28

A ________ manipulates data in a large collection of tables and cross references those tables.

A)SPSS
B)GIS
C)PIM
D)DBMS

Question 29

One example of a GIS is ________.

A)Outlook
B)Facebook
C)YouTube
D)MapQuest

Question 30

In an object-oriented database,every object is an instance of a

A)table.
B)field.
C)class.
D)query.

Question 31

________ is a newer,powerful data description language used to construct Web pages as well as access and query databases using the Internet.

A)SQL
B)PHP
C)Javascript
D)XML

Question 32

When checking your bank account balance through the Internet,you use ________ processing.

A)interactive
B)analog
C)digitization
D)batch

Question 33

For a customer database,a good choice of key field would be

A)first name.
B)customer ID.
C)phone number.
D)last name.

Question 34

Most current databases are ________ databases,where data from more than one table can be linked.

A)flat file
B)relational
C)object-oriented
D)multidimensional

Question 35

In a client/server environment,the server

A)processes a query from a client and then sends the answer back to the client.
B)cannot be used to access a corporate data warehouse.
C)must be a database system.
D)must be in close proximity to all client computers in the network.

Question 36

Data mining is

A)batch processing using files stored on a mainframe computer.
B)finding and extracting hidden predictive information from the data in large databases.
C)a specialized type of program that is used in the mining industry.
D)creating a database warehouse from many smaller databases.

Question 37

A large corporation would use a ________ to keep records for employees and customers along with all of its inventory data.

A)GIS
B)spreadsheet program
C)PIM
D)database management system

Question 38

When a person uses language such as ordinary English to query a database,it is known as a(n)________ language query.

A)low-level
B)object-oriented
C)natural
D)XML

Question 39

A key field must

A)uniquely identify a record.
B)be stored in its own separate table.
C)be located in a minimum of three tables.
D)be a text field.

Question 40

________ processing is used when a college accumulates course registrations and processes them at the same time in one large set.

A)Interactive
B)Analog
C)Real-time
D)Batch

Question 41

Database technology increases privacy threats due to all of the following technologies EXCEPT:

A)surveillance satellites.
B)standalone computers.
C)RFID chips.
D)workplace monitoring.

Question 42

A program that enables users to work with one file at a time is a(n)________ manager.

A)personal information
B)structure
C)file
D)transaction

Question 43

Record matching is trivial and quick as long as

A)a relational database is used.
B)the DBMS is not Access.
C)the tables in the database share a single unique field.
D)the fields are the same data type.

Question 44

Relational databases may eventually be replaced by

A)flat databases.
B)object-oriented databases.
C)external relational databases.
D)hierarchical databases.

Question 45

In 2004,Google

A)developed a set of open standards for mobile phones.
B)offered shares of stock to the public.
C)launched its first search engine.
D)renamed itself from BackRub.

Question 46

All of the following are benefits of record matching EXCEPT:

A)easier to establish reputations in getting credit for consumers.
B)allows systems like the U.S. National Crime Information Center to function.
C)easier to use credit cards around the world.
D)data is more secure.

Question 47

Google is a play on the term googol,which means

A)a 1 followed by 100 zeroes.
B)a number more than can be counted.
C)one trillion.
D)infinity in the negative direction.

Question 48

The challenging part of using databases is retrieving information in a

A)timely manner.
B)format readable on the Internet.
C)file that can be exported to another program.
D)cost effective manner.

Question 49

In 2005,Google agreed to allow the ________ government to censor certain searches made by their citizens.

A)United States
B)German
C)Indian
D)Chinese

Question 50

Database software can help alleviate

A)the need to use spreadsheets.
B)disk space issues.
C)information overload.
D)the need for validation of data.

Question 51

Data records with errors (for example,spelling errors or incorrect values)are called

A)classified data.
B)dirty data.
C)scrubbed data.
D)cleansed data.

Question 52

Most businesses today use a ________ approach in employing database servers.

A)client/server
B)centralized database
C)thin client
D)mainframe system

Question 53

The difference between application programs and development tools is blurred through the use of ________ in databases.

A)saved reports.
B)stored queries.
C)parameter queries.
D)triggers.

Question 54

All of the following are advantages of SQL EXCEPT:

A)easy-to-understand statements.
B)the ability to have code generated from DBMS GUIs.
C)availability across many different DBMSs.
D)the power and features are similar to C# and Java.

Question 55

All of the following are true about object-oriented databases EXCEPT:

A)they can associate actions with objects, for example, the ability to generate a thumbnail from an image.
B)many computer scientists believe relational databases will be replaced by object-oriented databases.
C)they save time by reusing objects.
D)they can not store and receive unstructured data, such as audio and video clips.

Question 56

All of the following are true statements regarding data warehouses EXCEPT:

A)data warehouses are large.
B)data warehouses are inexpensive.
C)data warehouses give users more direct access to enterprise data.
D)data warehouses are centralized for convenience.

Question 57

In many organizations,address books and appointment calendars have been replaced by

A)Outlook.
B)Access.
C)Excel.
D)InDesign.

Question 58

PIMs are popular among people with

A)physical disabilities.
B)busy schedules.
C)poor handwriting.
D)poor Internet service in their area.

Question 59

Database technology has given us convenience in gathering data; however at the same time,many times it takes away

A)the ability to find trends in data.
B)security.
C)independence.
D)privacy.

Question 60

Google's original algorithm was written to improve the way search engines looked for Web pages by

A)counting the number of times other related Web pages linked to it.
B)counting the number of times the key word or phrase appeared on the page.
C)counting the number of hits the page had received from the linked page.
D)having humans examine and rate each page.

Question 61

Databases make it simple to store small quantities of information,but are not suited for large quantities of information.

Question 62

A database that stores data in "cubes" rather than tables is known as a(n)________ database.

A)flat
B)multidimensional
C)object-oriented
D)relational

Question 63

A centralized database spreads data across multiple computers.

Question 64

The kind of information a field can hold is determined by

A)data type.
B)number of records in the field.
C)field size.
D)default value.

Question 65

With a database,switching between organizational schemes can be done easily.

Question 66

Prior to Google,early search engines ranked Web pages by

A)counting the number of times other Web pages linked to it.
B)counting the number of times the key word or phrase appeared on the page.
C)counting the number of hits the page had received from the linked page.
D)having a human view and rate each page.

Question 67

A field that contains formulas similar to those found in a spreadsheet is a called a computed field.

Question 68

Navigation by browsing through the records in a database is the most efficient way to search for information.

Question 69

Oracle offers support for multidimensional database products.

Question 70

Most business reports arrange data in tables with columns for individual records and rows for selected fields.

Question 71

A specialized vocabulary is associated with databases.

Question 72

A contextual search tool might ask "Did you mean Newark,Delaware or Newark,NJ?" if you query the word Newark.

Question 73

Users of specialized database programs spend most of their time designing forms and file structures.

Question 74

Databases do not make it easy to print and distribute information in a number of different ways.

Question 75

Most database programs can import text files.

Question 76

One popular open-source database is MySQL.

Question 77

The view that allows several records at a time to be viewed is

A)field view.
B)list view.
C)form view.
D)layout view.

Question 78

Natural language Web searches have not made much headway in replacing existing database technology searches.

Question 79

Using SQL requires the user to learn a new language each time they work with new hardware and software systems.

Question 80

A report generally uses all the fields that are in the database.