Preview 3 out of 16 pages
Exam (elaborations)
CIS 407 final Exam Questions and answers, Graded A+. latest updates.
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 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
Document information
- Uploaded on
- December 29, 2023
- Number of pages
- 16
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
$10.99
Wrong document? Swap it for free
Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
