Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Both Oracle and SQL Server, both are relational database management systems or RDBMS.Following are the important differences between Oracle and SQL Server.Sr. No.KeyOracleSQL Server1Developed ByOracle Server is owned by Oracle.SQL Server is developed by Microsoft.2Procedural LanguageOracle uses PL/SQL.SQL Server uses T-SQL.3UsageOracle is complex to use.SQL Server is simple to use.4OS SupportWindows, Linux, Solaris, HP-UX and OS X.Windows and Linux.5Database SharingUsers can share databases.Users cannot share databases.6PackageOracle supports Packages.SQL Server has no concept of packages.7PowerfulOracle is more powerful than SQL Server.SQL is way less powerful than Oracle.Read More
Both MySQL and SQL Server, both are relational database management systems or RDBMS. MySQL is open source and is free to use whereas SQL Server is licensed product of Microsoft.Following are the important differences between MySQL and SQL Server.Sr. No.KeyMySQLSQL Server1Owned/Developed ByMySQL is owned by Oracle.SQL Server is developed by Microsoft.2Language supportMySql supports programming languages like C++, Java and has running support for Perl, TCL and Haskel.SQL Server supports programming languages like C++, Java, Ruby, Visual Basic, Delphi, R.3Storage SpaceMySql needs less amount of operational storage space.SQL Server needs large amount of operational storage space.4Query CancellationMySql does not support midway ... Read More
Both RDBMS and HBase, both are database management systems. RDBMS uses tables to represent data and their relationships. HBase is a column-oriented dbms and it works on top of Hadoop Distributed File System (HDFS).Following are the important differences between RDBMS and HBase.Sr. No.KeyRDBMSHBase1DefinitionRDBMS stands for Relational DataBase Management System.HBase has no full form.2SQLRDBMS requires SQL, Structured Query Language.HBase does not need SQL.3SchemaRDBMS has a fixed schema.HBase has no fixed schema.4OrientationRDBMS is row oriented.HBase is column oriented.5ScalablityRDBMS faces problems in scalablity.HBase is highly scalable.6NatureDBMS is static in nature.HBase is dynamic in nature.7Data RetrievalRDBMS data retrieval is slow.HBase data retrieval is fast.8RULERDBMS ... Read More
RDBMS and OODBMS are database management systems. RDBMS uses tables to represent data and their relationships whereas OODBMS represents data in form of objects similar to Object Oriented Programming.Following are the important differences between RDBMS and OODBMS.Sr. No.KeyRDBMSOODBMS1DefinitionRDBMS stands for Relational DataBase Management System.OODBMS stands for Object Oriented DataBase Management System.2Data ManagementData is stored as entities defined in tabular format.Data is stored as objects.3Data ComplexityRDBMS handles simple data.OODBMS handles large and complex data.4TermAn entity refers to collection of similar items having same definition.An class refers to group of objects having common relationships, behaviors and properties.5Data HandlingRDBMS handles only data.OODBMS handles ... Read More
OOPOOP, refers to Object Oriented Programming and its deals with objects and their properties. Major concepts of OOPs are −Class/objectsAbstractionEncapsulationPolymorphismInheritancePOPPOP, refers to Procedural Oriented Programming and its deals with programs and functions. Programs are divided into functions and data is global.Following are the important differences between OOP and POP.Sr. No.KeyOOPPOP1DefinitionOOP stands for Object Oriented Programing.POP stands for Procedural Oriented Programming.2ApproachOOP follows bottom up approach.POP follows top down approach.3DivisionA program is divided to objects and their interactions.A program is divided into funtions and they interacts.4Inheritance supportedInheritance is supported.Inheritance is not supported.5Access controlAccess control is supported via access modifiers.No access modifiers are ... Read More
UMA and NUMA are shared memory models. Multiprocessors are divided among these type of categories. In UMA, Uniform Memory Access, a single memory controller is used and it is applicable for general purpose applications and time sharing applications. In NUMA, Non-Uniform Memory Access, multi memory controllers are used. NUMA is suitable for real-time applications and time critical applications.Following are the important differences between UMA and NUMA.Sr. No.KeyUMANUMA1DefinitionUMA stands for Uniform Memory Access.NUMA stands for Non Uniform Memory Access.2Memory ControllerUMA has single memory controller.NUMA has multiple memory controllers.3Memory AccessUMA memory access is slow.NUMA memory accsss is faster than UMA memory.4BandwidthUMA has ... Read More
All of these functions are used to get character from input and each function returns an integer signifying the status code as well.Following are the important differences between getc(), getchar(), getch() and getche() functions.getc()getc() can read characters from any stream. Returns EOF on failure.Syntaxint getc(FILE *stream);getchar()getchar() can read characters from standard input only.Syntaxint getchar();getch()getch() can read characters from standard input but it does not use any buffer and returns immidately without waiting for enter key pressed.Syntaxint getch();getche()getche() behaves similar to getch() as it can read characters from standard input and it does not use any buffer and returns immidately without ... Read More
This example demonstrates how to add a shadow and a border on circular imageView androidStep 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml. Step 3 − Add the following code to src/MainActivity.javapackage com.app.sample; import androidx.appcompat.app.AppCompatActivity; import androidx.core.graphics.drawable.RoundedBitmapDrawable; import androidx.core.graphics.drawable.RoundedBitmapDrawableFactory; import android.content.Context; import android.content.res.Resources; import android.graphics.Bitmap; import android.graphics.BitmapFactory; import android.graphics.Canvas; import android.graphics.Color; import android.graphics.Paint; import android.os.Bundle; import android.view.View; import android.widget.Button; import android.widget.ImageView; import android.widget.RelativeLayout; import android.os.Bundle; public class MainActivity extends AppCompatActivity ... Read More
This example demonstrates how to bind data from a database to an Android CheckBox in a ListView.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml. Step 3 − Add the following code to res/layout/row_item.xml. Step 4 − Add the following code to src/MainActivity.javapackage com.app.sample; import androidx.appcompat.app.AppCompatActivity; import android.view.View; import android.widget.AdapterView; import android.widget.ListView; import java.util.ArrayList; import android.os.Bundle; public class MainActivity extends AppCompatActivity { ArrayList dataModels; ListView ... Read More
This example demonstrates how to Justify Text in TextView on Android.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml. Step 3 − Add the following code to res/layout/list_item.xml Step 4 − Add the following code to src/MainActivity.javapackage com.app.sample; import androidx.appcompat.app.AppCompatActivity; import androidx.recyclerview.widget.LinearLayoutManager; import androidx.recyclerview.widget.RecyclerView; import android.os.Bundle; import java.util.ArrayList; import java.util.List; public class MainActivity extends AppCompatActivity { private final String TAG = "MainActivity"; private ... Read More