How to pass SUN 310-811 Real Exam in 24 Hours [free practice questions 51-60]

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW 310-811 Exam Dumps (PDF & VCE):
Available on: https://www.certleader.com/310-811-dumps.html


Exambible older SUN lecturers as well as specialists can accept that Exambible SUN 310-811 exam answers and questions are nearly proper. The actual complete fee regarding Sun Certified MySQL 5.0 Database Administrator Part II has been nearly 95 %. Over al, were able to demonstrate the 310-811 examine components made beneficial reference regarding SUN prospects. Our 310-811 pdf well worth the examinees sparing no effort to study. It is possible to guess your boot you will have good result from the Exambible Sun Certified MySQL 5.0 Database Administrator Part II apply tests.

2016 Jun 310-811 exam cost

Q51. What should you do in order to enhance the security of a Standard MySQL installation on Unix-type operating systems? 

A. Disable tine mysql_access program.

B. Run the mySql_secure_installation script.

C. Nothing; by default the security level of a MySQL installation is very high.

Answer: B


Q52. Consider the following query:

GRANT ALL ON world.* TO 'web'@'hostname'

What privileges would this give this user?

A. All privileges including GRANT.

B. All privileges except GRANT.

C. SELECT, INSERT, UPDATE and DELETE.

D. ALL can not be used when granting privileges.

Answer: B


Q53. In regards to security, which of the following statements are true?

A. mysqld should not be run as root or administrator. 

B. mysqld should be run as root or administrator.

C. The user owning the server process should own all files and directories to which the server may write.

D. The root or administrator users should own all files related to the server process

Answer: AC


Q54. Is it a good idea to do periodic table rebuilds for InnoDB tables? Why? 

A. No, because the indexes have to be rebuilt.

B. No. because there is a risk for data corruption.

C. Yes, because it flushes the logs and frees memory.

D. Yes, because the table may become fragmented after many INSERTs and DELETEs. 

Answer: D


Q55. Which of the following best describe what could cause low utilization of query cache? 

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: AD


310-811  test questions

Updated 310-811 sample question:

Q56. When working with stored routines, which of the following are true in regards to the effect on the amount of data exchanged between client and server?

A. They may increase the amount of data exchanged.

B. They can help reduce the amount of data exchanged.

C. They have no effect on the amount of data exchanged.

Answer: B


Q57. Which of the following best describes the meaning of the values in the ref columns?


A. City.CountryCode is used to sort what rows are returned from the City table. 

B. No Indexed columns are used to choose rows from City and the City.CountryCode column is used to reference rows in the Country table. 

C. No index columns are used to choose rows from Country and the City.CountryCode column is used to reference rows in the city table.

Answer: B


Q58. Which of the following are reasons to be selective when granting the FILE privilege to accounts? 

A. It could be used to execute scripts on the server host. 

B. It could be used to read files on the filesystem of the server host. 

C. It could be used to write files to the filesystem of the server host.

Answer: BC


Q59. How can the strict SQL mode provide added security?

A. By restricting out of range values. 

B. By restricting incorrect data types.

C. By limiting the operations that the server can perform. 

D. By rejecting actions that do not have values for columns without a default. 

Answer: ABD


Q60. Which of following describe the correct single-statement syntax for allowing the existing user 'kofi'@'%' to perform SELECT, INSERT, DELETE and UPDATE actions on all tables in the world database? 

A. GRANT SELECT, INSERT, DELETE, UPDATE ON world.* TO 'kofi'@'%'.

B. GRANT SELECT INSERT DELETE UPDATE ON world.* TO 'kofi'@'%'. 

C. GRANT world.* (SELECT, INSERT, DELETE, UPDATE) TO 'kofi'@'%'. 

D. GRANT (SELECT, INSERT, DELETE. UPDATE), ON world.* TO 'kofi'@'%'.

E. Unless using ALL PRMLEGES, it is not possible to assign more man one type of privilege at any one time.

Answer: A



see more Sun Certified MySQL 5.0 Database Administrator Part II