Section 1
Preview this deck
AVG
Front
| 5 | 0 | ||
| 4 | 0 | ||
| 3 | 0 | ||
| 2 | 0 | ||
| 1 | 0 |
Active users
0
All-time users
0
Favorites
0
Last updated
7 years ago
Date created
Mar 1, 2020
Cards (74)
Section 1
(50 cards)
AVG
An aggregate function that returns the average of the non-null values in the expression (argument) ---.
aggregate
An --- function is sometimes referred to as a column function because it operated on values in columns.
YEAR
To store a year without any other temporal data, use the --- type.
INT
It is a common programming practice to use --- as an abbreviation for INTEGER.
COUNT
The total of the non-null values in the expression is obtained with the --- function.
DISTINCT
Use the --- keyword to eliminate duplicate values.
UNSIGNED
If the --- attribute for an integer is set, it prevents negative values from being stored in a column. And the range of acceptable positive values is doubled.
ZEROFILL
If the --- attribute for a real number is set, the number is displayed with zeros padded from the left, and the UNSIGNED attribute is automatically set.
GROUP BY
If aggregate functions are included in the SELECT clause, the aggregate is calculated for each group specified by the --- clause.
nested
A subquery coded within another query is also known as a --- subquery.
Large object data types
--- are useful for storing images, sound, video, and large amounts of character data.
Pseudocode
--- is code that represents the intent of a query but does not necessarily use SQL code.
MAX
To return the highest non-null value in the expression, invoke the --- function.
COUNT
To find the number of rows in a table, invoke the --- function with an asterisk as the expression(argument).
NOT EXISTS
Use the --- operator to test whether no rows are returned by the subquery.
summary
A(n) --- query is one that contains one or more aggregate functions.
data type
A column's --- specifies the kind of information the column is intended store; and it determines the operations that can be performed on the column.
DATE
The --- type can be used to store a date without a time.
inline view
A result set referred to as a(n) --- is one coded in the FROM clause of a SELECT statement.
floating-point numbers, approximate
The DOUBLE and FLOAT types store --- which have a limited number of significant digits. These types are considered --- because they do not represent a value exactly.
Integers
--- are numbers that do not have a decimal point.
numeric data types
The --- are intended for storing numbers that can be used for mathematical calculations.
WHERE
When a --- clause is included in a SELECT statement that uses grouping and aggregates, MySQL applies the search condition before it groups the rows and calculates the aggregates.
HAVING
Including a --- clause in a SELECT statement that uses grouping and aggregates causes MySQL to apply the search condition after it groups the rows and calculates the aggregates.
GROUP BY
A SELECT statement with a --- clause groups the rows of a result set based on one or more columns or expressions.
HAVING
The --- clause specifies a search condition for a group or an aggregate.
Comments
--- may be used to describe how the different parts of a complex query without changing how the query operates.
exact numeric type
The DECIMAL type is considered an --- because its precision is exact.
subquery
A(n) --- is a SELECT statement that is coded within another SQL statement.
VARCHAR
Use the --- type to store variable-length strings. Data of this type occupies only the number of bytes needed to store the string pls an extra byte to store the length of the string.
HAVING
The AND and OR operators may be used to compound search condition in a ---clause just as may be done in a WHERE clause.
Character data types
--- are intended for storing a string of one or more characters, which can include letters, numbers, symbols, or special characters.
uncorrelated
A(n) --- subquery is executed once for the entire query.
precision, scale
The --- of a real number indicates the total number of digits that can be stored, and the --- indicates the number of digits that can be stored to the right of the decimal point.
ZEROFILL
If the --- attribute for an integer is set, the UNSIGNED attribute is automatically set, and the integer is displayed with zeros padded from the left up to the maximum display size.
EXISTS
The --- operator tests whether the subquery returns a result set (i.e. one or more rows are returned by the subquery).
spatial data types
MySQL provides --- that are useful for storing geometric and geographical values such as GPS data.
Aggregate
functions operate on a series of values and return a single value.
fixed-length strings
Use the CHAR type to store ---. Data of this type always occupy the same number of bytes.
ENUM, SET
The --- type, considered a character type, can store exactly one value; whereas the --- type can take on zero, one, or up to 64 different values. Values for these types are defined when the table is created.
Real numbers
--- are numbers that have a decimal point.
BOOLEAN
The --- types are synonyms for TINYINT(1). You can use these types to store 0 or FALSE for false values, and 1 or TRUE for true values.
correlated
A(n) --- subquery refers to a value that is provided by a column in the main query and is executed once for each row that is processed by the main query.
Real numbers / decimal
--- can include digits to the right of the decimal point.
Date and time data types
--- are intended for storing dates, times, or both dates and times.
--
To code a single-line comment start a line with two --.
DATETIME
Use the --- type, rather than TIMESTAMP, to store both a date and a time (and also avoid the year 2038 problem).
COUNT
--- with argument [ALL | DISTINCT] expression is invoked to find the number of non-null values in the expression.
MIN
The --- function is invoked to find the lowest non-null value in the expression.
Scalar
functions operate on a single value and return a single value.
Section 2
(24 cards)