MySQL mcq questions and answers | MySQL MCQs

This question asks about where MySQL stores the changes made to data on a server. Let's break down the options:
Option A: error log - This log records errors that occur during the operation of the MySQL server. It doesn't store data changes.
Option B: general query log - This log keeps track of all the SQL queries that are executed on the server. It doesn't specifically store changes to data.
Option C: binary log - This log records all changes made to the data on the server, including updates, inserts, and deletes. It's used for replication, where changes are copied to other servers.
Option D: relay log - This log is used by slave servers in a replication setup. It stores the changes received from the master server and applies them to the slave server's database.
Therefore, the correct answer is Option D: relay log.
Let's summarize:
* Binary log: Stores changes from the master server.
* Relay log: Stores changes received from the master server and applies them to the slave server's database.

This question is about how MySQL manages its log files. Imagine you're writing in a notebook, and each page represents a "binary log file". These files store information about changes made to your database.

The master server is the main database server that holds the original data. It's important to keep the log files safe and organized.

Let's look at the options:
* Option A: SHOW SLAVE STATUS: This command is used to view information about the slave server (a copy of the master server). It doesn't deal with deleting log files on the master server.
* Option B: PURGE MASTER: This is the correct answer! It's like cleaning up your notebook by throwing away old pages you don't need anymore. This command removes expired binary log files from the master server.
* Option C: PURGE SLAVE: This command is for cleaning up log files on the slave server, not the master.
* Option D: SHOW MASTER STATUS: This command shows information about the current binary log file on the master server. It doesn't delete anything.

Therefore, the answer is Option B: PURGE MASTER

This question is about how MySQL handles the SELECT statement when dealing with MERGE tables. A MERGE table is a special type of table that combines data from multiple underlying tables.

Imagine you have two tables: Table A and Table B. A MERGE table acts like a combined view of these two tables. When you run SELECT on a MERGE table, it's like looking at the data from both Table A and Table B as if they were one big table.

Now, let's look at the options:
Option A: UNION ALL - This combines data from multiple tables, including duplicates.
Option B: UNION - This combines data from multiple tables, but removes duplicates.
Option C: UNION DISTINCT - This is the same as UNION (removes duplicates).
Option D: JOIN - This combines data from tables based on a shared column.

The answer is Option A: UNION ALL.

Why? Because a MERGE table behaves like a UNION ALL operation, meaning it combines the data from its underlying tables without removing duplicates.

This question is asking about how to tell a MySQL server which specific network address it should use to listen for connections.

Think of it like this: Imagine your MySQL server is a phone that can receive calls. The "IP number of the server host" is like the phone number. By specifying this number, you're telling the server which number to use to answer incoming calls (connections).

Here's how the options break down:

Option A: -verbose
This option makes the MySQL server more talkative, giving you more detailed information about what's happening. It's not about controlling the network address.

Option B: -bind-address
This is the correct answer! The -bind-address option is used to tell the server which IP address to use for listening.

Option C: -startup
This option starts the MySQL server. It doesn't control the network address.

Option D: -shutdown
This option stops the MySQL server. It doesn't control the network address.

In summary, the correct answer is Option B: -bind-address because it specifically controls which IP address the server uses to listen for connections.

This question is asking you to identify what "person_id" represents within the given SQL code. The code creates a table named "person" with several columns:

* person_id: This column stores a unique identifier for each person in the table. It is declared as SMALLINT UNSIGNED, meaning it can hold small integer values without negative signs.
* fname: This column stores the first name of each person. It is declared as VARCHAR(20), meaning it can hold strings of up to 20 characters.
* lname: This column stores the last name of each person. It is also declared as VARCHAR(20).

The code also includes a constraint called pk_person, which is a primary key constraint applied to the person_id column.

A primary key is a special type of key in a database that uniquely identifies each row in a table. Here's why "person_id" is the primary key:

* Unique Identification: Each person must have a distinct "person_id", ensuring that no two rows have the same value.
* Data Integrity: The primary key constraint enforces this uniqueness, preventing duplicate entries and maintaining data consistency.

Therefore, the correct answer is Option D: Primary key.

Let's look at the other options and why they're incorrect:

* Option A: Normal attribute of the table - While "person_id" is an attribute of the table, it's not just a normal attribute because of its unique identification role.
* Option B: Super key - A super key is any set of attributes that can uniquely identify a row, but a primary key is the minimal set of attributes that can do so.
* Option C: Composite key - A composite key is a primary key consisting of multiple columns. In this case, "person_id" is a single-column primary key.

This question is asking about how you "switch" to a specific database in MySQL. You need to tell MySQL which database you want to work with.

Let's break down the options:

Option A: Use
This is incorrect. "Use" is a keyword in MySQL, but it needs a database name after it.

Option B: use database.name
This is also incorrect. You don't use a dot (.) to separate the "use" keyword and the database name.

Option C: USE databasename;
This is the correct answer! "USE" is the command, followed by the name of your database, and ending with a semicolon (;).

Option D: None of the mentioned
This is incorrect because Option C is the correct way to access an existing database.

In summary: To access an existing database in MySQL, use the command: USE databasename; (Replace "databasename" with the actual name of your database).

This question is about setting up a connection to your MySQL database. Imagine you're trying to open a door. Instead of typing in the whole address every time, wouldn't it be easier to save it somewhere? That's what an option file does for your MySQL connection!

An option file stores all the information your database needs, like the username, password, and database name. This way, you don't have to type them in every time you connect.

Think of it like a shortcut – you save the information once, and then you can just use the option file to quickly connect.

So, is the answer True or False?

The answer is True. You can store connection parameters in an option file to make connecting to MySQL easier.