logo image

CIS50 – Final

How many records will be selected with the following SQL Query

SELECT Toy, Brand, Color


WHERE QTY < 50 HINT: Read the statement very, very, very carefully



How many records will be selected with the following query;

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

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.
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.
A common type of flat file database format known as ____ stores records as a line of text separated by commas.
Useful ________ is data organized in some meaningful way.
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.
________ is used on databases in both mainframe and personal computers.
Data integrity refers to the quality and accuracy of the data.
In a database, first name would be an example of a ____.
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.
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.
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.
____ involves combining two or more tables.
A data dictionary provides a detailed description of each field and table in a database.
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.
A database administrator designs, implements, and maintains a database.
The iTunes library is based on database technology.
A data ____ is a small data warehouse that is developed for a specific person or purpose.
The most popular format for flat file databases is comma-separated values (CSV).
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.
A data center is used by large organizations to store older archived data that is no longer needed on a day-to-day basis.
Ethical issues around the subject of big data generally center on the issue of ________.
In a database, a collection of related fields that describes some object or activity is referred to as a ____.
SQL is one example of a data manipulation language.
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.
Big data is a term used to refer to data sets that are too large to process through traditional means.

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