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
Información del documento
- Subido en
- 29 de diciembre de 2023
- Número de páginas
- 16
- Escrito en
- 2023/2024
- Tipo
- Examen
- Contiene
- Preguntas y respuestas