FINALS- LECTURE ACTIVITY TASK MODULE 4

I. LEARNING TASKS 

A. ENGAGE 
Instruction: Based on your own understanding, kindly answer the question: 

WHAT IS SQL?

    It comprises Database Creation, Database Deletion, Fetching Data Rows, Modifying & Deleting Data Rows, etc. SQL is a language used to run databases. Structured Query Language, sometimes known as SQL, is a computer language used to store, manipulate, and retrieve data from relational databases. The American National Standards Institute (ANSI) and the International Organization for Standardization (ISO) both adopted SQL as a standard in 1986 and 1987, respectively. SQL was created by IBM computer scientists in the 1970s.

B. EXPLORE & EXPLAIN

Answer the following questions:

1. What are some sql commands?

    - SELECT and FROM, CREATE TABLE, ALTER TABLE, UPDATE, CREATE DATABASE, DESC, DELETE, INSERT and etc..

.

2. What is the difference between drop and delete command?

    - Delete statement performs conditional based deletion, whereas Drop command deletes entire records in the table. Delete statement removes only the rows in the table and it preserves the table structure as same, and Drop command removes all the data in the table and the table structure.

C. ELABORATE & EVALUATION

Answer the following questions: Identification

SQL Statements 1. Extracts data from a database.

INSERT INTO statement 2. Inserts new data into a database.

ALTER TABLE statement 3. Modifies a table.

SQL 4. A standard language for accessing and manipulating databases.

GRANT 5. Can set permissions on tables, procedures, and views.