ICT 285 Lecture 3 Exam Questions with Correct Answers Latest Update

ICT 285 Lecture 3 Exam Questions with Correct Answers Latest Update SQL Command Types - Answers - Data Definition (DDL) - Data Manipulation (DML) - Data Control (DCL) - Transaction Control (TCL) - Procedural Extensions (SQL/PSM) What is Data Definition (DDL) - Answers A subset of SQL commands used to create, alter, and drop database structures such as tables, views, indexes, and constraints. What is Data Manipulation (DML) - Answers A subset of SQL commands used to retrieve and modify data within database tables, including SELECT, INSERT, UPDATE, and DELETE. What is Data Control (DCL) - Answers A subset of SQL commands used to grant or revoke user privileges on database objects. What is Transaction Control (TCL) - Answers A subset of SQL commands that manage transactions to ensure atomicity, using COMMIT to save changes and ROLLBACK to undo. What is SQL/PSM - Answers SQL Persistent Stored Modules; procedural extensions to SQL that support user-defined functions, triggers, and stored procedures. SQL DDL Command Types - Answers - CREATE TABLE - ALTER TABLE - DROP TABLE - CREATE VIEW - DROP VIEW - CREATE INDEX SQL DML Command Types - Answers - SELECT - INSERT - UPDATE - DELETE SQL DCL Command Types - Answers - GRANT - REVOKE SQL TCL Command Types - Answers - COMMIT - ROLLBACK What is SELECT - Answers A SQL command that retrieves specified columns and rows from one or more tables using clauses like FROM, WHERE, GROUP BY, HAVING, and ORDER BY. What is INSERT - Answers A SQL command that adds new rows to a table, either by specifying values directly or by selecting from other tables. What is UPDATE - Answers A SQL command that modifies existing row values in a table based on specified conditions.