What do the initials DDL and DML stand for and what is
their meaning?
Answers were Sorted based on User's Feedback
Answer / s
Data Definition Language CREATE, ALTER, DROP
Data Manipulation Language SELECT, INSERT, UPDATE, DELETE
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / komal riaz
DDL(Data Definition Language) is used for the manipulation
of Tables in SQL. This involves three functions CREATE,ALTER
and DROP.
Whereas DML(Data Manipulation Language) is used for the
manipulation of data in the tables. This involves four basic
functions SELECT,INSERT,UPDATE,DELETE.
Is This Answer Correct ? | 2 Yes | 0 No |
What is the purpose of the WHENEVER statement?
can all users have the privilage to use the sql statement select * (dml)?
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
Is the primary key a clustered index?
What is iseries database?
What DB2 Catalog column tell you when an index needs table reorganized ?
What is the syntax required for the creation of a cursor?
What are the Isolation levels possible ?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
What should be specified along with a cursor in order to continue updating process after commit?
How do I delete a column in db2?