Term
|
Definition
|
|
Term
|
Definition
Data definition language
Create database objects
Are saved in the schema immediately after executing the query |
|
|
Term
|
Definition
Data manipulation language
Insert, update, delete and retrieve data within database tables
Not saved until you use a specific command to save changes "commit statement" |
|
|
Term
|
Definition
SQL command words
You can not use the order table because order is a reserved word |
|
|
Term
|
Definition
Identified by a username
Include privileges and roles |
|
|
Term
|
Definition
Logical container that contains all of the database objects.
Usually has the same name as the username |
|
|
Term
| Table and column name restrictions |
|
Definition
Names cannot exceed 18 characters
Must start with a letter
Can contain letters, numbers, and underscores
Cannot contain spaces |
|
|
Term
|
Definition
CHAR
VARCHAR
DECIMAL
INT
DATE |
|
|
Term
|
Definition
| Fixed-length character data |
|
|
Term
|
Definition
| Variable length character data |
|
|
Term
|
Definition
| used to represent decimal numbers |
|
|
Term
|
Definition
| used to represent integer values |
|
|
Term
|
Definition
p is the total number of digits to left and right of decimal point
q is the number of digits to the right of decimal point |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Exclude the use of nulls in a column |
|
|
Term
| See the structure of a table |
|
Definition
|
|
Term
|
Definition
INSERT INTO ___
VALUES ( ); |
|
|
Term
| Display all rows and columns in a table |
|
Definition
|
|
Term
|
Definition
UPDATE table_name
SET column_name = expression
WHERE condition_list; |
|
|
Term
|
Definition
DELETE FROM table_name
WHERE condition_list; |
|
|
Term
|
Definition
| Slide 20 , 25 , 32 , 37 , 40 , 42 , 43 , |
|
|
