Q5. Separate DDL and DML Sql commands from the given queries. I. CREATE TABLE EMPLOYEE(Name VARCHAR2(20),...

Transcribed Image Text:

Q5. 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"; Q5. 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 rating: 100% (QA)

DDL stands for Data Definition Language When we want to create and modify structure of objects in a ... View the full answer