What is the difference between SQL, DDL, and DML?
Answer Posted / pavan_1981
sql is a universally accepeted query language whic acts an
interface to the relational databases to fetch,insert and
manipulate the data existing in the database.
sql encompasses of five parts
1.Data Retrieval Language:the commands used to select data
from the database.this includes
a.select
2.Data manipulation Language:commands to manipulate the
data existing in the database.commands in this are
a.insert
b.update
c.delete
d.merge
3.Data Definition Language:commands to define and create
the database ojects like tables ,views etc.commands in this
are
a.create
b.truncate
c.alter
d.drop
e.describe
f.rename
4.Tranaction control Language:the commands in this are
a.grant
b.revoke
5.Data Control Language:the commands in this are
a.Commit
b.Rollback
c.Savepoint.
Is This Answer Correct ? | 113 Yes | 25 No |
Post New Answer View All Answers
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How will you write a query to get a 5th rank student from a table student_report?
How do I start tns listener?
In which language oracle has been developed?
What happens if you set the sga too low in oracle?
What is hash cluster in oracle?
What is rowid and rownum in oracle?
What is the Tune Query
How to add another datafile to a tablespace?
What is the difference between translate and replace?
What is an oracle wallet?
How can I introduce multiple conditions in like operator?
How to count duplicated values in a column in oracle?
Explain the use of rows option in imp command.
How to update values in a table in oracle?