SQL Database Developer Interview Questions and Answers for Freshers

Delete removes specific rows while truncate removes all rows from a table

• Delete is a DML command while truncate is a DDL command

• Delete can be rolled back while truncate cannot be rolled back

• Delete is slower than truncate as it logs each row deletion

• Delete can have a WHERE clause to specify which rows to delete while truncate cannot

• Example: DELETE FROM table_name WHERE column_name = value;

• Example: TRUNCATE TABLE table_name;

DBMS stands for Database Management System and RDBMS stands for Relational Database Management System.

• DBMS is a software system that allows users to define, create, maintain and control access to databases.

• RDBMS is a type of DBMS that stores data in the form of tables with rows and columns.

• RDBMS uses SQL (Structured Query Language) to manipulate data.

• Examples of popular RDBMS include MySQL, Oracle, and Microsoft SQL Server.