gs gs113 Query Optimization - Administrative-Level Optimizations - Quiz No.1
gs gs113 MySQL Quiz
This quiz belongs to book/course code gs gs113 MySQL of gs organization. We have 126 quizzes available related to the book/course MySQL. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Query Optimization. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Accessing data from which of these is faster?
memory, disk
memory
disk
same speed
machine dependent
Question 2: Which system variable controls the size of the table cache?
table_cache
cache_table
open_cache
cache_open
Question 3: Which status indicator assesses how effective the table cache is?
Open_tables
Opened_tables
Close_tables
Closed_tables
Question 5: The system variable to maintain InnoDB log buffer size is _________________
innodb_log_buffer_size
innodb_buffer_log_size
buffer_log_innodb_size
log_buffer_innodb_size
Question 6: All queries can be cached.
True
False
Question 7: To determine whether query cache is supported by the server the variable is _________________
have_query_cache
have_cache_query
query_cache_have
cache_query_have
Online Quizzes of gs113 MySQL
MySQL Programs Using C - Using the Embedded Server Library - Quiz No.1
gs gs113
MySQL Online Quizzes
System, Status and User Variables - User-Defined Variables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.2
gs gs113
MySQL Online Quizzes
