CGS2100 CH07

Ace your homework & exams now with Quizwiz!

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

True

One popular open-source database is MySQL. (T/F)

True

Oracle offers support for multidimensional database products. (T/F)

True

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

batch

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

computed

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

counting the number of times other related Web pages linked to it.

Prior to Google, early search engines ranked web pages by

counting the number of times the key word or phrase appeared to the page.

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

customer ID

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

data warehouses are an obsolete concept.

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

dirty data

A computerized _____ is a good comparison to a database.

file cabinet

When checking your bank account balance through the internet, you use ___ processing.

interactive

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

multidimensional

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

numeric

Google is a play on the term googol, which means ______

a 1 followed by 100 zeroes

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

12

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

Natural

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

Batch

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

Chinese

A report generally uses all the fields that are in the database. (T/F)

False

Databases make it simple to store small quantities of information, but are not suited for large quantities of information. (T/F)

False

Navigation by browsing through the records in a database is the most effective way to search for information. (T/F)

False

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

False

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

Google

The act of obtaining data about an individual and then using that data to fraudulently obtain goods and services in that individuals name is called

Identity theft

All of the following are true statements about databases EXCEPT:

Information from the database cannot be printed.

One example of a GIS is _____

MapQuest

The following is an example of _____ : Select Student_ID from Students Where Credits >= 46

SQL

A key field must

Uniquely identify a record

In 2004, Google...

offered shares of stock to the public.

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

privacy

In a client/server environment, the server ____

processes a query from a client and then sends the answer back to the client.

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

querying

A relational database table is composed of _____, and each of those is composed of fields.

records

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

sorting

A relational database requires one or more _____

tables.

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

text

The kind of info a field can hold is determined by _____

the field's data type

All of the following are advantages of SQL EXCEPT:

the power and features are exactly the same as Haskell, C#, and java.


Related study sets

TIOBE - Love and Marriage Quotes

View Set

Importance of Exercise/Health Risks of a Sedentary Lifestyle

View Set

Psych 205 Final - chapter 9 review

View Set