Term
|
Definition
| RDBMS, are relational database management systems, a database that stores structured data and there is a relation between the data. |
|
|
Term
|
Definition
| Entity Relationship Diagram, relationship schema document. |
|
|
Term
| Four Main Subsets of the SQL language? |
|
Definition
DATA CONTROL LANGUAGE
DATA DEFINITION LANGUAGE
DATA MANIPULATION LANGUAGE
TRANSACTION CONTROL LANGUAGE |
|
|
Term
|
Definition
| Data control language, control the privileges of users in the database. |
|
|
Term
|
Definition
| Data definition language, used to define data structures such as to create, alter, or drop tables. |
|
|
Term
|
Definition
| Data manipulation language, used to retrieve and manipulate data, one command; select, is a read-only command. |
|
|
Term
|
Definition
| Transaction control language, a set of commands that perform a specific task on objects for a single line of execution. Deals with the transactions in databases. |
|
|
Term
|
Definition
| SELECT, INSERT, UPDATE AND DELETE. |
|
|
Term
|
Definition
'a%' - Characters that start with a
'%a' - Characters that end with a
'%or%' - Characters that have the word "or"
'%h_t%' = Words that have h and t but will replace the middle character with whatever word. |
|
|
