• 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/14

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;

14 Cards in this Set

  • Front
  • Back

Data manipulation language (DML)

command used by users to query and maintain existing data


EX. SELECT, INSERT, UPDATE, DELETE

Data definition language (DDL)

used by developers to maintain databases


EX. CREATE, ALTER, DROP

Data control language (DCL)

commands used by administrators to control database security and access.


ex. GRANT, REVOKE

PRIMARY KEY

unique Identifier

Composite key

consists of more than one attribute to uniquely identify an entity occurrence. Used for creating intersection tables. Syntax in sql is



CONSTRAINT alias_name PRIMARY KEY (animal_id, anotherpk_ID);

DEFAULT Field

gives the field a default value. Syntax



name varchar(35) DEFAULT 'FLEA');

foreign key

is a field (or collection of fields) in one table that uniquely identifies a row of another table. 1] In a simpler words, a foreign key is defined in the second table, which is referring the primary key of the first table. Shown as an underlined value in tables.

cascade

type of foreign key constraint. Deleting or updating the value in the parent able automatically deletes or update the value in the child table.

Restrict

rejects the delete or update operation in the parent table (default option in sql).

Set null

deleting or updating the value in parent table sets the value in the child table to null.

DROP TABLE

drops a table, and if the table has a child may delete depending on constraints.

INSERT

inserts data into tables (character and date fields must be within single quotes.)

DELETE

deletes specific records in a table;

TRUNCATE

deletes all rows of a table