Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

Organizational Research By

Surprising Reserch Topic

What are DML and DDL statements?

DML stands for Data Manipulation Statements. They update data values in table. Below are the most important DDL statements:- 
=>SELECT - gets data from a database table 
=> UPDATE - updates data in a table 
=> DELETE - deletes data from a database table 
=> INSERT INTO - inserts new data into a database table
DDL stands for Data definition Language. They change structure of the database objects like table, index etc. Most important DDL statements are as shown below:- 
=>CREATE TABLE - creates a new table in the database. 
=>ALTER TABLE ‚Äď changes table structure in database.¬†
=>DROP TABLE - deletes a table from database 
=> CREATE INDEX - creates an index 
=> DROP INDEX - deletes an index

asked Sep 13, 2013 in Database(DBMS) by rajesh
edited Sep 12, 2013
0 votes

Related Hot Questions

Government Jobs Opening