Reading...
Play button
Play button
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;
6 Cards in this Set
- Front
- Back
|
DML (Data Manipulation Language)
|
SELECT – select records from a table
INSERT – insert new records UPDATE – update/Modify existing recordsDELETE – delete existing records |
|
|
statements are used to alter/modify a database or table structure and schema. These statements handle the design and storage of database objects.
|
DDL (Data Definition Language)
|
|
|
statements control the level of access that users have on database objects.
|
DCL (Data Control Language)
|
|
|
statements allow you to control and manage transactions to maintain the integrity of data within SQL statements.
|
TCL (Transaction Control Language)
|
|
|
GRANT – allows users to read/write on certain database objectsREVOKE – keeps users from read/write permission on database objects
|
DCL (Data Control Language)
|
|
|
BEGIN Transaction – opens a transactionCOMMIT Transaction – commits a transactionROLLBACK Transaction – ROLLBACK a transaction in case of any error
|
TCL (Transaction Control Language)
|
