Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SQL, DDL, and DML?
- 7 Answers
- 73949 Views
- BeBo Technologies, Wipro, I also Faced
- E-Mail Answers
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
How to use regular expression in pattern match conditions in oracle?
What is the sql query to concatenate column values from multiple rows in oracle?
What is a table in oracle?
How to connect asp pages to oracle servers?
How to update values in a table in oracle?
How to store only time; not date and time?
Explain oracle 12c new features for developers?
Explain about functional dependency and its relation with table design?
Can sub procedure/function be called recursively?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
Which are the five query types available in oracle?
What is a select query statement in oracle?
What is the difference between a primary key & a unique key?
Where is the export dump file located?
How to use "if" statements on multiple conditions?
