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 any one expalin check point with an example?
How do you eliminate duplicate values in db2?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
How do you insert a record with a nullable column?
What is a DB2 access path?
Explain about rct in db2?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
How can you display the current date & current time ?
Write a query to retrive partial string.
How to check sequence on a table in db2?
How to resolve -805 error in DB2?
What is a db2 cursor?