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 data type would you choose for storing IP addresses in MySQL?

CHAR VARCHAR INET BLOB

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

ORDER BY HAVING GROUP BY WHERE

3. Which programming language is commonly used to interact with MySQL?

Java C++ Python PHP

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

5. When performing data migration in MySQL, what is the purpose of the "ETL" process?

To Extract, Transfer, and Load data To Enforce Transaction Logs To Encrypt Table Layout To Execute Trigger Logic

6. Which MySQL tool is a web-based database administration tool with a user-friendly interface?

mysqldump MySQL Workbench phpMyAdmin MySQL Shell

7. What is SQL injection in MySQL and why is it a security concern?

A method to retrieve forgotten passwords A technique to exploit vulnerabilities A way to optimize queries A method to compress data

8. Which feature in MySQL helps protect data during transmission over the network?

SSL/TLS Data encryption Firewall rules Query caching

9. Which MySQL client tool provides a graphical interface for database management?

MySQL CLI phpMyAdmin MySQL Monitor MySQL Workbench

10. What SQL statement is used to remove data from a database?

DELETE DROP ERASE REMOVE

11. What is a physical backup in MySQL?

A backup of binary log files A backup of data in SQL format A backup of the entire database server A backup of stored procedures

12. Which data type is used to store whole numbers in MySQL?

INTEGER REAL CHAR BOOLEAN

13. Which SQL statement is used to create a new MySQL database?

CREATE DATABASE NEW DATABASE ADD DATABASE INSERT DATABASE

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

relational proprietary free commercial

15. What is the primary purpose of the "Explain" statement in MySQL?

To log query execution time To view and optimize query execution plans To troubleshoot server crashes To export query results

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

DELETE * FROM DELETE ALL DELETE FROM ALL TRUNCATE TABLE

17. Which command is used to start the MySQL server on a Windows system?

start-mysql net start mysql mysql-server start service mysqld start

18. What is the primary benefit of Group Replication in MySQL?

Read scalability Fault tolerance Data encryption Query optimization

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. What is the default port number for MySQL connections?

3306 5432 1521 80