Mysql Online Test

1. What data type would you use to store a true/false value in MySQL?

BOOL TINYINT BOOLEAN BIT

2. How can you update data in multiple rows with a single MySQL UPDATE statement?

Use multiple UPDATE statements Use a SELECT statement with UPDATE Use a JOIN clause with UPDATE Update each row individually

3. What is the purpose of the InnoDB storage engine's doublewrite buffer in MySQL?

To create a duplicate database To reduce backup file size To prevent data corruption during crashes To store compressed data

4. What does SQL stand for?

Structured Language Simple Language Structured Query Language Standard Query Language

5. Which tool is commonly used to perform database backups in MySQL?

mysqldump MySQL Workbench phpMyAdmin MySQL Connector

6. What is the purpose of the SQL GROUP BY clause?

To filter data To join tables To group data To sort data

7. Which MySQL privilege is required to create new users?

CREATE USER CREATE ACCOUNT CREATE PRIVILEGE CREATE DATABASE

8. What is the primary reason for the "InnoDB: Error: Table space is full" error in MySQL?

Excessive connections Running out of disk space Query cache issues Encryption errors

9. What is the primary benefit of using stored procedures in MySQL security?

Data compression Data encryption Query optimization Reducing SQL injection risk

10. MySQL is an open-source ________ database management system.

relational proprietary free commercial

11. What is the primary advantage of using the "Replication" method for database migration in MySQL?

It is a one-time, irreversible process It allows for real-time data synchronization It works only with the InnoDB storage engine It doesn't require any additional tools

12. Which storage engine is known for its support of transactions and foreign keys?

MyISAM InnoDB MEMORY NDB Cluster

13. What is a common reason for the "Can't connect to MySQL server on 'localhost'" error?

Incorrect database password Missing client libraries Insufficient disk space Query optimization issues

14. How can you delete all rows from a MySQL table?

DELETE * FROM DELETE ALL DELETE FROM ALL TRUNCATE TABLE

15. Which MySQL command is used to analyze and optimize the performance of queries and the tables they involve?

OPTIMIZE TABLE ANALYZE TABLE EXPLAIN INDEX TUNING

16. Which MySQL tool is commonly used to execute SQL scripts and automate administrative tasks?

MySQL Workbench MySQL Shell phpMyAdmin mysqldump

17. Which SQL statement is used to retrieve data from a database?

FETCH UPDATE SELECT INSERT

18. Which MySQL tool can you use to check and repair corrupted tables?

mysqlimport MySQL Workbench mysqlrepair mysqlcheck

19. When is it appropriate to use a full-text index in MySQL?

When searching for exact matches When searching for partial text matches When sorting rows in a table When working with numerical data

20. Which feature in MySQL is used for High Availability and automatically redirects read operations to a standby server?

GTID Failover ProxySQL Multi-Source Replication