Mysql Online Test

1. Which backup method is suitable for large databases with minimal downtime?

Logical backup Physical backup Remote backup Incremental backup

2. Which SQL statement is used to insert data into a MySQL table?

INSERT INTO UPDATE DELETE FROM CREATE TABLE

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

FROM WHERE GROUP BY ORDER BY

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

MySQL Workbench MySQL Shell phpMyAdmin mysqldump

5. What is the purpose of the COLLATE clause when creating a database?

To set the database name To define the character set To specify the owner To set the storage engine

6. 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

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

Query Optimizer Schema Diagram Data Modeling Migration Wizard

8. Which replication mode in MySQL allows data to flow in multiple directions between servers?

Master-Slave replication Group replication Circular replication Bidirectional replication

9. 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

10. Which global privilege is required to create new databases in MySQL?

CREATE SELECT DELETE ALTER

11. What could cause the "Lost connection to MySQL server during query" error?

A failed database import Excessive concurrent connections Slow query execution Network issues

12. What is GTID in MySQL replication?

Global Transaction Identifier Group Transaction Identifier Geographic Tracking Identifier General Transfer Identification

13. Which SQL clause is used to filter results based on an aggregate function like COUNT or SUM?

ORDER BY HAVING GROUP BY WHERE

14. When creating composite indexes in MySQL, which column should be listed first in the index definition for the best optimization results?

The column with the lowest cardinality The column with the highest cardinality The column with the smallest data type The column with the largest data type

15. What is the primary function of the INFORMATION_SCHEMA database in MySQL?

Storing user data Storing system metadata Managing user privileges Running queries on user data

16. What is the primary use of MySQL's "Stored Procedures"?

To define custom functions To manage user accounts To create transaction logs To encapsulate SQL logic

17. What is the role of the "Data Pump" utility in MySQL migration?

To clean data before migration To transfer data to a new system To optimize query performance To encrypt data

18. What is the purpose of the GRANT statement in MySQL?

To revoke privileges from users To create new databases To modify user account settings To grant privileges to users

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

MyISAM InnoDB MEMORY NDB Cluster

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

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