CIS50 – Final

question

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

Get instant access to
all materials

Become a Member