Citrus Informatics Database Administrator DBA Interview Questions and Answers

MySQL is open source and widely used, while MSSQL is proprietary and more expensive.

• MySQL is open source, while MSSQL is proprietary

• MySQL is free to use, while MSSQL requires a license

• MySQL is more widely used in web applications, while MSSQL is more commonly used in enterprise applications

• MySQL has better support for Linux, while MSSQL is better suited for Windows environments

Different types of backup include full, incremental, differential, and snapshot backups.

• Full backup: A complete backup of all data and files.

• Incremental backup: Only backs up the changes made since the last backup.

• Differential backup: Backs up all changes made since the last full backup.

• Snapshot backup: Captures the state of the database at a specific point in time.