• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

image

PLAY BUTTON

image

PLAY BUTTON

image

Progress

1/12

Click to flip

12 Cards in this Set

  • Front
  • Back
CREATE TABLE
Describes the layout of the table
INTEGER
numbers with no decimal point
SMALLINT
Limited range integer, smaller
DECIMAL(p,q)
Stores a decimal p digits long with q digits being decimal places
CHAR(n)
Character string n characters long
DATE
Stores date in MM/DD/YYYY format
SELECT-FROM-WHERE
Basic form of an SQL command
Compound conditionals
Formed by connecting two or more simple conditionals with AND or OR
Sort Key
field on which to sort data
Subquery
Secondary query inside a query - evaluated first
INSERT
adds new data into a table
INTO
clause used to create table