All Round Experts: June 2014

Thursday, 5 June 2014

Parameter	Windows	Linux
Introduction	It is an Operating System developed by Microsoft and named Windows on November 20, 1985 as a graphical operating system shell for MS-DOS	Linux is a Unix Like Operating System introduced by Linus Torvalds and was first released on 5 October 1991.
License Type	Proprietary Commercial Software and must have to be Purchased before using Windows OS.	Except Red Hat all versions are free and are distributed under GNU GPL License.
File System Supported	NTFS,FAT,FAT 32, ISO 9660, UDF,	Ext,Ext2, Ext3, Ext3, ReiserFS, FAT, ISO 9660, UDF, NFS, NTFS, JFS, XFS, Minux and GmailFS
Versions	Windows XP, Windows Vista, Windows 7, Windows 8, Windows 8.1 etc.	Red Hat, Suse Linux, Debian, Knoppix, Ubuntu etc.

Parameter	HTML 4.01	HTML 5.0
Doctype Declaration	Three Types of <!DOCTYPE> declarations are used in HTML 4.01 and that are: i) HTML 4.01 Strict ii) HTML 4.01 Transitional iii) HTML 4.01 Frameset	There is Only one type of <!DOCTYPE> declaration in HTML 5 and that is <!DOCTYPE html>only.
Plugin Requirement	External Plugins are required to play audio and video files on HTML 4.01.	HTML 5 does not require any external plugin to play audio and video files.
Attributes	Accept, Accept-charset, Action, Enctype, Method, Name, Target.	Accept-charset, Action, Enctype, Method, Name, Target, Autocomplete, Novalidate.
Input Types	Button, Checkbox, File, Hidden, Image, Password, Radio, Reset, Submit, Text.	Button, Checkbox, File, Hidden, Image, Password, Radio, Reset, Submit, Text, Color, Date, Datetime, Datetime-local, email, Month, Number, Range, Search, Tel, Time, Url, Week
Automatic Validation	Not Supported in HTML 4.01 and is achieved by other Scripting Languages.	Automatic Filed Validation is Supported in HTML 5.0

Parameter	DBMS	RDBMS
Acronym for	Data Base Management System	Relational Data Base Management System
Relation	Data is stored in flat file oriented System and no relations are used.	It provides facility to create relation between tables.
Dr. E.F. Codd Rules	Only 3 rules, Out of 12, are followed by DBMS. (from Rule 0 to Rule 12)	Minimum 6 rules, Out of 12, are followed by RDBS. (from Rule 0 to Rule 12)
Data Security	It can’t implement constraints in Tables and has less Security. The ACID (Atomicity, Consistency, Isolation and Durability) property of the database is ensured by Programmer.	It can implement the integrity constraint for the purpose of holding ACID (Atomicity, Consistency, Isolation and Durability) property of the database and is much securing than DBMS.
Generation	3GL	4GL
Users Supported	Single User database, Microsoft Access, Lotus Approach are the best examples of personal database management software.	Multi User Database. E.g. SQL Server can be used my many users on the same time.