CGS2100 CH07
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.
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.