Database Vocab Final
The ______ wildcard is a substitute for zero or more characters.
%
The Oracle ________ function is used to access the current value of the specified sequence.
.CURRVAL
When creating a sequence, you can use the __________ statement to increase the value of the sequence by one each time.
.NEXTVAL
The basic commands with the DDL language are ________
1. CREATE 2. ALTER 3. DROP 4. RENAME 5. TRUNCATE 6. COMMENT
The basic commands with the DCL language are _______
1. GRANT 2. REVOKE
The basic commands with the TCL language are _______
1. SAVEPOINT 2. ROLLBACK 3. COMMIT
The basic commands with the DML language are _______
1. SELECT 2. INSERT 3. UPDATE 4. DELETE
You use a ______ clause when the primary and foreign key column share the same column name and the ______ clause when they don't.
1. USING 2. ON
The ______ operator is used to compare a value to all values in another value set.
ALL
The _________ statement is also used to rename a table.
ALTER TABLE
The _________ statement is used to add, modify, or drop/delete columns in a table.
ALTER TABLE
The _____ operator displays a record if both the first condition and the second condition are true.
AND
The ______ operator is used to compare a value to any applicable value in the list according to the condition.
ANY
______ allows a unique number to be generated when a new record is inserted into a table.
Auto-increment
The ______ operator selects values within a range. The values can be numbers, text, or dates.
BETWEEN
The _______ statement confirms or makes permanent any change.
COMMIT
a ____________, matches every row in one table against every row in another.
CROSS JOIN
The _________ statement removes a row from a table.
DELETE
DCL
Data Control Language
DDL
Data Definition Language
DML
Data Manipulation Language
A ________ in one table points to a PRIMARY KEY in another table.
FOREIGN KEY
________: The part of an SQL SELECT statement that specifies conditions used to determine which tables are used in a query ANSI SQL-92
FROM
The ___________ matches every row in one table against every row in another based on common values in one or a set of columns, like an INNER JOIN. It then also returns everything from the table on the left and right sides of the FULL JOIN operator that weren't found in the other respective table.
FULL [OUTER] JOIN
The _________ operator is used to compare a value to a list of literal values that have been specified.
IN
The ___________ matches every row in one table against every row in another based on common values in one or a set of columns found in both tables
INNER JOIN
The ______ statement adds new rows in a table.
INSERT
The _________ statement is used to insert new records in a table.
INSERT INTO
An __________ operates on two queries that return select lists that share the exact position, number of columns, and data types.
INTERSECT
The ____________ matches every row in one table against every row in another based on common values in one or a set of columns, like an INNER JOIN. It then also returns everything from the table on the left of the LEFT JOIN operator that was not returned as part of the match.
LEFT [OUTER] JOIN
The ______ operator is used to search for a specified pattern in a column.
LIKE
The __________ statement lets you add new rows when they don't exist or change column values in rows that do exist.
MERGE
A ________ operates like the INTERSECT operator in that both queries must share select lists that match by position, number of columns, and data types. The difference is that the any rows from the first query found in the second query are removed from the result set.
MINUS
The ___________ matches every row in one table against every row in another based on common values found in columns that share a common name and data type
NATURAL JOIN
________ - Indicates that a column cannot store NULL value
NOT NULL
_____ values represent missing unknown data.
NULL
The _____ operator displays a record if either the first condition or the second condition is true.
OR
The _____ clause is used in a SQL query to sort the records in your result set. The _____ clause can only be used in SQL SELECT statements.
ORDER BY
The _______ constraint uniquely identifies each record in a database table.
PRIMARY KEY
The ________________ matches every row in one table against every row in another based on common values in one or a set of columns, like an INNER JOIN. It then also returns everything from the table on the right of the RIGHT JOIN operator that was not returned as part of the match.
RIGHT [OUTER] JOIN
The _________ statement cancels or undoes any change.
ROLLBACK
This command acts like a bookmark in your script.
SAVEPOINT
The __________ statement is used to select data from a database.
SELECT
The _________ statement is used to return only distinct (different) values.
SELECT DISTINCT
The _______ clause is used to specify the number of records to return.
SELECT TOP
_______ compares a value to each value in a list or results from a query and evaluates to true if the result of an inner query contains at least one row.
SOME
SQL
Structured Query Language
TCL
Transaction Control Language
A ______ acts like a union operator in set mathematics. It returns the unique set of rows found in the collection of both queries. It calculates the distinct set of rows by performing a sort operation that eliminates duplicates. Like the other set operators, the ______ requires that both queries return the same, position, number of columns, and data types.
UNION
A _____________ takes all rows returned by one query and adds the rows returned by another query. It does not filter out duplicate rows. It is most useful when both queries return unique sets because it avoids a sorting operation. Like the other set operators, the UNION requires that both queries return the same, position, number of columns, and data types.
UNION ALL
______ - Ensures that each row for a column must have a unique value
UNIQUE
The _________ statement modifies columns in existing rows.
UPDATE
_________: The part of an SQL SELECT statement that specifies conditions used to determine which rows are in the query results.
WHERE
The ________ wildcard is a substitute for a single character.
_
SQL ______ are used to temporarily rename a table or a column heading.
aliases
SQL _______ are used to specify rules for the data in a table.
constraints
A ____ is a virtual table.
view
In SQL, ______ characters are used with the SQL LIKE operator.
wildcard