What are the different types of Database management systems. What are the Database languages ? What is the difference between drop, delete and truncate?

Question

Accepted Answer

Different types of DBMS, DB languages & difference between drop, delete & truncate.

Types of DBMS: Relational, NoSQL, Object-oriented, Hierarchical, Network, etc.
Database languages: SQL, PL/SQL, T-SQL, etc.
DROP: Deletes a table and its data, cannot be rolled back.
DELETE: Deletes rows from a table, can be rolled back.
TRUNCATE: Deletes all rows from a table, cannot be rolled back.

Accepted Answer

Database Management System (DBMS) languages are programming languages specifically designed for interacting with and managing databases. These languages provide a set of commands and syntax to perform various operations such as creating, modifying, querying, and deleting data in a database.
Database languages can be classified into three types: declarative, procedural, and object-oriented.

Declarative languages are those in which the user specifies what is to be done, but not how it is to be done.

Procedural languages are those in which the user specifies both what is to be done and how it is to be done.

Object-oriented languages are a type of procedural language that incorporate features of both declarative and procedural languages.
Truncate :

It deletes all the records from an existing table but not the table itself.

Drop:

A DROP statement in SQL removes a component or object from a DB.

Delete:

It is used to delete existing records from an existing table. We can delete a single record or multiple records depending on the condition specified in the query.

What are the different types of Database management systems. What are the Database languages ? What is the difference between drop, delete and truncate?

Top NTT Data Associate/Senior Associate -(Technical) interview questions & answers

Popular interview questions of Associate/Senior Associate -(Technical)

Top HR questions asked in NTT Data Associate/Senior Associate -(Technical)