Upgrade to remove ads
Murach Chapter 3 & 4 Test
Terms in this set (33)
Named in the FROM clause.
Used in the WHERE clause and used to filter rows.
Used in a where clause to eliminate unwanted rows
Two or more search conditions combined with logical operators to filter a result set.
A substitute name given to a column in the result set.
The result of a SELECT query that returns no results.
Actual value which can be either number, strings of numbers, symbols, characters.
A combination of one or more numbers, letters, symbols surrounded by double quotes.
Performs an operation and returns a value.
These are passed into a function.
Alternate name for a table used to easily identify a table and shorten the typing. Helpful when creating large queries with 1 or more joins.
Used to join to two or more string columns or literal values.
Used in the search condition of a WHERE clause to compare two conditions.
Boolean operators such as AND, OR and NOT.
When two or more search conditions are combined in the WHERE clause.
Used to combine columns from two or more tables into a result set based on the join condition.
Is a standard when coding SQL and uses best practices.
Order of Precedence
The order in which an arithmetic or boolean expression is evaluated.
When the ____________ is used, the result includes all the rows from the first table.
When the ____________ is used, the result includes all rows from the second table.
Used to compare a no value in the WHERE clause search condition.
Used to combine rows from two or more result-sets.
Formed when two or more conditions use an OR an AND in a result-set and may also be referred to as a boolean expression.
To be this, the table name or an alias with a period must precede the column name.
A query used within another query.
Only the rows that satisfy the join condition are included in the result set.
The only required clause in the SELECT statement.
Another name to refer to a database.
Used to select/retrieve columns to be used in the query.
Indicates the table or tables that will be used.
Provides a search condition for finding the results of a query.
Orders the result set in a certain way.
Limits the maximum amount of results that will appear in the result set.
THIS SET IS OFTEN IN FOLDERS WITH...
PL/SQL Chapter 5: Procedures
MIS 320 - Murach Chapter 1 Terms
Murach 8 and 9
YOU MIGHT ALSO LIKE...
COMPUTING SQL REVISION
Murach SQL Server 2012 Chapter 4
MySQL 2nd Edition Chapter 04
OTHER SETS BY THIS CREATOR
Term 3 History Flash Cards
Term 2 History Flash Cards
MySQL Chapter 3 Vocab
Chapter 10 Vocab
OTHER QUIZLET SETS
AP CSP Unit 2 Lessons 7 - 14
Stat Module 2
word 2010 vocabulary list 2
Semester Test Review Middle School -- Pa…