Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems A Practical Approach to Design Implementation and Management

Authors: Thomas Connolly, Carolyn Begg

6th Edition Global

132943263, 978-0132943260

More Books

Students also viewed these Computer Engineering questions

Question

What are the aims of static typing and dynamic evaluation?

Answered: 1 week ago