ISMN 7836 Chapter 7

Card Set Information

Author:
mjweston
ID:
183427
Filename:
ISMN 7836 Chapter 7
Updated:
2012-11-13 14:07:22
Tags:
Databases
Folders:

Description:
Databases CH 7
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user mjweston on FreezingBlue Flashcards. What would you like to do?


  1. Data Definition Language (DDL)
    statements used for creating tables, relationships, and other database structures
  2. Data Manipulation Language (DML)
    statements used for querying, inserting, updating, and deleting data
  3. SQL/Persistent Stored Modules (SQL/PSM)
    statements which extend SQL by adding procedural programming capabilities, such as variables and flow-of-control statements, that provide some programmability within the SQL framework.
  4. DDL
    Data Definition Language - used for creating tables, relationships, and other database structures
  5. DML
    Data Manipulation Language - statements used for querying, inserting, updating, and deleting data.
  6. SQL/PSM
    SQL/Persistent Stored Modules - statements which extend SQL by adding procedural programming capabilities, such as variables and flow-of-control statements, that provide some programmability within the SQL framework.
  7. SQL Create Table statement
    used to construct tables, define columns and column constraints, and create relationships
  8. SQL DDL Statements:
    • CREATE TABLE
    • ALTER TABLE
    • DROP TABLE
    • TRUNCATE TABLE
  9. SQL DML Statements
    • INSERT
    • UPDATE
    • DELETE
    • MERGE
  10. Explain the IDENTITY property
    IDENTITY(400,5) means that the start value is 400 and are incremented by 5.  Surrogate keys are derined by the system that you have control over.
  11. CREATE TABLE Statement:
    • CREATE TABLE ARTIST(
    •          ColumnName       DataType(Int, Char25)        NullStatus Identity
    •          CONSTRAINT        TableNamePK         PRIMARY KEY(ColumnName)
    • );

What would you like to do?

Home > Flashcards > Print Preview