logo image

CIS50 – Final

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

22-wrong

ZERO-correct

How many records will be selected with the following query;

WHERE wholesale > 4.99 and not ordered by “J. Mathers”

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

Need essay sample on "CIS50 – Final"? We will write a custom essay sample specifically for you for only $ 13.90/page

Can’t wait to take that assignment burden offyour shoulders?

Let us know what it is and we will show you how it can be done!
×
Sorry, but copying text is forbidden on this website. If you need this or any other sample, please register

Already on Businessays? Login here

No, thanks. I prefer suffering on my own
Sorry, but copying text is forbidden on this website. If you need this or any other sample register now and get a free access to all papers, carefully proofread and edited by our experts.
Sign in / Sign up
No, thanks. I prefer suffering on my own
Not quite the topic you need?
We would be happy to write it
Join and witness the magic
Service Open At All Times
|
Complete Buyer Protection
|
Plagiarism-Free Writing

Emily from Businessays

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out https://goo.gl/chNgQy

We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy