NA

Correct Option: A

Forks are the drop-in replacement of MySQL. Some of the forks are MariaDB, Drizzle, Percona Server, OurDelta. MariaDB provides compatible general public license(GPL). Drizzle is better to fork than MariaDB, it is largely compatible with MySQL. OurDelta provides a combination of MySQL and MariaDB. Sphinx is a full text search engine of SQL.

NA

Correct Option: A

Copy of data or else database is known as backup. The final method for creating MySQL backups is LVM snapshots. It uses a copy-on-write feature of storage systems in which LVM i.e. Logical Volume Management is the most popular in Linux. It is very quick as it creates the snapshots. CSV stands for Cluster Shared Volumes backups. File backup is the backup of MySQL database which creates a copy of files from MySQL data directory. SQL backups are alternate to File backups.

NA

Correct Option: B

There are various backups in MySQL. File backups, SQL backups, backing up from a slave, CSV backups, Incremental backups are some kind of backups. File backup is the backup of MySQL database which creates a copy of files from MySQL data directory. SQL backups are alternate to File backups.

NA

Correct Option: A

The most basic class of NoSQL is key-value stores and commonly used in web infrastructure. Multidimension stores are more complex data relationships, here data is stored in rows and columns. MongoDB and CouchDB are the examples of Document stores.

NA

Correct Option: A

APC supports four locking methods named File locks, Spin locks, Pthread mutex, IPC semaphores. File locks are the most stable, Spin lock gives the best performance, Pthread mutex is only available in Linux version 2.6, IPC semaphores are faster than file locks.