Chapter 8
Used to specify conditions that must be true for a record to be included in query results
What is the WHERE Clause?
Each record in the first table is matched with each record in the second table
What is a Cartesian join?
Used to change the case of characters or to manipulate characters
What is a character function?
Returns one result per group of rows processed
What is a group function or multiple-row function?
One query inside of another query
What is a nested query or subquery?
Used to specify the sorted order for displaying query results
What is the ORDER BY Clause?
The most common type of join which is based on two (or more) tables having equivalent data stored in a common column
What is an equality join?
Converts character strings to lower case
What is the LOWER function?
Used to calculate the total amount stored in a numeric field for a group of records
What is the SUM function?
Nested queries that can return more than one row of results to the paretn query
What is a multiple-row subquery?
Used to indicate how a record should related to a specific search value
What are mathematical comparison operators?
Indicates the column being referenced
What is a column qualifier?
Using one function as an argument inside another function
What is nesting?
Instructs only to include only unique numeric values in its calculation
What is the DISTINCT keyword?
Database objects that store a SELECT statement and allow using a query's results as a table
What is a view?
Identifies what must exist or a requirement that must be met for a record to be included in the results
What is a condition?
Used when the related columns can't be joined with an equal sign
What is a non-equality join?
Returns only the remainder of a division problem
What is the MOD function?
Used to display number of records meeting a specific condition
What is the COUNT function?
Enables you to store data retrieved by the view query and reuse the data without executing the view query again
What is a materialized view?
Used to represent one or more alphanumeric characters
What are wildcard characters?
Used to join a table to itself
What is a self-join?
Used to address problems caused when performing arithmetic operations with fields that might contain NULL values
What is the NVL function?
Returns the largest value stored in the specified column
What is the MAX function?
Used to limit the rows a query returns
What is the ROWNUM keyword?