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.
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 ____.
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.
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 ____.
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 ____.
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