Certified-MySQL-5-0-DBA-Part-II-(006-002).pdf - mySQL...

This preview shows page 1 - 4 out of 10 pages.

The preview shows page 3 - 4 out of 10 pages.
006-002mySQLCertified MySQL 5.0 DBA Part II
A. The query cache size is too small.B. The CACHE_QUERY keyword is not being used.C. The Qcache_priority variable is set too small.D. The server might be trying to cache queries when it really isn't worth it.Answer:A, DQUESTION:122What should you do in order to enhance the security of a standard MySQL installation onUnix- type operating systems?B
QUESTION:123Why should you be selective when granting the SUPER privilege to an account?
QUESTION:124Which of the following best describes what you might expect after disabling InnoDB at runtime?
45
will save memory.C. It will disable InnoDBs associated memory buffers and data structures, which will savememory.Answer:CQUESTION:125It is important to analyze queries that involve joins with EXPLAIN because...A. Joins are more prone to mistakes.B. Using EXPLAIN before executing the query helps the server prepare the statements used.C. Joins have the potential to cause more server processing if not defined correctly.Answer:C
QUESTION:126Consider the following: mysql> EXPLAIN SELECT DISTINCT City.id,City.name ->FROM City,Country -> WHERE Country.Name IN ('United States','Canada','Mexico') ->ANDCity.CountryCode=Country.Code->ORDERBY*************************** 1. ro*************************** id: 1 select_type: SIMPLE table: City type: ALLpossible_keys: NULLkey: NULL key_len: NULL ref: NULL rows: 4079 Extra: Using temporary; Using filesort***************************2.row***************************id:select_type: SIMPLE table: Country type: eq_ref possible_keys: PRIMARY key: PRIMARYkey_len: 3 ref: world.City.CountryCode rows: 1 Extra: Using where; Distinct Which of thefollowing best describes the meaning of the values in the ref columns?name1

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 10 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
Mohammad Alizadeh
Tags
MYSQL, administrator

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture