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