Unformatted text preview: CREATE and DROP • DML - (Data Manipulation Language) is concerned with retrieving data, and inserting, updating and deleting data in the database. It includes commands like INSERT, UPDATE, DELETE, SELECT. This category includes DQL (Data Query Language) statements. • DCL - (Data Control Language) is concerned with control issues such as who are the users and what operations can a particular user perform on the database. It includes commands like GRANT and REVOKE. Options for Executing SQL Commands: 1. Interactive (dynamic) o command line (character based), advantage-can run batches or scripts o Graphical User Interface (GUI) --advantage- easier to use, does not require detailed syntax knowledge like command line interface 2. Embedded...
View Full Document
This note was uploaded on 09/21/2011 for the course CGS 2545 taught by Professor Markllewellyn during the Summer '10 term at University of Central Florida.
- Summer '10