Q. Which statement issues a lock on tables?

View solution

Q. Reading from a table does not change it.

View solution

Q. To how many of these does the LOW_PRIORITY modifier apply to?

DELETE, INSERT, LOAD DATA, REPLACE

View solution

Q. The number of tables among the following for which HIGH_PRIORITY have an effect are _________________

MyISAM, MEMORY, MERGE

View solution

Q. The number of tables for which DELAYED works is _________________

MyISAM, MEMORY, ARCHIVE, BLACKHOLE

View solution

Q. Find the odd one out in terms of scheduling policies.

View solution

Q. The use of table level locks is always useful in MyISAM tables.

View solution

Q. Which table is preferred when there are many updates?

View solution

Q. Accessing data from which of these is faster?

memory, disk

View solution

Q. Which system variable controls the size of the table cache?

View solution

Q. Which status indicator assesses how effective the table cache is?

View solution

Q. In MySQL, the default size of the key buffer in MB is _________________

View solution

Q. The system variable to maintain InnoDB log buffer size is _________________

View solution

Q. All queries can be cached.

View solution

Q. To determine whether query cache is supported by the server the variable is _________________

View solution

Q. Which mode tells not to cache query results?

View solution

Q. Which mode tells cache queries that begin with SELECT SQL_CACHE?

View solution

Q. Installing more memory into the machine enables to configure larger values for cache server.

View solution

Q. Which command is used to remove existing tables or database?

View solution

Q. Which command is used to display all the existing tables in a database?

View solution