CIS50 – Final – Flashcards
Unlock all answers in this set
Unlock answersquestion
How many records will be selected with the following SQL Query SELECT Toy, Brand, Color FROM TOY_STORE_INVENTORY WHERE QTY < 50 HINT: Read the statement very, very, very carefully
answer
22-wrong ZERO-correct
question
How many records will be selected with the following query; WHERE wholesale > 4.99 and not ordered by "J. Mathers"
answer
5
question
Select the query to select any toys that were ordered by T. Livingston or A. Hayes before 7/1/01
answer
WHERE (ordered by "T. Livingston" or ordered by "A. Hayes") and ordered < 7/1/01
question
A data center that is run and managed in an automated fashion while being monitored remotely is referred to as a ____ environment.
answer
lights out
question
A ____ is a collection of data that has been organized to meet users' needs.
answer
database
question
A very large database that holds important data from a variety of sources is called a ____.
answer
data warehouse
question
A data dictionary typically includes which of the following?
answer
the names of the data items
question
Database tools include software and techniques for analyzing, maintaining, and manipulating data in a database.
answer
true
question
A common type of flat file database format known as ____ stores records as a line of text separated by commas.
answer
CSV
question
Useful ________ is data organized in some meaningful way.
answer
information
question
A popular database software program called ____ offers a wizard and QBE tool to help build and generate SQL queries.
answer
MS access
question
The data manipulation language ____ is a popular tool when querying a relational database.
answer
sql
question
________ is used on databases in both mainframe and personal computers.
answer
sql
question
Data integrity refers to the quality and accuracy of the data.
answer
true
question
In a database, first name would be an example of a ____.
answer
field
question
A schema illustrates the ____ and ____ in a database and the relationships among them.
answer
tables and fields
question
____ is a concern for some organizations and individuals when data is collected in databases without their permission.
answer
privacy
question
The process of extracting information from a data warehouse or data mart is called ____.
answer
data mining
question
A data mine is a climate-controlled building or set of buildings that house servers that store and deliver mission-critical information and services.
answer
false; data center
question
In 1986, the American National Standards Institute (ANSI) adopted ____ as the standard query language for relational databases.
answer
sql
question
The output of data mining in a business setting is sometimes called ____.
answer
business intelligence
question
When a database problem occurs, its tables may be split up during the ____ process to correct a data problem.
answer
normalization
question
____ involves combining two or more tables.
answer
joining
question
A data dictionary provides a detailed description of each field and table in a database.
answer
true
question
One of the first steps in creating a database is to build queries and reports that can pull information from the data that is stored.
answer
false; create a table with information
question
A database schema can stand alone as a single file or be part of a database.
answer
true
question
A database administrator designs, implements, and maintains a database.
answer
true
question
The iTunes library is based on database technology.
answer
true
question
A data ____ is a small data warehouse that is developed for a specific person or purpose.
answer
mart
question
The most popular format for flat file databases is comma-separated values (CSV).
answer
true
question
Primary keys ensure that ____.
answer
duplicate records are not stored in the database
question
A ________ is a set of programs that manipulate the data within a database.
answer
database management system
question
The ability to connect data in different tables through a common field is sometimes referred to as a relationship.
answer
true
question
A data center is used by large organizations to store older archived data that is no longer needed on a day-to-day basis.
answer
false
question
Ethical issues around the subject of big data generally center on the issue of ________.
answer
privacy
question
In a database, a collection of related fields that describes some object or activity is referred to as a ____.
answer
record
question
SQL is one example of a data manipulation language.
answer
true
question
Query wizards and ____ automate the process of writing SQL commands in a relational database.
answer
QBE, query by example
question
A database ____ is a graphical representation of the structure of a database.
answer
schema
question
Big data is a term used to refer to data sets that are too large to process through traditional means.
answer
false
