CIS 407
Latest uploads at CIS 407. Looking for notes at CIS 407? We have lots of notes, study guides and study notes available for your school.
-
3
- 0
- 0
All courses for CIS 407
-
CIS 407 3
Latest notes & summaries CIS 407
CIS 407 final Exam Questions and 
answers, Graded A+ 
What is the difference between DDL, DML, and DCL? Examples? - -DDL (data definition language) = 
define and manage structure of the database 
ex. create, alter, drop table 
DML (data manipulation language) = manipulate data 
ex. insert into table, update, delete from 
DCL (data control language) = controls access to data 
ex. grant, revoke 
How to create a table in SQL - -CREATE TABLE name ( 
how to alter a table in SQL - -ALTER TABLE nam...
- Exam (elaborations)
- • 16 pages's •
-
CIS 407•CIS 407
Preview 3 out of 16 pages
CIS 407 final Exam Questions and 
answers, Graded A+ 
What is the difference between DDL, DML, and DCL? Examples? - -DDL (data definition language) = 
define and manage structure of the database 
ex. create, alter, drop table 
DML (data manipulation language) = manipulate data 
ex. insert into table, update, delete from 
DCL (data control language) = controls access to data 
ex. grant, revoke 
How to create a table in SQL - -CREATE TABLE name ( 
how to alter a table in SQL - -ALTER TABLE nam...