MySQL Database Quiz Questions

Course Name:MySQL

Chapter Name:Chapter 2 - Introduction to Software Applications

Lesson Content Link:Database Platforms

Current Quiz Count:30

To gain complete access, login with gmail or outlook. click here

< Go back

Note: Please login to submit your answers.

0/0Score

Correct: 0

Wrong: 0

Progress

True / False

MySQL is an open-source relational database management system.

True False

MySQL is widely known as an open-source RDBMS, making it free to use and modify.

True / False

MySQL supports the use of JSON data types for storing JSON documents.

True False

MySQL 5.7 and later versions include native support for JSON data types.

True / False

MySQL does not support transactions.

True False

MySQL supports transactions with the InnoDB storage engine, allowing for ACID-compliant transactions.

True / False

In MySQL, the CHAR data type is variable-length and can store up to 255 characters.

True False

The CHAR data type in MySQL is fixed-length, not variable-length. The VARCHAR data type is variable-length.

True / False

MySQL Workbench is a unified visual tool that supports database design, development, and administration.

True False

MySQL Workbench provides tools for database design, SQL development, server administration, data migration, and backup.

True / False

In MySQL, the AUTO_INCREMENT attribute can be used with any data type.

True False

The AUTO_INCREMENT attribute can only be used with integer data types in MySQL.

True / False

MySQL supports the use of full-text indexes for performing complex searches on large text fields.

True False

MySQL provides full-text indexing and searching capabilities for text-based columns.

True / False

MySQL's InnoDB storage engine does not support foreign key constraints.

True False

The InnoDB storage engine in MySQL fully supports foreign key constraints, allowing for referential integrity.

True / False

MySQL can natively handle geographic data types and perform spatial queries.

True False

MySQL supports spatial data types and spatial indexes, which can be used for geographic information systems (GIS).

Q10

True / False

MySQL allows the creation of user-defined functions written in languages like Python or JavaScript directly within the database.

True False

MySQL user-defined functions (UDFs) are typically written in C or C++ and compiled into a shared library that MySQL can load. While MySQL does not natively support writing UDFs in Python or JavaScript, you can achieve similar functionality using external tools or languages.

Q11

Single Choice

Which of the following is a popular GUI tool for managing MySQL databases?

phpMyAdmin Microsoft Access Oracle SQL DeveloperSQLite

phpMyAdmin is a widely used web-based GUI tool for managing MySQL databases.

Q12

Single Choice

In MySQL, which keyword is used to retrieve unique records from a table?

UNIQUE DISTINCT SEPARATEDIFFERENT

The DISTINCT keyword is used in SQL queries to return only unique (distinct) values.

Q13

Single Choice

Which MySQL command is used to create a new database?

CREATE TABLE CREATE DATABASE NEW DATABASEADD DATABASE

The CREATE DATABASE command is used to create a new database in MySQL.

Q14

Single Choice

Which storage engine in MySQL supports transactions and foreign keys?

MyISAM MEMORY InnoDBCSV

The InnoDB storage engine supports transactions, foreign keys, and ACID-compliant operations in MySQL.

Q15

Single Choice

Which SQL clause is used in MySQL to filter records?

FILTER SORT WHEREGROUP BY

The WHERE clause is used to filter records that meet a certain condition in a SQL query.

Q16

Single Choice

In MySQL, which function is used to calculate the number of rows in a table?

COUNT() SUM() AVG()TOTAL()

The COUNT() function returns the number of rows that match a specified criterion.

Q17

Single Choice

Which MySQL feature allows you to perform a backup while the database is running?

Hot Backup Cold Backup Incremental BackupFull Backup

A hot backup allows the database to continue running while the backup is being performed, ensuring minimal downtime.

Q18

Single Choice

Which MySQL function can be used to extract the year from a date column?

YEAR() EXTRACT() DATEPART()DATE()

The YEAR() function extracts the year part from a date in MySQL.

Q19

Single Choice

Which isolation level in MySQL provides the highest level of data integrity but may reduce performance?

READ UNCOMMITTED READ COMMITTED REPEATABLE READSERIALIZABLE

The SERIALIZABLE isolation level provides the highest level of data integrity by preventing phantom reads, but it may reduce performance due to increased locking.

Q20

Single Choice

In MySQL, which of the following is used to set the maximum number of connections to the database?

max_connections connection_limit max_clientsconnection_max

The max_connections system variable in MySQL is used to set the maximum number of simultaneous client connections that the server will accept.

Q21

Multiple Choice

Which of the following are MySQL storage engines? (Choose all that apply)

MyISAM InnoDB SQLiteSQLite

MyISAM, InnoDB, and MEMORY are storage engines used in MySQL. SQLite is a separate database system.

Q22

Multiple Choice

Which MySQL statements are used to modify data in a database?

INSERT UPDATE SELECTDELETE

INSERT, UPDATE, and DELETE are statements used to modify data. SELECT is used to retrieve data.

Q23

Multiple Choice

Which of the following are MySQL storage engines? (Choose all that apply)

InnoDB MyISAM MEMORYCSV

MySQL supports various storage engines including InnoDB, MyISAM, MEMORY, and CSV.

Q24

Multiple Choice

In MySQL, which clauses can be used with the SELECT statement? (Choose all that apply)

WHERE GROUP BY ORDER BYHAVING

The SELECT statement can use WHERE, GROUP BY, ORDER BY, and HAVING clauses to filter, group, sort, and further filter grouped data.

Q25

Multiple Choice

Which functions are used in MySQL for string manipulation? (Choose all that apply)

CONCAT() SUBSTRING() LENGTH()ROUND()

CONCAT(), SUBSTRING(), and LENGTH() are functions used for string manipulation. ROUND() is used for numerical rounding.

Q26

Multiple Choice

Which MySQL features enhance database security? (Choose all that apply)

User Authentication Role-based Access Control Data EncryptionFull-text Indexing

User Authentication, Role-based Access Control, and Data Encryption enhance database security. Full-text Indexing is related to search functionality.

Q27

Multiple Choice

Which MySQL features support high availability? (Choose all that apply)

Replication Clustering PartitioningBackups

: Replication, Clustering, and Partitioning support high availability by distributing data and workload. Backups are essential for data recovery but do not directly contribute to high availability.

Q28

Multiple Choice

Which MySQL commands are used to manage user privileges? (Choose all that apply)

GRANT REVOKE SETCREATE USER

GRANT and REVOKE are used to assign and remove user privileges, respectively. CREATE USER is used to create new users. SET is used to change system variables.

Q29

Multiple Choice

Which MySQL optimizations can improve query performance? (Choose all that apply)

Indexing Query Caching NormalizationDenormalization

Indexing, Query Caching, and Denormalization can improve query performance. Normalization improves data structure but not necessarily query performance.

Q30

Multiple Choice

Which MySQL features are important for data integrity? (Choose all that apply)

Foreign Keys Transactions TriggersFull-text Search

Foreign Keys, Transactions, and Triggers help maintain data integrity by enforcing rules and ensuring data consistency. Full-text Search enhances search capabilities but does not impact data integrity.