CIS 407 Study guides, Class notes & Summaries

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...

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...