Question

Separate DDL and DML Sql commands from the given queries.

I. CREATE TABLE EMPLOYEE(Name VARCHAR2(20), Email VARCHAR2(100),

DOB DATE);

II. DROP TABLE EMPLOYEE;

III. ALTER TABLE STU_DETAILS ADD (ADDRESS VARCHAR2(20));

IV. INSERT INTO javatpoint (Author, Subject) VALUES ("Sonoo", "DBMS");

V. UPDATE students SET User_Name = 'Sonoo' WHERE Student_Id = '3'

VI. DELETE FROM Studen_table WHER city= “Peshawar”;​

Answer 1

Answer:

u can choose nceart for solving