differences

Primary Key vs Foreign Key

A primary key is used to ensure data in the specific column is unique. It is a column cannot have NULL values. It is either an existing table column or a column that is specifically generated by the database according to a defined sequence. A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables. It is a column (or columns) that references a column (most often the primary key) of another table.

Posted September 9, 2022 by Rohith and Anusha ‐ 1 min read

quick-references blog primary-key foreign-key differences

Process vs Thread

Processes are basically the programs that are dispatched from the ready state and are scheduled in the CPU for execution. PCB(Process Control Block) holds the concept of process. A process can create other processes which are known as Child Processes. Thread is the segment of a process which means a process can have multiple threads and these multiple threads are contained within a process. A thread has three states i.e. Running, Ready, and Blocked.

Posted September 9, 2022 by Rohith and Anusha ‐ 2 min read

quick-references blog process thread differences

Procedural Programming vs Object-Oriented Programming

Procedural Programming can be defined as a programming model which is derived from structured programming, based upon the concept of calling procedure. Procedures, also known as routines, subroutines or functions, simply consist of a series of computational steps to be carried out. Object-oriented programming can be defined as a programming model which is based upon the concept of objects. Objects contain data in the form of attributes and code in the form of methods. In object-oriented programming, computer programs are designed using the concept of objects that interact with the real world.

Posted September 9, 2022 by Rohith and Anusha ‐ 2 min read

quick-references blog procedural-programming object-oriented-programming differences

Stack Allocation vs Heap Allocation

Stack Allocation happens on contiguous blocks of memory. We call it a stack memory allocation because the allocation happens in the function call stack. The size of memory to be allocated is known to the compiler and whenever a function is called, its variables get memory allocated on the stack. Heap Allocation is allocated during the execution of instructions written by programmers. Note that the name heap has nothing to do with the heap data structure. It is called heap because it is a pile of memory space available to programmers to allocate and de-allocate.

Posted September 9, 2022 by Rohith and Anusha ‐ 1 min read

quick-references blog stack heap differences

JDK vs JRE

JDK stands for Java Development Kit. It is a software development environment used to develop Java applications and applets. It is a platform-specific software i.e there are separate installers for Windows, Mac, and Unix systems. JRE stands for Java Runtime Environment. It is the implementation of JVM (Java Virtual Machine) and it is specially designed to provide an environment to execute Java programs. It is also platform dependent like JDK.

Posted September 9, 2022 by Rohith and Anusha ‐ 1 min read

quick-references blog jre jdk differences

Subscribe For More Content