Site icon i2tutorials

MySQL Installation – Quiz

This Quiz contains totally 25 Questions each carry 1 point for you.

1.What is MySQL?


 


A programming language
A relational database management system
A computer operating system
A type of computer hardware

Correct!

Wrong!

2.What is the primary use of MySQL Workbench?


 


 


 


Word processing
Image editing
Web browsing
Database design and management

Correct!

Wrong!

3. What is needed to connect to a MySQL database?


The database name, username, and password
The computer's IP address
The operating system version
The size of the hard drive

Correct!

Wrong!

4. How is MySQL installed on a Windows computer?


 


 


 


By visiting the MySQL website, downloading the installer, and following the on-screen instructions
By purchasing a CD-ROM from a retailer
By downloading it from an email
MySQL cannot be installed on Windows

Correct!

Wrong!

5. What is the purpose of SQL queries in a database?


 


 


 


To perform operations such as retrieval, insertion, updating, and deletion of data
To generate graphics for a website
To install new software
To create backups of the entire computer

Correct!

Wrong!

6. What is a schema in MySQL?


 


 


 


A security feature to protect data
A structure that defines the entire database
A tool for visualizing data
A type of query

Correct!

Wrong!

7. What programming language is used to write queries in MySQL?


 


 


 


Python
Java
SQL
C#

Correct!

Wrong!

8. Which of the following is a valid SQL command?


 


 


 


EXTRACT
COPY
SELECT
PRINT

Correct!

Wrong!

9. Can you connect to a MySQL database remotely?


 


 


 


Yes, but only if the database is publicly accessible
No, you can only connect to a MySQL database from the local machine
Yes, but only if you have the correct IP address
No, remote connections to MySQL databases are not possible

Correct!

Wrong!

10. What type of software is MySQL Workbench?


 


 


 


A word processor
A database management tool
An email client
A video game

Correct!

Wrong!

11. What does the SQL command 'CREATE DATABASE' do in MySQL?


 


 


 


Creates a new table
Creates a new database
Creates a new row in a table
Creates a new user

Correct!

Wrong!

12. Which of the following tools allows visual data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, and much more?


Microsoft Excel
MySQL Workbench
Adobe Photoshop
Google Chrome

Correct!

Wrong!

13. What does the SQL command 'DROP DATABASE' do in MySQL?


 


 


 


Deletes a specific database
Deletes a specific table
Deletes a specific row in a table
Deletes a specific user

Correct!

Wrong!

14. What is a 'Primary Key' in MySQL?


A special key on the keyboard
A type of password
A unique identifier for records in a table
A tool for connecting to a database

Correct!

Wrong!

15. What does the 'ALTER TABLE' command do in MySQL?


 


 


 


Changes the structure of a table
Changes the data in a table
Changes the name of a table
Changes the user permissions for a table

Correct!

Wrong!

16. How do you select all records from a table named 'customers' in MySQL?


 


 


 


SELECT * FROM customers;
GET ALL customers;
OPEN customers;
D. LIST * customers;

Correct!

Wrong!

17. What port does MySQL use by default?


 


 


 


22
80
3306
808

Correct!

Wrong!

18. Which of the following SQL commands is used to modify data in a MySQL database?


UPDATE
SELECT
CREATE
DROP

Correct!

Wrong!

19. In MySQL Workbench, what is a 'Server Instance'?


A specific database
A specific user
A configuration template for connecting to a MySQL server
A type of SQL command

Correct!

Wrong!

20. What does the 'GRANT' command do in MySQL?


 


 


 


It creates a new database
It gives a user permission to perform certain actions
It deletes a database
It changes the structure of a table

Correct!

Wrong!

21. Can you have more than one 'Primary Key' in a MySQL table?


Yes, as many as you like
No, only one Primary Key is allowed per table
Yes, but only up to three
No, Primary Keys are not used in MySQL

Correct!

Wrong!

22. In MySQL, what is a 'Foreign Key'?


 


 


 


A type of password
A unique identifier for records in a table
A field in one table that refers to the Primary Key in another table
A tool for connecting to a database

Correct!

Wrong!

23. How do you create a new user in MySQL?


 


 


 


Using the 'CREATE USER' command
By sending an email to the MySQL administrator
By downloading a new user from the MySQL website
Users cannot be created in MySQL

Correct!

Wrong!

24. What does the SQL 'DELETE' command do in MySQL?


It deletes a specific database
It deletes a specific table
It deletes a specific row in a table
It deletes a specific user

Correct!

Wrong!

25. In the context of MySQL, what does 'DBMS' stand for?


Data Base Management System
Digital Byte Management System
Dynamic Business Management System
Direct Binary Mode System

Correct!

Wrong!

Share the quiz to show your results !

Subscribe to see your results

Ignore & go to results

MySQL Installation – Quiz

You got %%score%% of %%total%% right

%%description%%

%%description%%

Loading...

Exit mobile version