Question

Which system variable when set to 1, makes all temporary tables to get stored on disk rather than in memory?

a.

basedir

b.

back_log

c.

big_tables

d.

bind_address

Posted under System and User Variables MySQL Database

Answer: (c).big_tables

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Which system variable when set to 1, makes all temporary tables to get stored on disk rather than in memory?

Add Comment

Similar Questions

Discover Related MCQs

Q. The permitted value type for the variable ‘character_set_client’ is _____________

View solution

Q. ‘character_set_database’ represents the character set used by the default database.

View solution

Q. Which string function returns the index of the first occurrence of substring?

View solution

Q. Which module links DBI to the web?

View solution

Q. What does CGI stand for?

View solution

Q. The line that is written at the top of the script to write a Perl script using CGI.pm is ___________

View solution

Q. What is the shebang line?

View solution

Q. Which of these is a read only variable?

View solution

Q. Which variable when set to 1 would enable foreign key checking for InnoDB tables?

View solution

Q. The synonym for last_insert_id session variable is _____________

View solution

Q. When building from source, the embedded server library is enabled by what?

View solution

Q. What returns a string containing an error message?

View solution

Q. The statement that views status variables by aggregating the values over all connections is _____________

View solution

Q. Which keyword inserted in the SHOW STATUS statement shows the values for the current connection?

View solution

Q. What is the synonym for last_insert_id session variable?

View solution

Q. The Audit_log_events system variable is of type _____________

View solution

Q. mysql_next_result() does not return a status.

View solution

Q. The option that executes all SQL statements in a SQL script irrespective of the number of errors is ____________

View solution

Q. How many of the following do not return rows?

SELECT, SHOW, DESCRIBE

View solution

Q. What does mysql_fetch_row() return?

View solution

View All MCQs on System and User Variables

Suggested Topics

Are you eager to expand your knowledge beyond MySQL Database? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

PHP

Venture into server-side scripting with our PHP MCQs. Cover everything from syntax...

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

Digital Logic Design

Understand the foundation of digital computers with our Digital Logic Design MCQs....

C Programming

Master one of the most widely used programming languages with our C Programming MCQs....

MongoDB

Learn the leading NoSQL database with our MongoDB MCQs. Understand everything from...

Microprocessor

Understand the heart of your computer with our Microprocessor MCQs. Topics include...

Neural Networks

Dive into the world of Artificial Intelligence with our Neural Networks MCQs. Uncover...

Cloud Computing

Stay on top of the biggest trend in IT with our Cloud Computing MCQs. These questions...

Systems Programming

Decode low-level programming with our Systems Programming MCQs. These questions delve...