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. Which replication mode in MySQL allows data to flow in multiple directions between servers?

Master-Slave replication Group replication Circular replication Bidirectional replication

2. In MySQL, what is the purpose of the GRANT statement?

To authenticate users To revoke privileges To grant privileges To delete user accounts

3. What is the primary purpose of database backups in MySQL?

To improve query performance To create new databases To protect against data loss To optimize server speed

4. Which method of MySQL migration is typically used for transferring data from a non-MySQL database system?

Replication SQL Migration Data Pump ETL Process

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

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

3306 5432 1521 80

7. What is the purpose of the MySQL Enterprise Backup tool?

Schema design Data encryption Database backups Query optimization

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

3306 5432 1521 80

9. What is GTID in MySQL replication?

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

10. What does MySQL stand for?

My SQL MyStructuredQueryLanguage Structured Query Language MySQL Structured Query Language

11. What is the purpose of the MySQL option file (my.cnf or my.ini)?

To store user data To configure MySQL settings To store binary data To create tables

12. Which MySQL feature helps avoid full table scans and improve query performance by remembering the results of previous queries?

Query Cache Connection Pooling InnoDB Buffer Pool Replication

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

14. What is the default storage engine used by MySQL?

InnoDB MyISAM SQLite PostgreSQL

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

16. What is the purpose of the MySQL "REVOKE" statement?

To grant privileges To create new users To remove privileges To reset user passwords

17. Which SQL clause is used to sort the result set in ascending or descending order?

ORDER BY GROUP BY HAVING FROM

18. Which of the following is not a valid MySQL data type?

CHAR STRING DATE BLOB

19. In MySQL migration, what is the purpose of the "ETL" transformation phase?

To encrypt data before migration To ensure data consistency To clean and format data To create a backup

20. What is the SUPER privilege in MySQL used for?

Managing user accounts Administrative tasks Granting SELECT privileges Inserting data into tables