CIS 407 final Exam Questions and answers, Graded A+. latest updates.
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 nam
Written for
- Institution
- CIS 407
- Course
- CIS 407
Document information
- Uploaded on
- December 29, 2023
- Number of pages
- 16
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
cis 407 final exam questions and answers graded