ExamVeda
Login
Home

MySQL mcq questions and answers | MySQL MCQs

Learn competitive MySQL mcq questions and answers with easy and logical explanations Page-8 section-12

Each section contains 100 MCQs on MySQL Miscellaneous .
71
In the following SQL query, what does "person" stands for?
INSERT INTO person
(person_id, fname, lname) 
VALUES (1,’S’,’P’);
Discuss
Answer & Solution
Answer: Option C
Solution:
This question is about understanding the basic structure of an SQL query. Let's break down the code:
    `INSERT INTO person` - This part tells the database that we want to insert some data into a table.
    `person` - This is the name of the table where we're adding the data.
    `(person_id, fname, lname)` - These are the names of the columns (like fields in a spreadsheet) within the `person` table.
    `VALUES (1,’S’,’P’);` - These are the values we want to insert into the respective columns.

So, the answer is Option C: Table name.
    `person` represents the table where the data will be inserted.
72
'2341' is a . . . . . . . .
Discuss
Answer & Solution
Answer: Option D
No explanation is given for this question. Let's Discuss on Board
73
What cannot be done on a view?
Discuss
Answer & Solution
Answer: Option C
Solution:
This question is about views in MySQL. A view is like a saved query that lets you see data from one or more tables in a specific way. Think of it as a shortcut or a custom view of your data.

Now, let's look at the options:

Option A: display - You can definitely display data from a view, that's what it's meant for!
Option B: filter - Views can be used to filter data, showing only the information you want.
Option C: index - This is the trick! You cannot create an index directly on a view. Indexes help speed up data retrieval, but they are created on tables, not views.
Option D: drop - You can definitely drop a view if you no longer need it.

So the answer is Option C: index.
74
What will be the output of the following MySQL statement?
SELECT account_id, product_id, cust_id
FROM account
WHERE product_id NOT IN (‘sav’, ‘chd’, ‘mm’);
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
75
How many values can be returned from a given stored function?
Discuss
Answer & Solution
Answer: Option B
Solution:
This question asks about stored functions in MySQL. A stored function is like a mini-program that you can use over and over again.

Imagine you have a recipe for a cake. You can use that recipe (stored function) to bake many cakes.

Now, think about what the cake recipe does. It tells you how to combine ingredients and bake a cake. In the end, you get one cake (one value).

The same goes for stored functions in MySQL. They can do some calculations or actions, but they can only return one value at a time.

So the answer is Option B: 1.
76
Which value of event_scheduler enables checking status but not changing it at runtime?
Discuss
Answer & Solution
Answer: Option C
Solution:
This question is about the event scheduler in MySQL. The event scheduler is like a timer that runs tasks at set times.

We need to find the option that lets you check the status of the event scheduler without being able to change it while the database is running.

Here's how the options break down:

* Option A: ON - This means the event scheduler is running and can be changed.
* Option B: OFF - This means the event scheduler is stopped and cannot be changed.
* Option C: DISABLED - This is the same as OFF, the event scheduler is stopped.
* Option D: ENABLED - This is the same as ON, the event scheduler is running.

The correct answer is Option B (OFF) or Option C (DISABLED).

These options let you check the status of the event scheduler (whether it's on or off) but you can't change it while the database is running.

To actually change the status of the event scheduler, you'd need to restart the database.
77
What is the default format for "Datetime" data type?
Discuss
Answer & Solution
Answer: Option A
Solution:
This question asks about the way MySQL stores dates and times using the "Datetime" data type. Let's break down the options:
Option A: YYYY-MM-DD HH:MI:SS This format represents the year (YYYY), month (MM), day (DD), hour (HH), minute (MI), and second (SS).
Option B: MM-YYYY-DD HH:MI:SS This format puts the month first, then the year, and so on.
Option C: DD-YYYY-MM MI:HH:SS This format places the day first, then the year, and so on.
Option D: None of the mentioned This option suggests that none of the above formats are the default.
The correct answer is Option A: YYYY-MM-DD HH:MI:SS. MySQL stores dates and times in the "YYYY-MM-DD HH:MI:SS" format by default.
Remember, understanding data types and their formats is crucial for working with databases efficiently.
78
Which Clause is used to select a particular table in Mysql?
Discuss
Answer & Solution
Answer: Option C
Solution:
This question asks about the part of a MySQL query that tells the database which table you want to get data from.
Think of a query like asking for information. You need to tell the database where to look.
Here's how the options work:
Option A: WHERE - This clause is used to filter data within a table. It's like saying "give me only the rows where the age is 25".
Option B: SELECT - This clause tells the database which columns you want to retrieve from the table. It's like saying "show me the name and age".
Option C: FROM - This is the answer! The FROM clause is used to specify the table you want to work with. It's like saying "look in the 'users' table".
Option D: ALTER - This clause is used to modify the structure of a table, like adding or removing columns. It's not about selecting a table.
So, the correct answer is Option C: FROM.
79
Which authentications are required for login into Mysql command line tool?
Discuss
Answer & Solution
Answer: Option D
Solution:
This question is asking about how you log in to the MySQL command line tool.

The command line tool is like a special window where you can type commands to talk to your MySQL database.

To access this tool, you need to prove you're who you say you are.

Think of it like a door with a lock. You need the right key to open it.

In this case, the "key" is your username and password.

So the answer is Option D: Both Username and Password.
80
How many options can be used to control LOCAL capability at runtime?
Discuss
Answer & Solution
Answer: Option C
Solution:
This question is about LOCAL capability in MySQL. LOCAL capability allows you to use certain features within a single connection. Think of it like a special permission that only applies to your current session with the database.

The question asks how many ways you can control this LOCAL capability while your MySQL session is running.

The correct answer is Option C: 2.

Here's why:
1. SESSION VARIABLES: You can change the value of a SESSION variable to affect LOCAL capability. Think of SESSION variables as settings specific to your current connection. For example, changing the `sql_mode` variable can adjust what types of SQL statements are allowed.
2. SET [LOCAL] ... You can use the `SET [LOCAL]` statement. This allows you to directly set a SESSION variable within your current session. For example, `SET [LOCAL] sql_mode = 'STRICT_TRANS_TABLES';` would set the `sql_mode` variable for your current connection.

So, there are two ways to control LOCAL capability at runtime: by changing SESSION variables and by using the `SET [LOCAL]` statement.