Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
18 Cards in this Set
- Front
- Back
|
Define SQL
|
Structured query language
or standard query language for relational databases |
|
|
what are the 2 basic catagories
|
Data Definition Language(DDL)
Data Manipulation Language(DML) |
|
|
Define Table
|
Primary data object in relational database
|
|
|
Define constraint
|
Restrictions on data values that columns can store
|
|
|
What is the orcale naming standard
|
1 - 30 characters long
|
|
|
what are the basic types of data
|
Character, number, date/time, larger objects
|
|
|
Define Character data type
varchar2 |
variable length character up to 4000 characters
|
|
|
Define Character data type
char |
fixed length character up to 2000 characters
|
|
|
Define Character data type
nvarchar2 and nchar |
COUNTER PART OF varchar2/char uses unicode
|
|
|
Define Character data type
number |
used for all numeric data
|
|
|
Define Character data type
dATE |
Stores the date
|
|
|
Define Character data type
timestamp |
stores the date values similar date to data type, include sec.
|
|
|
Name the two typs of constraints
|
Integrity Constraint and Value Constraint
|
|
|
What are the levels of constraint
|
table constrain
column constraint |
|
|
define table constraint
|
Restrict data value with respect to all other values in table
|
|
|
Define Column constraint
|
Limit value for specific column
|
|
|
define script
|
text file that contains serveral related sql codes
|
|
|
Define View
|
Enables DBMS to present data in different form based on user needs
|
