Cloning operation in SQL allows the user to create the exact copy of an existing table along with its definition, that is completely independent from the original table. Thus, if any changes are made to the cloned table, they will not be reflected in the original table.
Simple Cloning: Creates a new table containing same records of existing table but void of any constraints or indexes etc.
Shallow Cloning: Creates a new empty table with the same table definition of an existing table.
Deep Cloning: Creates a new table and copies the table structure and data of an existing table to the new table.
0-2 years experience
2-5 years experience
5-8 years experience
8+ years experience
