Mysql Online Test

Instructions:

This practice test has 20 questions
You have to attempt all the questions
Time will be 05:00 minute for 20 questions. After 05:00 minute, practice test will be submitted automatically and you will redirect to result page.
This practice test is for self evalutation, if you get less marks then passing marks. Please prepare more for get excellent mark next time
Best of luck :)

1. Who developed MySQL?

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

2. What SQL command is used to delete a user account in MySQL?

REMOVE USER DROP USER DELETE USER ERASE USER

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

GTID Failover ProxySQL Multi-Source Replication

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

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

Master-Slave replication Group replication Circular replication Bidirectional replication

6. Which storage engine in MySQL is known for its excellent performance with read-heavy workloads and supports MyISAM and MEMORY table types?

InnoDB NDB Cluster MyISAM Memory

7. What is MySQL Workbench primarily used for?

Server administration Query optimization Data modeling Backup and recovery

8. Which SQL statement is used to add new data to a database?

UPDATE INSERT ADD CREATE

9. Which command is used to show a list of all available databases in MySQL?

SHOW DATABASES LIST DATABASES DISPLAY DATABASES DESCRIBE DATABASES

10. What does the "Deadlock" error in MySQL indicate?

A server crash A query optimization issue A situation where two or more transactions block each other A corrupted table

11. What is the significance of the utf8mb4 character set in MySQL databases?

It supports 4-byte Unicode characters It is used for numeric data It stores binary data It is specific to MySQL 4.x versions

12. Which statement is used to create a new user account in MySQL?

CREATE USER ADD USER INSERT USER MAKE USER

13. What is a limitation of the MEMORY storage engine in MySQL?

It doesn't support indexes It cannot store data in memory Data is not persistent It doesn't support transactions

14. Which command-line tool in MySQL is commonly used for data migration tasks?

mysqlimport mysqldump mysqlmigrate mysqltransfer

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

mysqldump MySQL Workbench phpMyAdmin MySQL Connector

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

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

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

INSERT INTO UPDATE DELETE FROM CREATE TABLE

18. What MySQL data type is suitable for storing date and time values?

DATETIME NUMERIC TEXT BOOLEAN

19. Which statement is used to restore a MySQL database from a backup file created with mysqldump?

RESTORE DATABASE IMPORT DATABASE LOAD DATABASE SOURCE DATABASE

20. Which SQL statement is used to retrieve distinct values from a column in MySQL?

SELECT DISTINCT SELECT UNIQUE SELECT VALUES SELECT UNIQUE VALUES