Posts

Showing posts from April, 2023
Image
 A. ENGAGE Instruction: Based on your own understanding, kindly define the following terminologies:  A. DATA DEFINITION LANGUAGE  Data Definition (DDL) is capable of creating a framework for database by specifying the schema of the database. Its common uses include the creation and alteration of tables, indexes, files and columns within the database. B. INTERACTIVE DATA MANIPULATION LANGUAGE  Interactive Data Manipulation Language or IDML is designed to allow users to manipulate data in a specified database, specifying a series of commands on what to be executed by the database. C. EMBEDDED DATA MANIPULATION LANGUAGE Embedded Data Manipulation Language or EDML is typically embedded within another programming or scripting language and provides a set of commands that an be used to manipulate data structures and perform data analysis tasks. B. EXPLORE & EXPLAIN 1. What are the basic sql expression?  The basic sql expressions: SELECT to extract data from the database, UPDATE to update