What is the difference between SQL, DDL, and DML?

Answer Posted / parifs

Structured Query Language (SQL) is a language that provides
an interface to relational database systems.

In common usage SQL also encompasses DML (Data Manipulation
Language), for INSERTs, UPDATEs, DELETEs and DDL (Data
Definition Language), used for creating and modifying
tables and other database structures.

Is This Answer Correct ?    153 Yes 21 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I find the database name in oracle?

597


For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1550


What happens if the update subquery returns multiple rows?

596


What is varray?

580


What are the attributes that are found in a cursor?

639






How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1822


What is transport network substrate (tns) in oracle?

583


How to rebuild an index in oracle?

543


What is difference between truncate and delete?

551


Explain the use of online redo log files in oracle.

575


How to define an external table with a text file?

577


How many types of database triggers exist?

564


What is the difference between PFILE and SPFILE in Oracle?

570


Why does oracle 9i treat an empty string as null?

533


How to delete multiple rows from a table in oracle?

553