ExamVeda
Login
Home

MySQL mcq questions and answers | MySQL MCQs

Learn competitive MySQL mcq questions and answers with easy and logical explanations Page-10 section-1

Each section contains 100 MCQs on MySQL Miscellaneous .
91
MySQL does not support the shared-memory connections on Windows.
Discuss
Answer & Solution
Answer: Option A
Solution:
In MySQL, the statement that MySQL does not support shared-memory connections on Windows is True.

On Windows, MySQL uses named pipes or TCP/IP connections for client connections to the server. Shared-memory connections are not supported on Windows.

Therefore, the correct answer is Option A: True.
92
Transactional processing provides strong guarantees about the outcome of operations.
Discuss
Answer & Solution
Answer: Option A
Solution:
In MySQL, transactional processing provides strong guarantees about the outcome of operations, ensuring that either all the operations within a transaction are successfully completed or none of them are. This property is known as Atomicity, Consistency, Isolation, and Durability (ACID).

Therefore, the statement that transactional processing provides strong guarantees about the outcome of operations is True.

The correct answer is Option A: True.
93
The command to see the warning messages is . . . . . . . .
Discuss
Answer & Solution
Answer: Option D
Solution:
In MySQL, to see the warning messages generated during the execution of a statement or stored program, you can use the SHOW WARNINGS command. This command displays any warnings that occurred during the execution of the previous statement.

Therefore, the correct command to see the warning messages is Option D: SHOW WARNINGS.
94
What will be the output of the following MySQL statement?
SELECT account_id, product_id, cust_id
FROM account
WHERE product_id IN (‘sav’, ‘chd’, ‘mm’);
Discuss
Answer & Solution
Answer: Option A
Solution:
The given SQL statement selects rows from the account table where the product_id column matches any of the specified values: 'sav', 'chd', or 'mm'. The IN operator is used to specify a list of values to match against. Therefore, the output of the statement will be:
Only those values are selected whose product_id is either 'sav', 'chd', or 'mm'. So, the correct answer is Option A: Only those values are selected whose product_id is either 'sav', 'chd', 'mm'.
95
The right shift operator is . . . . . . . .
Discuss
Answer & Solution
Answer: Option A
Solution:
The right shift operator in MySQL is represented by >>. This operator is used to shift the bits of a number to the right by a specified number of positions. Therefore, the correct answer is Option A: >>.
96
The expression 'HI' LIKE NULL results in . . . . . . . .
Discuss
Answer & Solution
Answer: Option C
Solution:
When comparing a string with NULL using the LIKE operator in MySQL, the result is always NULL, regardless of the string being compared. Therefore, the expression 'HI' LIKE NULL results in Option C: NULL.
97
The number of strings among the following matched with '%all%' is . . . . . . . .
Ball, baller, tall, tallest
Discuss
Answer & Solution
Answer: Option D
Solution:
If every string contains the substring "all", then all of them will match the pattern '%all%'. Therefore, the number of strings matched with '%all%' is Option D: 4.
98
The MySQL double dashed comment style is the same as the SQL standard.
Discuss
Answer & Solution
Answer: Option A
Solution:
The MySQL double dashed comment style (-- comment) is indeed the same as the SQL standard. Therefore, the statement is Option A: True.
99
Input handling can be customized with MySQL.
Discuss
Answer & Solution
Answer: Option A
Solution:
Input handling can indeed be customized with MySQL, allowing developers to define how input is processed and validated before being used in queries or stored in databases. Therefore, the statement is Option A: True.
100
'abc' || 'xyz', when PIPES_AS_CONCAT is enabled, results in . . . . . . . .
Discuss
Answer & Solution
Answer: Option C
Solution:
When the PIPES_AS_CONCAT SQL mode is enabled in MySQL, the || operator is interpreted as the concatenation operator. Therefore, the expression 'abc' || 'xyz' results in 'abcxyz'. Hence, the correct option is Option C: abcxyz.