What is the difference between SQL, DDL, and DML?
Answer Posted / animesh
SQL IS A STRUCTURED QUERY LANGUAGE THROUGH WHICH WE CAN
COMMUNICATE WITH THE ORACLE SERVER AND SQL STATEMENTS ARE
DIVIDED INTO FIVE STATEMENTS i:e. Data defintion language
(DDL) which is used in creating the tables,views. In DDL
create,
Alter,
Drop,
Rename,
Trucate comes.
where as Data Manipulation Language(DML)command is used to
manipulate the data.In DML
Insert,
Update,
Delete,
Merge.
the third one is Data retrieval i:e. the select command
the fourth one is Transcation control i:e.
commit,Rollback,savepoint.
the fifth one is data control language(DCL) i:e.
grant,revoke
Is This Answer Correct ? | 53 Yes | 15 No |
Post New Answer View All Answers
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
types of indexes and the rationale behind choosing a particular index for a situation.
What is the purpose of tables, private synonyms and public synonyms in Oracle?
What is the difference between Delete, Truncate and Drop in Oracle?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What is a cursor in oracle?
What privilege is needed for a user to query tables in another schema?
How data locks are respected in oracle?
How do I spool in oracle?
Explain mutating triggers.
What are the major difference between truncate and delete?
What is the use of aggregate functions in oracle?
What are the execution control statements?
Why we use bulk collect in oracle?
What happens if you lost a data file?