1. Files act locally where as DBMS saves directly in a database

2. Saves in temporary locations where as DBMS in well arranged and permanent data base locations

3. In File System., transactions are not possible where as various transactions like insert, delete, view, updating etc are possible in DBMS

4. Data will be accessed through single or various files where as in DBMS, tables (schema) is used to access data.

5. A "File manager" is used to store all relationships in directories in File Systems where as a data base manager (administrator) stores the relationship in form of structural tables

Utility programs, commonly referred to as just "utilities," are software programs that add functionality to your computer or help your computer perform better. These include antivirus, backup, disk repair, file management, security, and networking programs.

1. Minimum repetition and redundancy: In a database there are high chances of data duplication due to the presence of many users. DBMS resolves this issue by building a repository where all the data are stored and can be accessed by multiple users.
2. Databases of big corporations or companies can only be managed by a database management system. Database management system offers data protection and features like recovery and backup for easy recording and retrieval of data.
3. Enhanced security: Database management systems offer enhanced security by restricting public access. It can only be accessed by a database administrator or the concerned head of the department.
4. Multiple user access: Database is designed in such a way that it can be accessed by multiple users who can work on different sections of the databases at a time without interrupting the flow of work.
5. Provides multiple views of the data: Database management system allows the users to access multiple views of the data present in the database. For e.g an HR personnel can check the database for processing the data of the employee, while at the same time an employee can use the database to access resources related to payslip, attendance, etc.
6. Permanent storage of data: Data stored in a database will remain stored permanently until and unless it is deleted from the system manually. Even in cases of accidental deletion of data, the database system has a robust recovery system which allows recovery of deleted data.

CHAR

1. Used to store character string value of fixed length.
2. The maximum no. of characters the data type can hold is 255 characters.
3. It's 50% faster than VARCHAR.
4. Uses static memory allocation.

VARCHAR

1. Used to store variable length alphanumeric data.
2. The maximum this data type can hold is up to
   • Pre-MySQL 5.0.3: 255 characters.
   • Post-MySQL 5.0.3: 65,535 characters shared for the row.
3. It's slower than CHAR.
4. Uses dynamic memory allocation*.