DBMS Interview Questions and Answers
Question: Can you explain Insert, Update and Delete query in DBMS?Answer:Insert statement is used to insert new rows in to table. Update to update existing data in the table. Delete statement to delete a record from the table. Below code snippet for Insert, Update and Delete :- INSERT INTO wbEmployee SET name='maxwell',age='22'; UPDATE wbEmployee SET age='22' where name='maxwell'; DELETE FROM wbEmployee WHERE name = 'david'; |
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?