Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles by Mahesh Parahar
Page 9 of 14
Difference between JPEG and PNG
JPEG and PNG both are a type of image format to store images. JPEG uses lossy compression algorithm and image may lost some of its data whereas PNG uses lossless compression algorithm and no image data loss is present in PNG format.Following are the important differences between JPEG and PNG.Sr. No.KeyJPEGPNG1Stands forJPEG stands for Joint Photographic Experts Group.PNG stands for Portable Network Graphics.2Compression Algorithm typeJPEG uses lossy compression algorithm.PNG uses lossless compression algorithm.3Image QualityJPEG image may lose some image data causing quality loss.PNG image is of high quality.4Image sizeJPEG image is generally smaller than PNG image of same image.PNG image ...
Read MoreDifference between Use Case and Test Case
Use Cases and Test Cases are two important terms in context of Software Testing. A use case tells how a System will behave or perform a certain task provided the given conditions and a test case contains the actual test data, set of instructions to system and expected result of the interaction with system.Following are the important difference between Use Case and Test Case.Sr. No.KeyUse CaseTest Case1ObjectiveThe objective of Use case is to ascertain a certain output after the set of operations.The objective of test case is to ensure that system is working fine for each given instruction and yields ...
Read MoreDifference between SQL(Structured Query Language) and T-SQL(Transact-SQL).
SQLSQL, Structured Query Language is a non-procedural language and is used by database engines to interpret SQL queries to create/modify/access the database elements.T-SQLT-SQL, Transact-SQL, is a procedural extension to SQL, used by SQL Server. It is similar to PL/SQL of Oracle.Following are the important difference between SQL and T-SQL.Sr. No.KeySQLT-SQL1TypeSQL is non-procedural by nature.T-SQL is procedural by natue.2MethodsSQL provides data manipulation and controlling functions.With T-SQL, we can write own procedures, functions with local variables.3ProprietarySQL is open to use and is common across RDBMS softwares.T-SQL is specific to SQL Server and is proprietary.4Query orderMultiple querires are submitted one by one.Using T-SQL, ...
Read MoreDifference between Organic Search and Paid Search
Organic SearchOrganic Search results are unpaid section of a search result page which appears on search engine page based on their relevance to keyword searched. A website submits its entry to a search engine like google and then based on the contents of the website, search engine ranks the pages based on relevance and quality of content. Organic Search method takes time and lot of efforts to get a high rank in a search engine page.Paid SearchPaid Search results are paid advertisements shown close to organic search results. Paid search ads are shown on highest priority and are shown on ...
Read MoreDifference between Centralized Version Control and Distributed Version Control
Centralized Version ControlCentralized Version Control is a version control system using server/client model and server contains all the history of source code.Distributed Version ControlDistributed Version Control is a version control where each client can have same copy of source code as server has and both server and client maintain history of source code.Following are the important difference between Centralized Version Control and Distributed Version Control.Sr. No.KeyCentralized Version ControlDistributed Version Control1WorkingIn CVS, a client need to get local copy of source from server, do the changes and commit those changes to centeral source on server.In DVS, each client can have a ...
Read MoreDifference between Oracle and SQL Server
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 MoreDifference between MySQL and SQL Server
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 MoreDifference between RDBMS and HBase
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 MoreDifference between RDBMS and OODBMS
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 MoreDifference between OOP and POP
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