CIS 407 final Exam Questions and answers, Graded A+/ 2024/25 EXAM PREDICTION QUESTIONS/

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 name alters table structure how to drop a table in SQL - -DROP TABLE name; How to insert data into a table - -INSERT INTO name (columns being inserted into) VALUES (values inserted) adds records how to delete data in a table - -DELETE FROM name removes records How to Update data (SQL) - -UPDATE name modifies existing records how to create relationships among tables - -using foreign keys Foreign Key (TableANum) REFERENCES TableA