AfterAcademy Tech
In this blog, we will learn what are the UNION, MINUS, and INTERSECT commands in SQL. We will also see their application with examples.
06 Apr 2020
In this blog, we will learn how to cross-join two tables in DBMS, and what are the benefits of doing it with example.
In this blog, we will learn about the two types of addresses that are used for memory in the operating system. Further, we will discuss the difference among these types of memories i.e. logical memory and physical memory.
In this blog, we will learn about the fragmentation problem that occurs during memory allocation. We will also study the types of fragmentation i.e. internal fragmentation and external fragmentation.
Given a string S, write a program to find the first non-repeating character in it and return its index. The problem needs to be solved in O(n) and needs the knowledge of a hash map to solve.
Given an array arr[ ] of n integers, are there elements x, y, z in arr such that x + y + z = 0? Find all unique triplets in the array which gives the sum of zero. The problem is asked in many interviews and required do be solved in O(n^2) with constant space.
This problem is based on the famous sudoku puzzle. A sudoku board of 9x9 is given and you are expected to fill it correctly. The problem requires knowledge of Backtracking. This is a typical backtracking problem.
Given a bitonic sequence of n distinct elements, write a program to search a given element k in the bitonic sequence. Bitonic Sequence is a sequence of numbers that is first strictly increasing then after a point strictly decreasing.
In this blog, we will first discuss what is Online Transaction Processing and Online Analytical Processing and then learn the difference among them.
In this blog, we will learn how to join two tables in DBMS. We will also learn about the various types of joins, mainly the inner and the outer join.
