Upgrade to remove ads
SQL: Basic Queries
Terms and commands used to build simple queries in SQL. (Unit 6)
Terms in this set (32)
Operator used to perform "wildcard" comparisons. (pg108 Oracle)
Operator that supports "Range" from min to max comparisions. (Page 107 Oracle)
Operator to test whether an expression is equal to a value in a list of expressions it is a "List" of values.(pg105 Oracle)
Logical operators that you can use to create compound conditions that consists of two or more conditions, and it specifies that the search must satisfy both conditions. (pg103 Oracle)
Logical operators that you can use to create compound conditions that consists of two or more conditions,and it specifies that the search must satisfy at least one of the conditions.(pg103 Oracle)
Keyword that prevents duplicate (identical) rows from being included in the result set. (pg97 Oracle)
(||) is used to combine columns and literals in a string expression. (pg89 Oracle)
Consists of one or more character columns, one or more literal values, or a combination of character columns and literal values. (pg89 Oracle)
SELECT statement clause used to retrieve the columns specified in the Select clause from the base table specified in the From clause and store them in a result set. (pg81 Oracle)
SELECT statement clause used to filter the rows in a basic table so that only those rows that match the search condition are included in the result set.(pg81 Oracle)
SELECT statement clause used to specify the sort order for a result set. If you include this clause the rows in the result set are sorted in the specified sequence otherwise the sequence of the rows is not guaranteed by Oracle. (pg81 Oracle)
SELECT statement clause used to specify the data sources from which the query will retrieve the data.(pg81 Oracle)
You would only use this formula only when you need to retrieve all columns from a table (pg85 Oracle)
Is a combination of column names and operators that evaluate to a single value.(pg85 Oracle)
One way to name a column is by using the AS keyword, although it is optional, it enhances readability. (pg87 Oracle)
Unless parentheses are used, the operations in an expression take place from left to right in the order of precedence.(pg91 Oracle)
An oracle function that replaces Null values in a result set.
special characteristics that determine which values in the column satisfy the condition. In Oracle, '_' represents a single character and '%' represents multiple characters.
The relation theoretic operation used to describe rows that are returned in a query.
The relation theoretic operation used to connect related records in a query.
The relation theoretic operation used to create columns in a query.
A value that is unknown, unavailable, or not applicable. (pg. 14)
A value that is used if another value is not provided when a row is added to the talble. (pg. 14)
Data Manipulation Language (DML)
The statements that work with the data in a database (mostly used by application programers). (pg. 20)
Data Definition Language (DDL)
The statements that work with the objects in a database (used by SQL programmer and DBAs). (pg. 20)
Used to automatically generate a value for the column. (pg. 22)
PL/SQL (Procedural Language/SQL)
An Oracle extension to standard SQL that allows you to write procedural code that includes if/else statements, loops, and error handling. (pg35)
A type of subprogram that contains one or more SQL or PL/SQL statements that have been compiled and stored with the database. Stored Procedures may be called by outside programs. (pg35)
SELECT statement clause that tells the database which fields to look at to determine whether values should be combined. (DD pg.362)
SELECT statement clause used to perform SELECTION on the values returned by a grouping statement. Does not work on records.
Oracle function used to concatenate a series of arguments into a single value.
A type of subprogram compiled and stored with the database. Triggers are created to execute whenever certain database events (like table Updates and Inserts) occur.
THIS SET IS OFTEN IN FOLDERS WITH...
SQL Server DBA Interview Questions Part 3
YOU MIGHT ALSO LIKE...
MySQL 2nd Edition Chapter 03
SQL Scripting Unit 1
OTHER QUIZLET SETS
MIS: Quiz 2
Biology - Unit 1 - Cell structure
Geography Midterm Dillet