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;
13 Cards in this Set
- Front
- Back
Who originally developed SQL? |
IBM in the 1970 |
|
SQL-92 is what kind of standard adopted when? |
An ANSI national standard adopted in 1992 |
|
What is the current standard of SQL? |
SQL:2008 |
|
Is SQL a programming language? |
NO it is a data sublanguage |
|
SQL is comprised of what two different languages? |
Data Definition Language(DDL) -Used to define database structures Data manipulation language(DML) -Data definition and updating -Data retrieval (Queries) Also there is concurrency control and transaction control
|
|
What does the SQL data definition "CREATE" mean? |
To create database objects |
|
What does the SQL data definition "ALTER" mean? |
To modify the structure and/or characteristics of database objects |
|
What does the SQL data definition "DROP" mean? |
To delete database objects |
|
What does the SQL data definition "TRUNCATE" mean? |
To delete table data while keeping structure |
|
How to create a table in SQL? |
|
|
How to create database tables with primary key constraints? |
|
|
How to create database tables with composite primary keys using PRIMARY KEY constraints? |
|
|
How to create database tables using PRIMARY KEY and FOREIGN KEY constraints? |
|