Oracle Exam 1Z0-888 Topic 3 Question 46 Discussion

Actual exam question for Oracle's 1Z0-888 exam

Question #: 46
Topic #: 3

Consider the join_buffer_size parameter in MySQL Server.

Which two statements are true about the join buffer? (Choose two.)

AThe value should be increased if the client performs several SELECT operations.

BThe join buffer is set per connection.

CThe join buffer is used to process sorts when complex joins are being performed.

DThe value should be increased from the default if the query joins large rows without using an index.

EThe join buffer is global and can be changed only by restarting the server.

Show Suggested Answer

Suggested Answer: C, D

by Paris at May 05, 2022, 06:37 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!