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 |
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
What is the purpose of rollback and commit?
How to create a table using embedded sql?
What is reorg in DB2
What is buffrpool? Where we use it ?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
Explain about dbrm.
How can we define a table? How can we apply SEARCH ALL on it ?
when does the SQL statement gets executed when you use cursor in the application programming ?
How can you quickly find out the # of rows updated after an update statement?
What action db2 takes when a program aborts in the middle of a transaction?
Which transaction use a command thread ?