This preview shows page 1. Sign up to view the full content.
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
- Summer '10