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;
41 Cards in this Set
- Front
- Back
|
DBMS |
Database management system |
|
|
DDL |
Data Definition Language |
|
|
ERD |
Entity-relationship diagram |
|
|
RDBMS |
Relational database management system |
|
|
DML |
Data Manipulation Language |
|
|
TCL |
Transaction Control Language |
|
|
What category is SAVEPOINT |
TCL |
|
|
What category is SELECT in? |
DML |
|
|
What category is DELETE |
DML |
|
|
What category is COMMIT? |
TCL |
|
|
What category is ALTER(1)? |
Data definition changes |
|
|
What category is CREATE? |
Data definition changes |
|
|
What category is DROP |
Data definition changes |
|
|
What category is INSERT |
DML |
|
|
What category is ROLLBACK |
TCL |
|
|
What category is TRUNCATE |
Data definition changes |
|
|
TCL |
Transaction Control Language |
|
|
What category is SAVEPOINT |
TCL |
|
|
What category is MERGE |
DML |
|
|
What category is GRANT |
Data definition changes |
|
|
What category is REVOKE |
Data definition changes |
|
|
What category is FLASHBACK |
Data definition changes |
|
|
What category is PURGE |
Data definition changes |
|
|
What category is COMMENT |
Data definition changes |
|
|
What category is SELECT in? |
DML |
|
|
What category is DELETE |
DML |
|
|
What category is COMMIT? |
TCL |
|
|
What category is ALTER(1)? |
Data definition changes |
|
|
What category is CREATE? |
Data definition changes |
|
|
What category is DROP |
Data definition changes |
|
|
What category is INSERT |
DML |
|
|
What category is ROLLBACK |
TCL |
|
|
What category is TRUNCATE |
Data definition changes |
|
|
SELECT |
Displays data |
|
|
INSERT |
Adds data, directly or through a view |
|
|
UPDATE |
Modified existing data, directly or through a view |
|
|
DELETE |
Removes existing data, directly or through a view |
|
|
MERGE |
Performs a combination of INSERT, UPDATE, and DELETE |
|
|
COMMIT |
Saves a set of DML modifications performed in the current session |
|
|
ROLLBACK |
Undos a set of DML modifications |
|
|
SAVEPOINT |
Creates a point to rollback to |
