Question
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;
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";
Step by Step Solution
There are 3 Steps involved in it
Step: 1
DDL stands for Data Definition Language When we want to create and modify structure of objects in a ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get StartedRecommended Textbook for
Database Systems A Practical Approach to Design Implementation and Management
Authors: Thomas Connolly, Carolyn Begg
6th Edition Global
132943263, 978-0132943260
Students also viewed these Computer Engineering questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App