• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/13

Click to flip

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?