Summer Special Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: vce65

You have a config file for a running DB with this excerpt:[mysqld]tmp_table_size=16Msort_buffer_size=256kTo address a query...

You have a config file for a running DB with this excerpt:

[mysqld]

tmp_table_size=16M

sort_buffer_size=256k

To address a query performance problem of connecting to the DB from an application on another host, you log in and make these changes to the DB:

mysql> SET GLOBAL tmp_table_size=32000000;

mysql> SET sort_buffer_size=2000000;

This solves the problem with your queries. However, later the DB instance is restarted and the performance problem returns.

Which three best describe this scenario?

A.

Global variables are not persistent across server restarts.

B.

Session variables are not persistent across server restarts.

C.

The query benefited from sort_buffer_size increase.

D.

sort_buffer_size should match tmp_table_size to be optimal.

E.

The query benefited from tmp_table_size increase.

F.

The query benefited from sort_buffer_size and tmp_table_size increases.

Oracle 1z0-888 Summary

  • Vendor: Oracle
  • Product: 1z0-888
  • Update on: Jul 26, 2025
  • Questions: 124
Price: $52.5  $149.99
Buy Now 1z0-888 PDF + Testing Engine Pack

Payments We Accept

Your purchase with ExamsVCE is safe and fast. Your products will be available for immediate download after your payment has been received.
The ExamsVCE website is protected by 256-bit SSL from McAfee, the leader in online security.

examsvce payment method