<ul><li>Delete command is used to delete a particular row or a set of rows from the table which meet the conditions specified in the query.</li><li>Truncate command is used to delete all the rows from a table keeping the table structure intact.</li><li>The different subsets of SQL are DDL, DML, DCL, TCL.</li><li>A DBMS (Database Management System) is a software or technology used to manage data from a database.</li><li>Hierarchical DBMS organizes data in a tree-like structure with parent-child relationships.</li><li>A table is a structured collection of related data organized in rows and columns within a database.</li><li>A field is a single attribute or data type in a table, defining what type of information each entry (row) in the table will hold.</li><li>A foreign key in SQL is a column (or a set of columns) in one table that references the primary key of another table.</li><li>This key is used to create a link between two tables, ensuring referential integrity by making sure that the values in the foreign key column(s) match values in the primary key column(s) of the referenced table.</li><li>SQL questions mentioned in the article will help you to prepare for your interview</li></ul>

Top 5 SQL questions asked in interviews

Discover more