Computer Science
Differentiate between DDL and DML. Mention the two commands for each category.
SQL Queries
3 Likes
Answer
| Data Definition Language (DDL) | Data Manipulation Language (DML) |
|---|---|
| DDL provides a set of definitions to specify the storage structure and access methods used by the database system. | DML is a language that enables users to access or manipulate data as organized by the appropriate data model. |
| DDL commands are used to perform tasks such as creating, altering, and dropping schema objects. They are also used to grant and revoke privileges and roles, as well as for maintenance commands related to tables. | DML commands are used to retrieve, insert, delete, modify data stored in the database. |
| Examples of DDL commands are CREATE, ALTER, DROP, GRANT, ANALYZE etc. | Examples of DML commands are INSERT, UPDATE, DELETE, SELECT etc. |
Answered By
2 Likes
Related Questions
Differentiate between primary key and candidate key in a relation.
What do you understand by the terms Cardinality and Degree of a relation in relational database?
Write SQL Commands for (i) to (v) and write the outputs for (vi) to (viii) on the basis of the following table:
Table: FURNITURE
NO ITEM TYPE DATEOFSTOCK PRICE DISCOUNT 1 White Lotus DoubleBed 2002-02-23 3000 25 2 Pinkfeathers BabyCot 2002-01-29 7000 20 3 Dolphin BabyCot 2002-02-19 9500 20 4 Decent OfficeTable 2002-02-01 25000 30 5 Comfortzone DoubleBed 2002-02-12 25000 30 6 Donald BabyCot 2002-02-24 6500 15 (i) To list the details of furniture whose price is more than 10000.
(ii) To list the Item name and Price of furniture whose discount is between 10 and 20.
(iii) To delete the record of all items where discount is 30.
(iv) To display the price of 'Babycot'.
(v) To list item name, type and price of all items whose names start with 'D'.
(vi) SELECT DISTINCT Type FROM Furniture;
(vii) SELECT MAX(Price) FROM Furniture WHERE DateofStock > '2002-02-15' ;
(viii) SELECT COUNT(*) FROM Furniture WHERE Discount < 25 ;
Write SQL Commands/output for the following on the basis of the given table GRADUATE:
Table: GRADUATE
S.No. NAME STIPEND SUBJECT AVERAGE RANK 1 KARAN 400 PHYSICS 68 1 2 RAJ 450 CHEMISTRY 68 1 3 DEEP 300 MATHS 62 2 4 DIVYA 350 CHEMISTRY 63 1 5 GAURAV 500 PHYSICS 70 1 6 MANAV 400 CHEMISTRY 55 2 7 VARUN 250 MATHS 64 1 8 LIZA 450 COMPUTER 68 1 9 PUJA 500 PHYSICS 62 1 10 NISHA 300 COMPUTER 57 2 (i) List the names of those students who have obtained rank 1 sorted by NAME.
(ii) Display a list of all those names whose AVERAGE is greater than 65.
(iii) Display the names of those students who have opted COMPUTER as a SUBJECT with an AVERAGE of more than 60.
(iv) List the names of all the students in alphabetical order.
(v) SELECT * FROM GRADUATE WHERE NAME LIKE "%I%";
(vi) SELECT DISTINCT RANK FROM GRADUATE;