Complete Computer Knowledge Portal

Wednesday, May 28, 2014

Difference Between Windows 8 and Windows 8.1

Windows 8
Windows 8.1
It is a Personal Computer Operating System Designed by Microsoft and is preceded by Windows 7 Operating System.
It is enhanced version of windows 8 operating system.
Start Button
Start Button is not Present in Windows 8.
Start Button is restored to task bar in Windows 8.1 to open start screen.
App  Snapping
Only two app can be snapped onto a single display.
4 Applications can be snapped onto a single display depending upon screen size.
Message App
Message App is available in Windows 8.
Message is Replaced by Skype, which allows users to accept calls directly from lock screen.

Wednesday, May 21, 2014

Difference Between Database and Data Warehouse

Data Warehouse
Organized Collection of Data is called database.
Database of Databases is Called Data Warehouse.
It is designed to allow the definition, creation, querying, update, administration of data (Transaction Processing).
It is a relational database that is designed for query and analysis rather than transaction processing.
Data Type
Data stored in Database is up to date.
Current and Historical Data is Stored in Data Warehouse.
Transaction Oriented: e.g. Each Transaction of Bank Customer is written to database and is interpreted as Accounting Database.
Subject Oriented: The data in the data warehouse is organized so that all the data elements relating to the same real-world event or object are linked together.

Tuesday, May 20, 2014

Difference Between Data Mining and Machine Learning

Data Mining
Machine Learning
Data mining is a process to extract information from a data set and transform it into an understandable structure for further use.
It is a Technique that concerns the construction and study of systems that can learn from data.
It focuses on the discovery of unknown properties in the data.
It focuses on prediction, based on known properties learned from training data.
Database Size
It is an automatic or semi-automatic analysis that is performed on large quantities of data.
It is generally performed on small databases to increase accuracy.
Association Rules
Sequential Patterns
Sequence Similarity
Un Supervised

Monday, May 12, 2014

Difference Between Blackbox and Whitebox Testing

Black Box Testing
White Box Testing
It is a Software Testing Technique that examines the functionality of an Application without peering into its working or coding.
It is a Software Testing Technique to test internal structure and working of an Application Software.
Technique Applied in
This Technique Applied in Unit, Integration, System and Acceptance levels of Software Testing Process.
This Technique Applied in Unit, Integration and system levels of Software Testing Process.
Test Procedures
For Black box Testing Specific knowledge of the application's coding/internal structure and programming in general is not required.
For White box Testing Specific knowledge of the application's coding/internal structure and programming is required.

Difference Between MAC and IP address

MAC Address
IP Address
Acronym for
media access control address
Internet Protocol Address
Used for
It is a unique identifier that is assigned to network interfaces for communicating on the physical network segments.
It is a numerical value that is assigned to all the participating devices in a network. i.e. Servers, Computers, Printers, WAP, Laptops etc.
Provided BY
It is generally provided by the manufacturer of the NIC cards and is stored in its hardware.
It is provided by the ISP (Internet Service Provider) or by the Network Administrator.