-> Its relational database management system used in enterprise applications.
-> Its biggest competitor is Microsoft SQL Server.
-> Runs on Windows,Unix,Linux and Mac Operating systems.
Limitations:
-> A table should not be allowed to contain more than 32 columns.
-> Table must contain only one primary key.
-> If there are any referential integrity constarints on the table then we have to specify “CASCADE CONSTARINT” option to drop the table without any error.
InsertALL:
It used to insert rows into multiple tables at a time.
TRUNCATE TABLE vs DELETE TABLE
Both the statements will remove the data from the table but the main difference is that you can roll back the DELETE statement whereas you can’t roll back the TRUNCATE TABLE statement.