Guarantee your 310-811 success with our 310-811 Exam Resources. Our exams are developed by experiences IT Professionals working in today’s prospering companies and date centers. All our practice exams including 310-811 exam guarantee you the exam success you needYour Sun training and certification requirements will now be served by Oracle University, the education division of Oracle. We are pleased to have you as a customer and are committed to insuring a smooth integration by:

• Continuing to teach all active Sun Java, Solaris, MySQL, software, server and storage courses
• Continuing Sun’s popular certification program and honoring Sun certification exam vouchers
• Retaining top Sun instructors
• Continuing to develop courseware to support new releases
• Proactively scheduling the most popular Sun courses in our education centers
• Continuing to offer on-site, self-paced, and custom training
• Preserving and honoring existing pre-paid training account

1. Is the following statement true or false? The username you use to connect to MySQL must be the same as the login used to access the operating system. A. trueB. falseAnswer: B     2. Which of the following statements are required to create a key cache of 4 MB, assign the MyISAM table world.City to it and preload the index?A. mysql> SET GLOBAL city_cache.key_buffer_size = 4194304;mysql> CACHE INDEX world.City IN city_cache;mysql> LOAD INDEX INTO CACHE world.City;B. mysql> ALTER TABLE world.city KEY_CACHE = 4194304;C. mysql> CREATE CACHE FOR world.City SIZE = 4194304;D. It is not possible to create a key cache for a specific MyISAM table, only the global key cache can be used.Answer: A 3. How can the SHOW PROCESSLIST command be helpful when optimizing queries?A. It shows if a query is using an index or not.B. It shows how the server processes a query.C. If checked periodically, it can reveal queries that cause other queries to hang.D. It shows the percentage of processing power that each query is using on a server.Answer: C     4. Consider the following:mysql> EXPLAIN SELECT Name FROM Country WHERE Code = ‘CAN’\G *************************** 1. row ***************************           id: 1select_type: SIMPLE      table: Country       type: constpossible_keys: PRIMARY          key: PRIMARY      key_len: 3          ref: const         rows: 1        Extra:Which of the following best describes the meaning of the value of the type column?A. The table has exactly one row.B. Several rows may be read from the table.C. Only one row of all its rows need to be read.Answer: C     5. Which of the following best describes why InnoDB tables should always have primary keys and why they should be short?A. Because InnoDB uses primary keys to locate tables, and shorter keys make quicker lookups.B. Because InnoDB uses primary keys to locate table rows, and shorter keys make quicker lookups.C. Because InnoDB stores pointers in a log to all the primary keys and shorter keys make this log smaller.Answer: B      6. Which of the following best describes how the relay log works?A. It records the times when the slave connects to the master.B. When a slave receives a change from the master, it is recorded in the relay log first and processed later.C. When a slave receives a change from the master, it is processed first and then recorded in the relay log.Answer: B

Categories : 310-811