Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

SQL

memorize.ai

memorize.ai (lvl 286)

Section 1

Preview this deck

DDL

Front

1 / 5

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

0

All-time users

0

Favorites

0

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (5)

Section 1

(5 cards)

DDL

Front

Data definition language - involves instructing the DBMS software on what tables will be in the database, what attributes will be in the tables, which attributes will be indexed, and so forth. Create, drop, alter, truncate, comment, rename,

Back

DCL

Front

Data control language -- Used to control ACCESS to data stored in a database.

Back

TCL

Front

Transaction Control Language: COMMIT, ROLLBACK, SAVEPOINT

Back

DML

Front

Data Manipulation Language -- Used to query and update data stored in the tables. Select, update, insert, delete.

Back

SQL

Front

Structured Query Language - a formal setup for building queries

Back