MySQL mcq questions and answers | MySQL MCQs

This question is about understanding how MySQL stores numbers.

TINYINT is a data type in MySQL that represents small integers.

Signed means that the number can be positive or negative.

A TINYINT takes up 1 byte of storage space. Since it's signed, one bit is used for the sign, leaving 7 bits for the value.

With 7 bits, you can represent 2⁷ = 128 different values.

Since it's signed, you have half positive and half negative values, plus zero.

So, the minimum value you can store in a signed TINYINT is -128.

Therefore, the correct answer is Option B: -128.

This question is about loading data from a text file into a MySQL database. Let's break down the options:
Option A: mysqldump
- mysqldump is used to backup your database, meaning it creates a copy of your data in a file. It's not used for loading data.
Option B: mysqld
- mysqld is the MySQL server itself. It runs in the background and manages the database. It's not used for loading data directly.
Option C: mysqlimport
- mysqlimport is the tool designed specifically for loading data from text files into a MySQL database. This is the correct answer!
Option D: mysqlnaive
- mysqlnaive is not a valid command or tool in MySQL.
Therefore, the correct answer is Option C: mysqlimport.

This question asks about the type of data stored in the Audit_log_events system variable. System variables store information about how MySQL works.
Let's understand the options:
A: string - Strings store text like "Hello" or "MySQL".
B: integer - Integers are whole numbers like 10, 25, or 500.
C: float - Floats are numbers with decimal points like 3.14 or 12.5.
D: double - Doubles are similar to floats but can store even larger numbers with decimal points.
Think about what the Audit_log_events variable might store. It's about what kind of events are being logged. Would it be a number (integer) or a descriptive text (string)?
The correct answer is A: string. The Audit_log_events variable stores a string describing the types of events that should be logged.

This question is about subqueries in MySQL. A subquery is a query nested inside another query.

Imagine you have a big box of toys, and you want to find a specific toy. A subquery is like a smaller box inside the big box that helps you narrow down your search.

The question asks which type of subquery returns only one value (like finding one specific toy).

Here's a breakdown of the options:

A: scalar - This is the correct answer! A scalar subquery returns one single value, like a number, a string, or a date.

B: column - A column subquery returns a set of values from a single column, like a list of names.

C: row - A row subquery returns a set of values that represent a single row from a table, like a list of information about one toy.

D: table - A table subquery returns an entire table, like the entire box of toys.

So the answer is Option A: scalar because a scalar subquery specifically returns only one single value.

This question is asking about the MySQL query cache. The query cache is a feature in MySQL that stores the results of recently executed queries, so that if the same query is run again, MySQL can simply retrieve the result from the cache instead of re-executing the query.
The SELECT SQL_CACHE statement tells MySQL to store the results of the query in the cache.
The mode that determines whether the query cache is enabled or disabled is represented by an integer value.
Here are the possible values and their meanings:
Option A: 0 - This means the query cache is disabled.
Option B: 1 - This means the query cache is enabled.
Option C: 2 - This option is not used for the query cache.
Option D: 3 - This option is not used for the query cache.
Therefore, the correct answer is Option B: 1.
In summary: The query cache is enabled in mode 1, which means that queries using SELECT SQL_CACHE will be stored in the cache for future use.

This question is about the different types of tables you can find in MySQL. Think of tables as organized containers for your data. Here's a breakdown:
Permanent Tables: These are your main tables where data is stored permanently. They are like your primary storage for information.
Virtual Tables: These are special tables that don't actually store data themselves. They are designed to provide information from other sources, such as system tables or user-defined functions.
Temporary Tables: These tables are temporary, meaning they exist only for the duration of your current session. They're great for holding temporary calculations or data that you don't need to save permanently.
All of the mentioned: This is the correct answer! MySQL supports all three types of tables: permanent, virtual, and temporary.

This question asks about how we divide numbers in MySQL, which is a kind of database software.
Here's the breakdown of the options:
* Option A: / This is the regular division operator we use in math, but in MySQL, it performs floating-point division, meaning it gives you a result with decimal places.
* Option B: This symbol is usually used for escaping characters, not division.
* Option C: DIV This is the operator specifically designed for integer division in MySQL. It throws away any decimal part of the result, giving you only the whole number.
* Option D: // This is not a valid operator in MySQL for division.
So the correct answer is Option C: DIV.
Let's say you want to divide 10 by 3.
* Using `/` (normal division), you'd get 3.3333 (a floating-point number).
* Using `DIV` (integer division), you'd get 3 (only the whole number).

This question asks you about the REPAIR TABLE command in MySQL. This command is used to fix any potential errors in a table's structure or data.

Let's break down the options:

Option A: MyISAM - REPAIR TABLE works perfectly fine with MyISAM tables.
Option B: ARCHIVE - REPAIR TABLE works perfectly fine with ARCHIVE tables.
Option C: InnoDB - REPAIR TABLE works perfectly fine with InnoDB tables.
Option D: CSV - CSV is a file format, not a MySQL table type. REPAIR TABLE is designed for MySQL table types.

Therefore, the correct answer is Option D: CSV.

This question asks you about how to import data from a text file into a MySQL database.

Here's the breakdown of the options:
* Option A: mysqldump - This is used to create a backup of your database, not to import data.
* Option B: mysqld - This is the MySQL server itself. You can't directly import data with this.
* Option C: mysqlimport - This is the correct answer! mysqlimport is a command-line utility specifically designed for importing data from delimited text files into MySQL databases.
* Option D: mysqlnaive - This isn't a real MySQL command.

So, the answer is Option C: mysqlimport