MySQL: Invisible Index

Invisible Index MySQL index decides an option to the availability of the index for the query optimizer. This index shows the visible and invisible options to displays the index column in the table. MySQL maintains the invisible indexes and keeps them updated when the...

Stack implementation in C

Stack implementation in C Stack stores the data in a particular order. It is a linear data structure that follows the principle of the Last In First Out (LIFO) technique where the elements added at the end will be the first ones to eliminate while the elements added...

MySQL: Descending Index

Descending Index It is a type of index that stores key values in descending order. This query improves the performance of an index query. MySQL system displays the index as per column order in the table. Suppose you want to display the index in order as per your...

MySQL: Full text index

Full text index The full-text index in the table isused to search the full text of the data. This index assigns to the table using a “FULLTEXT” keyword. First, the table column changes, then the full-text index updates or recreate. MySQL version 5.6 allows...

Clustered vs Non-Clustered Index

Clustered vs. Non-Clustered Index The difference between clustered and non-clustered index is the most famous question in the database-related interviews. Both indexes have the same physical structure and are stored as a BTREE structure. This article will explain the...

Who invented television?

Who invented television? The word ‘Television’ is derived from the Greek prefix ‘tele’ and the Latin word ‘vision.’ Till 1947, the number of television in the US homes was measurable, and that was in thousand, but in late 1990, it...

Who invented email?

Who invented email? Email (Electronic mail) is a mode of exchanging messages among people through electronic devices. We cannot underestimate the value of email in modern corporate communication. Millions of emails are being sent and received worldwide daily because...

CSIR Full Form

Full Form of CSIR- Council of Scientific and Industrial Research CSIR is the abbreviated form of Council of Scientific and Industrial Research. CSIR was established in September 1942 by the Government of India; it is an independent body that has appeared as one of the...

CSR Full Form

Full Form of CSR – Corporate Social Responsibility CSR stands for Corporate Social Responsibility. It is a concept of management. As per this concept, the companies combine or merge their social, environmental concerns or issues of their business or operations...

Who Invented Mobile?

Who Invented Mobile? You’ve been using the phone for a long time, but have you ever wondered who invented it? In this article, we are going to discuss who invented the phone. In the past, we used to have a small Nokia phone on which we could play games like...

ECS Full Form

Full Form of ECS- Electronic Clearing Service ECS refers to electronic clearing services. ECS is a scheme of electronic mode. It helps in transferring funds from one bank account to another. This scheme permits electronic transactions, including credit or debit, and...

FIFA Full Form

Full Form of FIFA – “Federation Internationale de Football Association” The French acronym FIFA stands for “Federation Internationale de Football Association.” Another term for this is the International Federation of Association...

DNS Full Form

Full Form of DNS- Domain Name System DNS refers to the Domain Name System. DNS is connected to the internet. DNS is a system that is focused on a specific system that is using Internet Protocol. The entire internet system relies on the IP or the Internet Protocol...

MATLAB Variables

What are variables? A variable is a storage location or a container to store or hold data. In programming, variables are used to reservedata created by the programmers so that it can be used later. Variable points a logical address in the memory of a system to...

MATLAB Loops

Loops in programming Concept of looping is used to execute instructions repeatedly. It helps coders to reduce lines of code by setting a condition. In looping first a condition is fixed, then set of instructions are repeated till the condition is satisfied. For...

MATLAB Control Statements

What are control statements? The name itself suggests that something is being controlled, these control statements decide or alter the flow of execution ina program. In program, we often need to modify or alter few lines of code, these control statement helps to...

MATLAB’s Array

What is an Array? An array is a collection of similar datatype elements in contiguous memory location. Every element in array is stored with an index number starting from 0. First element of an array is stored in 0th position index. Any element can be easily accessed...

FBI Full Form

Full Form of FBI FBI- Federal Bureau of Investigation FBI is the short form of Federal Bureau of Investigation. FBI refers to the national security and intelligence service of the United States of America. FBI is also known as the main federal law enforcement agency....

ESI Full Form

Full Form of ESI – Employees State Insurance ESI is the abbreviated form of Employees State Insurance. It refers to the health insurance plan. It is a plan or scheme that offers the workers or labourers of India with benefits. These benefits include medical, cash or...

Python program for perfect number

Python program for perfect number Before writing any program for a given problem, we have to understand the problem for which we are creating a solution program. So, let’s understand what a perfect number is. Perfect number If a given number is equal to the sum...

Pin It on Pinterest