DBMS%20Interview%20Questions%20and%20Answers
Question: What are DML and DDL statements?Answer: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 |
Is it helpful?
Yes
No
Most helpful rated by users:
- What is database or database management systems (DBMS)?
- What is SQL?
- What's the difference between file and database? Can files qualify as a database?
- What’s difference between DBMS and RDBMS?
- How many types of relationship exist in database designing?