Mysql Online Test

1. What is the purpose of user accounts in MySQL?

To organize tables in a database To authenticate and control access To create new databases To optimize query performance

2. Which storage engine is suitable for in-memory databases with low latency requirements?

MyISAM InnoDB MEMORY NDB Cluster

3. What is the primary purpose of the MySQL "Slow Query Log"?

To record successful queries To store query execution plans To identify slow queries To optimize query performance

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

mysqlimport MySQL Workbench mysqlrepair mysqlcheck

5. What is the MySQL configuration file named?

my.ini config.txt mysql.conf my.cfg

6. What is the purpose of the SQL JOIN clause?

To filter data To group data To sort data To combine data

7. What is the purpose of the MySQL "ERROR" log file?

To store user authentication data To log database changes To record database errors To optimize query performance

8. Which feature of MySQL Workbench is commonly used for data migration tasks?

Query Optimizer Schema Diagram Data Modeling Migration Wizard

9. What does the mysqldump utility do in MySQL?

Exports data from MySQL to another database system Performs a full backup of the MySQL server Optimizes query performance Restores data from a binary log

10. What is the default port number for MySQL connections?

3306 5432 1521 80

11. What is the maximum size of an INT data type in MySQL?

64 bits 8 bits 32 bits 16 bits

12. Which SQL clause is used to filter the results of a SELECT query in MySQL?

FROM WHERE GROUP BY ORDER BY

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

Data compression Data encryption Query optimization Reducing SQL injection risk

14. Which storage engine is the default in MySQL as of version 5.5?

MyISAM InnoDB MEMORY NDB Cluster

15. Which data type is used for storing fixed-length character strings?

CHAR VARCHAR TEXT BLOB

16. What SQL statement is used to remove a table's structure and data in MySQL?

DROP TABLE DELETE TABLE REMOVE TABLE ERASE TABLE

17. What is the default port number for MySQL connections?

3306 5432 1521 80

18. What is the purpose of the SQL WHERE clause?

To order the results To filter data To join tables To group data

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

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

20. Who developed MySQL?

Oracle Corporation MySQL Inc. Sun Microsystems MySQL AB (now owned by Oracle Corporation)