differences
Delete vs Drop
Delete is a Data Manipulation Language command, DML command and is used to remove tuples/records from a relation/table. Whereas Drop is a Data Definition Language, DDL command and is used to remove named elements of schema like relations/table, constraints or entire schema.
Delete vs Truncate
Both the Truncate statement and the Delete statement are included in the category of SQL queries for deleting the data stored in a table. They carry out deletion operations on records or rows of a table that are no longer needed.
Posted September 12, 2022 by Rohith ‐ 2 min read
Linear Search vs Binary Search
Linear search is a search that finds an element in the list by searching the element sequentially until the element is found in the list. On the other hand, a binary search is a search that finds the middle element in the list recursively until the middle element is matched with a searched element.
Posted September 12, 2022 by Rohith and Anusha ‐ 2 min read
⌖ quick-references blog linear-search binary-search differences
Tree vs Graph
A tree is a non-linear data structure that represents the hierarchy. A tree is a collection of nodes that are linked together to form a hierarchy. A graph is like a tree data structure is a collection of objects or entities known as nodes that are connected to each other through a set of edges. A tree follows some rule that determines the relationship between the nodes, whereas graph does not follow any rule that defines the relationship among the nodes. A graph contains a set of edges and nodes, and edges can connect the nodes in any possible way.
Stack vs Array
Stack is a linear data structure that appears like a list. A stack appears like a sequential collection of constituting elements. Array is also a linear data structure that consists of a collection of various elements that have the same data type. An array’s size is pre-decided. It stores all the values at a location known as the index of values.