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 is meant by a deadlock situation?
Explain the use of rows option in imp command.
What is an Oracle index?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Give the constructs of a package, function or a procedure.
How to use like conditions in oracle?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What are the different types of partitions in oracle?
What is the difference between a hot backup and a cold backup in oracle?
What happens to the indexes if a table is recovered?
What is meant by recursive hints in oracle?
What do you understand by a database object?
What are the set operators union, union all, minus & intersect meant to do?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What is a select query statement in oracle?