General SQL related

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

What are the key commands within the TCL category?

COMMIT ROLLBACK SAVEPOINT

What are the commands within the DDL category?

CREATE DROP ALTER TRUNCATE -Affects the overall database/table schema instead of the actual data.

What is DML used for?

Control how you want users to access the data. Define privileges for accessing the data/table.

What are the different types of SQL statements?

DDL - Data Definition Language DML - Data Manipulation Language DCL - Data Control Language TCL - Transaction Control Language DRL - Data Retrieval Language

What is DDL and what does it do?

Data Definition Language Used to define/modify the database objects - table, views.... Auto committed

What is DML used for?

Data Manipulation Language

What are the commands within DCL category?

GRANT REVOKE -Affects accessibility to the database/table.

What are the commands within the DML category?

INSERT UPDATE DELETE MERGE -Affects the data/rows instead of the table or the schema definitions or table.

What is the main command within DRL?

SELECT

What does SQL stand for?

Structured Query Language Means to communicate with a relational database. The instructions given to a database in a structured/defined format and this is SQL.

What is DRL used for?

This defines how the data is retrieved/SELECTED.

What is TCL used for?

This defines how you want the transaction to be controlled. Once connected to the database, and you run commands like insert/delete, the TCL command is used to define how the transaction is controlled. If there is an error - roll back?


Ensembles d'études connexes

Exercise Fifteen Anatomy and Physiology

View Set

Pharmacology Chapter 20 PrepU questions Anxiolytic and Hypnotic Agents

View Set

PN1 Final Exam-NCLEX Exam 2 Elimination/Ethics/Surgery

View Set

Sociology of Families Test 4--Robert Montgomery (Ch 12 & 7)

View Set

Chapter 3: Learning to drive: everyday driving skills

View Set

MS Chapter 11 Course Work - Tides

View Set